Database Import Export:
1. Copy some of the data in a database to another database (such as copying a table to another) COPY {from database | to database {append | create | insert | replace} destination_table (Column, Column, Column, ...)] USING Query
E.g:
Copy frrom username / pwd @ service1 to username / pwd @ service2 insert table1 using select * from tables where tablecol = 'adsdsa'
2.DBLINK CREATE PUBLIC DATABASE LINK CONNECT To Test Identified by Test Using 'ServicesEname'
3.EXP / IMP
4.SQLLDR Userid = System / Admin @ServiceName Control = D: /1.CTL
5. Tools, such as Golden, SQLServer, PL / SQL DevelopPolds-> Text Importer, PB can also be used to pour data
