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

Report message to a moderator

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: 10708
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.

Report message to a moderator

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

Report message to a moderator

Re: Importing dump [message #357924 is a reply to message #357917] Fri, 07 November 2008 04:44 Go to previous message
Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Previous Topic: import problem
Next Topic: SQL*Loader
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 10:56:40 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.