patternMinor
Copying Oracle 11g express Database from one server to another
Viewed 0 times
from11gexpressdatabaseonecopyinganotherserveroracle
Problem
Basically, I am a MS-SQL developer,and relatively new to Oracle.
Even after great deal of research, I was unable to find any way of copying entire database from one server instance to another.
In MS-SQL this is usually done through "backup database" and "restore database" sql query. We can even use external tools such as Management studio to create scripts.
But, How this can be done in Oracle 11g express? Any ideas??
Even after great deal of research, I was unable to find any way of copying entire database from one server instance to another.
In MS-SQL this is usually done through "backup database" and "restore database" sql query. We can even use external tools such as Management studio to create scripts.
But, How this can be done in Oracle 11g express? Any ideas??
Solution
You do not state which version you use, so I assume you use version 10.x or 11.x.
Do a full export of your database using Oracle Data Pump, existing since Oracle 10:
Use
Do a full export of your database using Oracle Data Pump, existing since Oracle 10:
expdp (export dump) and then re-import it into another database using impdb (import dump).Use
expdp help=y to get the full set of parameters. Parameters are given in the form param=value, not --param=value as one would expect.Context
StackExchange Database Administrators Q#10057, answer score: 4
Revisions (0)
No revisions yet.