export tablespace from oracle 9i DB and import to another tablespace on same db ------------------------------------------------------------------------------- [oracle@esker tmp]$ exp "'sys/goaway as sysdba' TABLESPACES=GAST" Export: Release 9.2.0.1.0 - Production on Tue Nov 4 18:10:11 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP 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 selected tablespaces ... For tablespace GAST ... ... Export terminated successfully with warnings. [oracle@esker tmp]$ imp "'sys/oramelb as sysdba' TABLESPACES=GASD" FROMUSER=GAST TOUSER=GASD Import: Release 9.2.0.1.0 - Production on Tue Nov 4 18:10:30 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP 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 GAST's objects into GASD ... Import terminated successfully with warnings. |