export / import tablespace in Oracle 9i DB ------------------------------------------ [oracle@igloo tmp]$ exp "'sys/oramelb as sysdba' TABLESPACES=GAST" [oracle@igloo tmp]$ ls -al expdat.dmp -rw-r--r-- 1 oracle oinstall 10706944 Oct 6 14:08 expdat.dmp [oracle@esker tmp]$ imp "'sys/oramelb as sysdba'" Import: Release 9.2.0.1.0 - Production on Mon Oct 6 14:18:44 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 Import file: expdat.dmp > Enter insert buffer size (minimum is 8192) 30720> 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) export client uses UTF8 character set (possible charset conversion) List contents of import file only (yes/no): no > Ignore create error due to object existence (yes/no): no > Import grants (yes/no): yes > Import table data (yes/no): yes > Import entire export file (yes/no): no > Username: gast Enter table(T) or partition(T:P) names. Null list means all tables for user Enter table(T) or partition(T:P) name or . if done: . importing SYS's objects into SYS . importing GAST's objects into GAST . . importing table "ADMINISTRATOR" 3 rows imported . . importing table "APPLICATION" 6 rows imported . . importing table "APPLICATION_GROUP" 7 rows imported . . importing table "APPLICATION_GROUP_ATTRIBUTE" 3 rows imported . . importing table "ATTRIBUTE" 32 rows imported . . importing table "ATTRIBUTE_VALUE" 303 rows imported . . importing table "CLASS" 6 rows imported . . importing table "DATA_TYPE" 7 rows imported . . importing table "DUMMY_TABLE" 1 rows imported . . importing table "GROUPS" 36 rows imported . . importing table "GROUP_ATTRIBUTE" 74 rows imported . . importing table "GROUP_RULE" 9 rows imported . . importing table "HIERARCHY" 1 rows imported . . importing table "HIERARCHY_LEVEL" 5 rows imported . . importing table "HIERARCHY_SECURITY_TMP" 0 rows imported . . importing table "HIERARCHY_VALUE" 12423 rows imported . . importing table "HIERARCHY_VALUE_TMP" 12423 rows imported . . importing table "INSTANCE" 70416 rows imported . . importing table "MEMBER_LINK" 64166 rows imported . . importing table "MEMBER_TYPE" 4 rows imported . . importing table "PERSONAL_DETAILS" 59040 rows imported . . importing table "PERSONAL_DETAILS_TMP" 59040 rows imported . . importing table "POSITION_DETAILS" 4433 rows imported . . importing table "POSITION_DETAILS_TMP" 4433 rows imported . . importing table "POSITION_LINK" 4135 rows imported . . importing table "POSITION_LINK_TMP" 4135 rows imported . . importing table "STUDENT_ACCOUNT_NAME" 7 rows imported . . importing table "STUDENT_COURSE_TMP" 10 rows imported . . importing table "STUDENT_CRS_AND_SUBJ_TMP" 6 rows imported . . importing table "STUDENT_EMAIL_ALIAS" 4 rows imported . . importing table "STUDENT_TMP" 0 rows imported . . importing table "TEMP_ID" 6 rows imported . . importing table "USERS" 84 rows imported Import terminated successfully without warnings. |