gabrieledefelice
asked on
Moving oracle database from one server to another
Im a beginner to oracle and need to move a database from one server to another. Step by step, is there an easy way to do it?
gab
gab
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
no detail of any kind. useless
the easy away is make an export/inport.
1. create the DB on the server that you wont
2. Make an remote Export form the source database to the target database as system
"exp system/manager@oldserver full=y ......."
3. in the new server import the data
"imp system/manager ....."
You also can copy the information using a connect string.
like this
On the target DB
CREATE TABLE XPTO as
SELECT * FROM XPTO@OLDSERVER
If this is not enough, please provide more information.
Exists more soluctios ....