•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 426,133 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,773 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser: Programming Forums
Views: 1694 | Replies: 5
 |
•
•
Join Date: Mar 2007
Posts: 45
Reputation: 
Rep Power: 0
Solved Threads: 1
Light Poster
challenge.... hi,
how to export a table from sql*plus to an secondary memory like
cd ,floppy or hard disk. I challeneged with my friend I will tell u in a
week. if anybody knows please give the commands and what i need to do after creating a table in sql*plus. I am using oracle 8i software.
how to export a table from sql*plus to an secondary memory like
cd ,floppy or hard disk. I challeneged with my friend I will tell u in a
week. if anybody knows please give the commands and what i need to do after creating a table in sql*plus. I am using oracle 8i software.
•
•
Join Date: Mar 2005
Location: Nebraska, U.S.
Posts: 190
Reputation:
Rep Power: 4
Solved Threads: 4
Junior Poster
Re: challenge.... spool c:\anywhere\you\want\file.txt SELECT * FROM sql_statement; spool off
Then you can go to that directory and open it in notepad, or open it in Microsoft Excel and format it.
•
•
Join Date: Mar 2007
Posts: 45
Reputation:
Rep Power: 0
Solved Threads: 1
Light Poster
•
•
•
•
Originally Posted by stupidenator 
spool c:\anywhere\you\want\file.txt SELECT * FROM sql_statement; spool off
Then you can go to that directory and open it in notepad, or open it in Microsoft Excel and format it.
then what is the use of export and import commands?
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,290
Reputation:
Rep Power: 4
Solved Threads: 83
Do u want to take database backup or just copy the data to a text file ?
If u want the 2nd one then u can go with stupidenator
But when u say EXPORT it means taking database back up.
for this
SQL>HOST
U will get a black screen
type
EXP USERNAME/PASSWORD
THEN FOLLOW THE INSTRUCTIONS.
FOR HELP U CAN TYPE
EXP HELP=Y
Hope that helps you
If u want the 2nd one then u can go with stupidenator
But when u say EXPORT it means taking database back up.
for this
SQL>HOST
U will get a black screen
type
EXP USERNAME/PASSWORD
THEN FOLLOW THE INSTRUCTIONS.
FOR HELP U CAN TYPE
EXP HELP=Y
Hope that helps you
Share your Knowledge.
•
•
Join Date: Mar 2007
Posts: 32
Reputation:
Rep Power: 2
Solved Threads: 0
Light Poster
hai satish....me too need this SOLUTION plz.... right i m studying my final year UG degree. i have developed my project in VB and ORACLE 8i...now i want to execute my project in my college.... now wts the problem is i have to create tables every time in another system.... so i want to bind the selected tables (example,.. table1,table2,table3,emp_table.....) and want to extract in the naive user system.....help me plzzzzzzzzzzzzzz..how to do this........
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,290
Reputation:
Rep Power: 4
Solved Threads: 83
dear karan to solve the problem you are facing just follow the process described above and u you get a exported file with extension .DMP
next u can import all of your tables from that fiel to re create your entire database or only specific tables (depends on type of export choosen).
any where u need to run your application just use the IMPORT utility of oracle
SQL> host
import username/password@hoststring
then just follow the steps as prompted.
next u can import all of your tables from that fiel to re create your entire database or only specific tables (depends on type of export choosen).
any where u need to run your application just use the IMPORT utility of oracle
SQL> host
import username/password@hoststring
then just follow the steps as prompted.
Share your Knowledge.
|
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- Win $ 50 - Challenge To Techies (Windows NT / 2000 / XP / 2003)
- A challenge for all newbies (Computer Science and Software Design)
- Looking for SEO Challenge (Search Engine Optimization)
- I did it can U? (a challenge from me to you) (C)
- Solving Challenge Suggestion (DaniWeb Community Feedback)
- [Member of the Month - Feb '04] Popular Thread challenge! (Geeks' Lounge)
Other Threads in the Oracle Forum
- Previous Thread: Dynamic Table name
- Next Thread: How to write Data onto diferent Hard Drive
