| A few doubts in importing and exporting data [message #293373] |
Fri, 11 January 2008 21:49  |
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
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
