OraFAQ Forum: Server Utilities » import single table from dump file

Home » RDBMS Server » Server Utilities » import single table from dump file

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

import single table from dump file [message #71669]

Fri, 13 December 2002 10:11

francesco
Messages: 5
Registered: December 2000

Junior Member

I have exported an entire db schema with exp function, now i'm trying to import in my new schema only a single table from this dmp file.
Is this possible???
Thank you.

Report message to a moderator

YES ! it's possible ! [message #71675 is a reply to message #71669]

Mon, 16 December 2002 03:38

B
Messages: 327
Registered: August 1999

Senior Member

use

imp USER/PASSWORD fromuser=old.owner touser=new.owner tables='TABLE_NAMES' commit=y rows=y ignore=y

the new schema should be created first ... with adhoc grants...

Report message to a moderator

Re: YES ! it's possible ! [message #71682 is a reply to message #71675]

Wed, 18 December 2002 08:03

francesco
Messages: 5
Registered: December 2000

Junior Member

many thanx

Report message to a moderator

Previous Topic:	That makes sense ... otherwise am I doing this correctly?
Next Topic:	Oracle 9i "Character Set Migration Utility schema not installed"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 20:31:17 CDT 2024