Home » RDBMS Server » Server Utilities » import single table from dump file
import single table from dump file [message #71669] Fri, 13 December 2002 10:11 Go to next message
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.
YES ! it's possible ! [message #71675 is a reply to message #71669] Mon, 16 December 2002 03:38 Go to previous messageGo to next message
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...
Re: YES ! it's possible ! [message #71682 is a reply to message #71675] Wed, 18 December 2002 08:03 Go to previous message
francesco
Messages: 5
Registered: December 2000
Junior Member
many thanx
Previous Topic: That makes sense ... otherwise am I doing this correctly?
Next Topic: Oracle 9i "Character Set Migration Utility schema not installed"
Goto Forum:
  


Current Time: Mon Dec 23 18:00:05 CST 2024