reg import utility [message #70809] |
Fri, 26 July 2002 03:31 |
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 |
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
|
|
|
|