Home » RDBMS Server » Server Utilities » issue with import (oracle 10.1.0.2.0)
issue with import [message #408668] Wed, 17 June 2009 05:00 Go to next message
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 #408679 is a reply to message #408668] Wed, 17 June 2009 05:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You cannot incrementally import.
You do not need to delete the users.
Just drop the objects in schema and import.
Re: issue with import [message #408701 is a reply to message #408679] Wed, 17 June 2009 06:22 Go to previous messageGo to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member

Hi,

thank you for quick reply but have lot of objects in one user, it take too time to do that,please any idea except that.
Re: issue with import [message #408708 is a reply to message #408701] Wed, 17 June 2009 06:39 Go to previous message
Mahesh Rajendran
Messages: 10672
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

Previous Topic: IMP-00098: INTERNAL ERROR
Next Topic: sqlldr - exit error code 2 in unix (merged)
Goto Forum:
  


Current Time: Fri Dec 09 11:34:05 CST 2016

Total time taken to generate the page: 0.12009 seconds