Home » RDBMS Server » Server Utilities » import only data
import only data [message #232451] Fri, 20 April 2007 10:16 Go to next message
moody1
Messages: 15
Registered: March 2007
Junior Member
I need to import only the data from an export that I've created. Can someone please help me? 9.2.06
Re: import only data [message #232452 is a reply to message #232451] Fri, 20 April 2007 10:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If you want to import only data then you should already have the structure (table...).
Then try "ignore=y" this will ignore all errors on "create table" and others.
To prevent imp from importing other DDL then try "imp help=y" and put "n" in all options (indexes=n grants=n ...).

There is no option to say "only rows" (unless you migrate to 10g and use Data Pump).

Regards
Michel

Re: import only data [message #232865 is a reply to message #232451] Mon, 23 April 2007 12:39 Go to previous message
moody1
Messages: 15
Registered: March 2007
Junior Member
Thank you very much.
Previous Topic: export/import tablespace
Next Topic: (unknown sender) Oracle Notification in 9i
Goto Forum:
  


Current Time: Wed Dec 25 11:37:35 CST 2024