Use DB_LINK to copy data in databases on different platforms

Linux community (www.linuxidc.com) is a professional Linux System Portal website that publishes the latest Linux information in real time, including Linux, Ubuntu, Fedora, RedHat, Red Flag Linux, Linux tutorial, Linux certification, SUSE

Linux community (www.linuxidc.com) is a professional Linux System Portal website that publishes the latest Linux information in real time, including Linux, Ubuntu, Fedora, RedHat, Red Flag Linux, Linux tutorial, Linux certification, SUSE

[Oracle @ Template-RedHat54 admin] $ lsnrctl

LSNRCTL for Linux: Version 11.2.0.1.0-Production on 13-APR-2012 23:09:14

Copyright (c) 1991,200 9, Oracle. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (ADDRESS = (PROTOCOL = tcp) (HOST =) (PORT = 1521 ))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0-Production
Start Date 13-APR-2012 19:23:20
Uptime 0 days 3 hr. 45 min. 56 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
# Tnsnames. ora Network Configuration File:/oracle/product/11.2.0/dbhome_1/netwo
Rk/admin/tnsnames. ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = Template-Redhat54) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
WIN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = WINDOWS) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)

~
~
"Tnsnames. ora" 20L, 503C written
[Oracle @ Template-Redhat54 admin] $ tnsping WIN

TNS Ping Utility for Linux: Version 11.2.0.1.0-Production on 13-APR-2012 23:10
: 13

Copyright (c) 1997,200 9, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = WINDOWS) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL )))
OK (10 msec)
[Oracle @ Template-Redhat54 admin] $ sqlplus/as sysdba

SQL * Plus: Release 11.2.0.1.0 Production on Fri Apr 13 23:10:18 2012

Copyright (c) 1982,200 9, Oracle. All rights reserved.

Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
And Real Application Testing options

SQL> create database link WIN connect to system identified by system using "WIN ";
Create database link WIN connect to system identified by system using "WIN"
*
ERROR at line 1:
ORA-02010: missing host connect string

SQL> create database link WIN connect to system identified by system using 'win ';

Database link created.

SQL> select * from dual @ WIN;

D
-
X

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
And Real Application Testing options
[Oracle @ Template-Redhat54 admin] $ sqlplus/as sysdba

SQL * Plus: Release 11.2.0.1.0 Production on Fri Apr 13 23:14:00 2012

Copyright (c) 1982,200 9, Oracle. All rights reserved.

Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
And Real Application Testing options

SQL> create public database link WIN connect to system identified by system using "WIN ";
Create public database link WIN connect to system identified by system using "WIN"
*
ERROR at line 1:
ORA-02010: missing host connect string

SQL> create public database link WIN connect to system identified by system using 'win ';

Database link created.

SQL> select * from dual @ WIN;

D
-
X

SQL> drop database link WIN;

Database link dropped.

SQL> select * from dual @ WIN;

D
-
X

SQL> exit5
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
And Real Application Testing options
[Oracle @ Template-Redhat54 admin] $ impdp system/system network_link = WIN schemas = datarepository

Import: Release 11.2.0.1.0-Production on Fri Apr 13 23:15:38 2012

Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
And Real Application Testing options
Starting "SYSTEM". "SYS_IMPORT_SCHEMA_01": system/******** network_link = WIN schemas = datarepository
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 384 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/TABLE
.. Imported "DATAREPOSITORY". "CONNECTIONSTRING" 8 rows
.. Imported "DATAREPOSITORY". "IBS_DB_VERSION" 23 rows
.. Imported "DATAREPOSITORY". "smp_sys_cnfg" 557 rows
Processing object type SCHEMA_EXPORT/TABLE/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
ORA-39082: Object type PACKAGE_BODY: "DATAREPOSITORY". "PKG_DDL" created with compilation warnings
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYSTEM". "SYS_IMPORT_SCHEMA_01" completed with 1 error (s) at 23:17:05

For more information about Oracle, see the Oracle topic page? Tid = 12

,