OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Import only data (Oracle 9i, Win 2003)

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

Import only data [message #303723]

Sun, 02 March 2008 06:58

durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere

Senior Member

Hi,

Will this command help to just import data in the already imported database

imp advant/mse@dbase2 file=d:\d.dmp full=n rows=y log=d:\ll.log

- Das

Report message to a moderator

Re: Import only data [message #303734 is a reply to message #303723]

Sun, 02 March 2008 08:41

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Will this command help to just import data in the already imported database

This command imports all what is in your file, not just data.

Regards
Michel

Report message to a moderator

Re: Import only data [message #303753 is a reply to message #303734]

Sun, 02 March 2008 12:14

durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere

Senior Member

Thanks for the reply

Is there a way to just import data?

Report message to a moderator

Re: Import only data [message #303755 is a reply to message #303753]

Sun, 02 March 2008 12:16

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No.
Use "ignore=yes" to avoid error messages if your objects are already created but this will still create the non-existent objects.

Regards
Michel

Report message to a moderator

Re: Import only data [message #303800 is a reply to message #303723]

Sun, 02 March 2008 22:35

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

You can get your desired objects row by providing tables parameter.

tables=(list of tables) ignore=y

Report message to a moderator

Re: Import only data [message #303841 is a reply to message #303800]

Mon, 03 March 2008 00:33

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Which still add constraints, indexes and other table related objects if they don't exist (but does not create procedures, views, synonyms...).

Regards
Michel

Report message to a moderator

Previous Topic:	sql server data into oracle 9i
Next Topic:	Contents of the dump file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 03:11:56 CDT 2024