Home » RDBMS Server » Server Utilities » A few doubts in importing and exporting data (Oracle 9i2, Win 2000 server)
A few doubts in importing and exporting data [message #293373] Fri, 11 January 2008 21:49 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
I used the 'EXP' command (EXP practice1/practice1@dbase) to export data from a database table to a txt file. The steps were pretty simple and the data got exported but not without a few questions

1) The file was created in the 'C:\' drive, which is not the home of Oracle, Why?

2) The file contains data and a few other characters, diagram, signs etc what are these and why are they in the file with the data?

While using SQLLDR to load data into another dummy table I used the same exported file. A few questions on that as well

1) How can I make commit unlimited (or define rows in the controlfile) as I am getting the commit point read at just 42 records whereas I have 2000 records

2) While displaying the data from the new table with the uploaded data I head noises from by CPU..it seems that this is because it is trying to display the diagrams and signs that were there in the file. How to avoid this as I just want the data.

Thanks a lot for your time

- Das

PS: Control file attached
Re: A few doubts in importing and exporting data [message #293375 is a reply to message #293373] Fri, 11 January 2008 22:00 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
1. C:\ was the location where you were sitting when you executed the exp command.

2. The file is not a txt file. It is an Oracle proprietary binary format.

1. SQLLDR will not be able to load an export file.

2. It's because of the #2 above.

You should read over Export documentation.
Re: A few doubts in importing and exporting data [message #293376 is a reply to message #293375] Fri, 11 January 2008 22:11 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks a lot


- Das

Re: A few doubts in importing and exporting data [message #293389 is a reply to message #293376] Sat, 12 January 2008 00:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64108
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You'll get benefit in reading Database Utilities.

Regards
Michel
Re: A few doubts in importing and exporting data [message #293417 is a reply to message #293389] Sat, 12 January 2008 07:28 Go to previous message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks, I will.

- Das
Previous Topic: External table data location
Next Topic: Getting error during importing
Goto Forum:
  


Current Time: Mon Dec 05 05:14:24 CST 2016

Total time taken to generate the page: 0.14944 seconds