| issue with import [message #408668] |
Wed, 17 June 2009 05:00  |
oradba123
Messages: 86
Registered: June 2009
Location: india
|
Member |
|
|
Hi experts,
3 months back i have taken full export from my production database whichi runiing IBM-AIX server 5.3 and import on windows server whcih is for test purpose.but my manager said he needs the updated data on my windows server, but i take the latest export from prod database and import on test database,does duplicate data will come if primary ke y doesn't exist, so i dont want to delete all test database users it takes longtime for me to do.so please can any one have idea about having latets data on my test database from prodution database without deleting users or is there any parameter to specify while import.quick response will be higly appreciated.thanks a lot in advance.
|
|
|
|
|
|
|
|
| Re: issue with import [message #408708 is a reply to message #408701] |
Wed, 17 June 2009 06:39  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
No other option with import. You cannot incrementally import.
You can do with sql mechanisms. But not worth the effort as it will take more time,more manual work and pain.
Number of objects the schema has does not matter.
Size of the schema does matter with exp/imp.
Other options include using RMAN and transportable tablespaces ( with some restrictions and preconfiguration).
[Updated on: Wed, 17 June 2009 06:40] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
