I would like to know if it is possible to import a DB using the command impdp into a specific Oracle instance? Currently, I have 3 DB instances and I would like to import it to only one specific instance.
Thanks in advance!
4
-
What do you mean by "specific Oracle instance"? The only time that "instance" and "database" are not synonyms in Oracle is when you have one database using RAC to create multiple instances. If you are asking whether you can import into just one instance in a RAC cluster, the answer would be no because RAC is a shared storage architecture.Justin Cave– Justin Cave2014-10-09 19:36:49 +00:00Commented Oct 9, 2014 at 19:36
-
Hi Justin, what I mean is since I have several instance on my Oracle as show below. I would like to import the DB into Instance "Test". Is it possible ? Thanks! Service "oracledb" has 2 instance(s). Instance "test", status BLOCKED, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVER Instance "oracledb", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:84419 refused:0 state:ready LOCAL SERVERJoie Tamayo– Joie Tamayo2014-10-09 19:43:31 +00:00Commented Oct 9, 2014 at 19:43
-
Hi Justin, the reason I's asking is because there exists the same tables in instance "oracle". I want to import the DB into instance test so not to override what's in instance "oracle". Thanks!Joie Tamayo– Joie Tamayo2014-10-09 19:55:11 +00:00Commented Oct 9, 2014 at 19:55
-
@Joie Tamayo, is there any solution for this. I am having 2 oracle instances. I want to import to the 1st instance. But whenever i doing that, it is giving connnection error.RobinHood– RobinHood2016-01-11 11:59:30 +00:00Commented Jan 11, 2016 at 11:59
Add a comment
|
