Export Table in Oracle 8i [message #72020] |
Mon, 24 February 2003 14:37 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
denni50
Messages: 18 Registered: November 2002
|
Junior Member |
|
|
Hello
How would one go about exporting one table for
import into another db. We are using 8i v8.1.7
Windows NT4
thanks
|
|
|
Re: Export Table in Oracle 8i [message #72021 is a reply to message #72020] |
Mon, 24 February 2003 14:46 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/42800.jpg) |
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
do export
drop the table in target
import to the target
C:>exp mag/mag tables=(emp) file=s.dmp
Export: Release 8.1.6.0.0 - Production on Fri Feb 21 16:32:27 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table EMP 14 rows exported
Export terminated successfully without warnings.
C:>imp mag/mag tables=(emp) file=s.dmp
Import: Release 8.1.6.0.0 - Production on Fri Feb 21 16:33:40 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Export file created by EXPORT:V08.01.06 via conventional path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
. importing MAG's objects into MAG
. . importing table "EMP" 14 rows imported
Import terminated successfully without warnings.
C:>
|
|
|