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??

Report message to a moderator

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

Report message to a moderator

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=(*)

Report message to a moderator

Previous Topic: Importing to different tablespace with no quota
Next Topic: Question about importing schemas
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 09:50:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.