Exporting/Importing Data from Oracle [message #72935] |
Thu, 18 December 2003 06:19 |
Vivek nath
Messages: 9 Registered: August 2002
|
Junior Member |
|
|
I am interested in exporting data from one Oracle Data base and importing it into another oracle database.The oracle versions are 8.1.7.Now my new database has data already present and i do not want it to be overwritten.I just want the new data to be appended/added to the new database tables.Is it possible from the export/import utility???
|
|
|
|
Re: Exporting/Importing Data from Oracle [message #72937 is a reply to message #72935] |
Thu, 18 December 2003 07:16 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
bash-2.03$
bash-2.03$ exp mag/mag tables=l1
Export: Release 9.2.0.1.0 - Production on Thu Dec 18 12:16:22 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table L1 3 rows exported
Export terminated successfully without warnings.
----------------------------------------------------------------------
bash-2.03$ imp mag/mag file=expdat.dmp fromuser=mag touser=mag ignore=y
Import: Release 9.2.0.1.0 - Production on Thu Dec 18 12:17:06 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. . importing table "L1" 3 rows imported
Import terminated successfully without warnings.
bash-2.03$ sqlplus mag/mag
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Dec 18 12:17:18 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
mag@mutation_mutation > select * from l1;
DEPTNO DNAME
---------- ---------------------------------------------------------------------
-----------
20 RESEARCH
30 SALES
40 OPERATIONS
20 RESEARCH
30 SALES
40 OPERATIONS
6 rows selected.
|
|
|