OraFAQ Forum: Backup & Recovery » importing only data not structures

Home » RDBMS Server » Backup & Recovery » importing only data not structures

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

importing only data not structures [message #168568]

Fri, 21 April 2006 00:26

fakhar55
Messages: 99
Registered: September 2005
Location: UAE

Member

hi all,
Can we import only data through .dmp without dropping the existing tables or schema. Actually i want to import the data of some tables and i have to drop the existing tables and then i make import. As the tables are dropped so i have to complie the reports that uses these tables after each import.
"Any help is appreciated a lot"
fakhar.

Report message to a moderator

Re: importing only data not structures [message #168614 is a reply to message #168568]

Fri, 21 April 2006 04:07

orausern
Messages: 826
Registered: December 2005

Senior Member

while doing the import, add the command:
ignore=y

Report message to a moderator

Re: importing only data not structures [message #168750 is a reply to message #168568]

Sat, 22 April 2006 00:58

fakhar55
Messages: 99
Registered: September 2005
Location: UAE

Member

thanks nirav. thanks a lot for your knowledge sharing. you can't imagine how much critical issue was that for me...
once again thanks a lot........
Razz

regards
fakhar.

Report message to a moderator

Re: importing only data not structures [message #168922 is a reply to message #168750]

Mon, 24 April 2006 03:52

orausern
Messages: 826
Registered: December 2005

Senior Member

you are welcome...thanks

Report message to a moderator

Previous Topic:	RMAN
Next Topic:	8i datafile to 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 10:42:23 CST 2024