Home » RDBMS Server » Server Utilities » Importing dump (10g)
Importing dump [message #356340] Thu, 30 October 2008 07:16 Go to next message
shreenilesh
Messages: 2
Registered: October 2008
Location: PUNE
Junior Member
Hi,

I successfully imported the schema with the structure of tables only in my 10g database.

Now my requirement is i also need the data in tables.I have another dump with data.

Can anybody tell me the way out?

Thanks,
Nilesh
Re: Importing dump [message #356341 is a reply to message #356340] Thu, 30 October 2008 07:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use ignore=y during import.
By default, row=y.
Ignore=y will just ignore the errors due to presence of objects.
Re: Importing dump [message #357917 is a reply to message #356340] Fri, 07 November 2008 03:53 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi,

how do you export structure separately and data separately?

yours
dr.s.raghunathan
Re: Importing dump [message #357924 is a reply to message #357917] Fri, 07 November 2008 04:44 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>how do you export structure separately
Use rows=n.
No data is exported
>>data separately?
You cannot. Logically, it does not make any sense to Oracle.
Previous Topic: import problem
Next Topic: SQL*Loader
Goto Forum:
  


Current Time: Wed Dec 07 12:33:45 CST 2016

Total time taken to generate the page: 0.27005 seconds