Export import example

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>cd\

C:\>

C:\>exp scott/tiger tables=emp rows file='c:backup\scott_emp.dmp'

Export: Release 9.2.0.1.0 - Production on Mon Jan 11 12:31:36 2010

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 WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
EXP-00011: SCOTT.EMP does not exist
EXP-00011: SCOTT.ROWS does not exist
Export terminated successfully with warnings.

C:\>exp scott/tiger tables=dept rows file='c:\scott_dept.dmp'

Export: Release 9.2.0.1.0 - Production on Mon Jan 11 12:32:30 2010

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 WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                           DEPT          4 rows exported
EXP-00011: SCOTT.ROWS does not exist
Export terminated successfully with warnings.

C:\>exp 'sys/mysys as sysdba' owner=scott direct=y file='c:\backup\scott_user
p'

Export: Release 9.2.0.1.0 - Production on Mon Jan 11 12:35:26 2010

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 WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT
About to export SCOTT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SCOTT's tables via Direct Path ...
. . exporting table                          BONUS          0 rows exported
. . exporting table                           DEPT          4 rows exported
. . exporting table                       SALGRADE          5 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.


C:\>

C:\>IMP 'SYS/MYSYS AS SYSDBA' FROMUSER=SCOTT FILE='C:\BACKUP\SCOTT_USER.DBP

Import: Release 9.2.0.1.0 - Production on Mon Jan 11 12:55:14 2010

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 direct path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing SYS's objects into SYS
. importing SCOTT's objects into SCOTT
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
Import terminated successfully with warnings.

C:\>IMP 'SYS/MYSYS AS SYSDBA' FROMUSER=T FILE='C:\BACKUP\T_USER.DBP'

C:\>imp scott/tiger tables=dept rows file='c:\scott_dept.dmp'

Import: Release 9.2.0.1.0 - Production on Mon Jan 11 12:38:37 2010

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 WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing SCOTT's objects into SCOTT
. . importing table                         "DEPT"          4 rows imported
IMP-00033: Warning: Table "ROWS" not found in export file
Import terminated successfully with warnings.

C:\>
C:\>
C:\>
D\

C:\>IMP 'SYS/MYSYS AS SYSDBA' FROMUSER=T FILE=C:\backup\T_USER.DMP'

Import: Release 9.2.0.1.0 - Production on Mon Jan 11 13:06:22 2010

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

IMP-00002: failed to open C:\backup\T_USER.DMP' for read
Import file: EXPDAT.DMP > C:\backup\T_USER.DMP

Export file created by EXPORT:V09.02.00 via direct path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing SYS's objects into SYS
. importing T's objects into T
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
Import terminated successfully with warnings.

C:\>