| export and import suing sql developer [message #552980] |
Mon, 30 April 2012 11:54  |
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
|
Senior Member |
|
|
I need help for export and import , I have my local database i want to export tables , data, functions from this database and import inot new database.
I want to do this using sql developer , I tried export , by selecting table , data , functions a file export.sql is created. I cannot open this file as the file size is too large.
the new database 11g is empty has no tables , I want to import tables, data, functions etc.
I tried by selecting tables and import data pointing to the file export.sql I get this error.attached is the error.
|
|
|
|
|
|
| Re: export and import suing sql developer [message #553004 is a reply to message #552980] |
Mon, 30 April 2012 15:22  |
 |
thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC
|
Member |
|
|
You've created a script, and it's stored in the .SQL file.
Now you're trying to use the Import wizard which is designed to read delimited or structured data like Excel or CSV to import records from outside of Oracle.
Just connect to your empty 11g database as the user you want to import the data/objects to, and open the .SQL file in the worksheet.
Review the code, and if you approve, use F5 to execute.
OR
Go back to the beginning and export your objects/data to Excel or CSV, then try to use the IMPORT mechanism. I've done a quick write-up on our Import feature and Excel, http://www.thatjeffsmith.com/archive/2012/04/how-to-import-from-excel-to-oracle-with-sql-developer/
For better SQL Developer support, I suggest trying our message board on OTN.
[Updated on: Mon, 30 April 2012 15:34] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
