There's a database called
FOO in an Oracle XE 10g server that's due to be decommissioned (
old.example.com). I've been asked to migrate it to some other Oracle XE 11g server (
new.example.com). Both servers are on the same LAN. I don't know anything about the database (it isn't a project of mine). There isn't a DBA in the room. My random Google searches suggest it's a terribly complicated task. I can use SQL Developer or SQL*Plus.
I've figured out that using impdp over a network link might be a reasonably straightforward method. But docs take most stuff for granted and I can't make it work.
FOOin source server (role
DATAPUMP_EXP_FULL_DATABASEdoes not seem to exist in 10g).
I've created a temporary user called
tmp_impin target server with
CREATE DATABASE LINKand
I'm stuck in the create database link part. I've logged into
tmp_impand tried all possible combinations of the CREATE DATABASE LINK statement. They either trigger
ORA-00933: SQL command not properly endedor are accepted but produce a non-working link (
ORA-39001: invalid argument value,
ORA-39200: Link name "OLD_FOO" is invalid.,
ORA-12154: TNS:could not resolve the connect identifier specified).
This is one of my attempts:
CREATE DATABASE LINK OLD_FOO CONNECT TO FOO IDENTIFIED BY 'pa$$w0rD' USING '//old.example.com:1521/xe';
What am I doing wrong? Is there a simpler tool to migrate the database?