Home » RDBMS Server » Server Utilities » Import data in oracle 9i
Import data in oracle 9i [message #243194] Wed, 06 June 2007 07:42 Go to next message
kanis
Messages: 61
Registered: November 2006
Member
I want to import data into oracle database.
I want to import only all tables(not selectively) into database. could any help me in this??
Re: Import data in oracle 9i [message #243201 is a reply to message #243194] Wed, 06 June 2007 07:59 Go to previous messageGo to next message
rahul_bahulekar
Messages: 18
Registered: January 2007
Junior Member
u can refer below example-

imp system/system@connect_string file=abc.dmp log=abc.dmp fromuser=schema_name1 touser=schema_name1 grants=y ignore=y statistics=none

Re: Import data in oracle 9i [message #243232 is a reply to message #243201] Wed, 06 June 2007 10:14 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
imp SYSTEM/password FILE=scott.dmp FROMUSER=scott TOUSER=blake TABLES=(*)
Previous Topic: Importing to different tablespace with no quota
Next Topic: Question about importing schemas
Goto Forum:
  


Current Time: Tue Dec 06 06:36:57 CST 2016

Total time taken to generate the page: 0.07403 seconds