Home » RDBMS Server » Server Utilities » Import only data (Oracle 9i, Win 2003)
Import only data [message #303723] Sun, 02 March 2008 06:58 Go to next message
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
Re: Import only data [message #303734 is a reply to message #303723] Sun, 02 March 2008 08:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
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
Re: Import only data [message #303753 is a reply to message #303734] Sun, 02 March 2008 12:14 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks for the reply

Is there a way to just import data?

Re: Import only data [message #303755 is a reply to message #303753] Sun, 02 March 2008 12:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
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
Re: Import only data [message #303800 is a reply to message #303723] Sun, 02 March 2008 22:35 Go to previous messageGo to next message
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
Re: Import only data [message #303841 is a reply to message #303800] Mon, 03 March 2008 00:33 Go to previous message
Michel Cadot
Messages: 64152
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
Previous Topic: sql server data into oracle 9i
Next Topic: Contents of the dump file
Goto Forum:
  


Current Time: Sat Dec 10 18:58:19 CST 2016

Total time taken to generate the page: 0.08703 seconds