| Export Table in Oracle 8i [message #72020] |
Mon, 24 February 2003 14:37  |
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  |
 |
Mahesh Rajendran
Messages: 10707
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:>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
