OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » import only data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

import only data [message #232451]

Fri, 20 April 2007 10:16

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

Report message to a moderator

Re: import only data [message #232452 is a reply to message #232451]

Fri, 20 April 2007 10:25

Michel Cadot
Messages: 68770
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

Report message to a moderator

Re: import only data [message #232865 is a reply to message #232451]

Mon, 23 April 2007 12:39

moody1
Messages: 15
Registered: March 2007

Junior Member

Thank you very much.

Report message to a moderator

Previous Topic:	export/import tablespace
Next Topic:	(unknown sender) Oracle Notification in 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 14 22:03:21 CST 2025