Home » RDBMS Server » Server Utilities » reg import utility
reg import utility [message #70809] Fri, 26 July 2002 03:31 Go to next message
Sanjay Kakkar
Messages: 2
Registered: July 2002
Junior Member
How to import the dmp file into exisiting tables.

Like I have a table name "T_SALE" in my databse and have collect the dmp of same table from diff users .Now i wanted to club the data of diff users into one table
Re: reg import utility [message #70813 is a reply to message #70809] Fri, 26 July 2002 12:17 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
u have to run a seperate import for each file with the command:

imp system/manager fromuser=source_schema touser=target_schema tables=(table1,table2) log=logfile file=dumpfile
Re: reg import utility [message #70827 is a reply to message #70809] Mon, 29 July 2002 02:14 Go to previous message
sunil bhola
Messages: 58
Registered: July 2002
Member
type

imp sunil@sunil buffer=100000 fromuser=sunil touser=sonu tables=(a,b)
Previous Topic: file structure
Next Topic: very urgent..........
Goto Forum:
  


Current Time: Sat May 04 03:40:44 CDT 2024