한국어
Theme:
■ Export(USER) ■
C:ORAWIN95>exp system/manager Export: Release 7.3.3.0.0 - Production on Wed Sep 24 18:23:32 1997 Copyright (c) Oracle Corporation 1979, 1996. All rights reserved. Connected to: Personal Oracle7 Release 7.3.3.0.0 - 60 day trial license To purchase a production license, call 1-800-633-0586 (U.S. only) With the distributed and replication options PL/SQL Release 2.3.3.0.0 - Pr Enter array fetch buffer size: 4096 > [ENTER] Export file: EXPDAT.DMP > [ENTER] (1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > u Export grants (yes/no): yes > y Export table data (yes/no): yes > y Compress extents (yes/no): yes > y Export done in WE8ISO8859P1 character set About to export specified users ... User to be exported: (RETURN to quit) > scott About to export SCOTT's objects ... . exporting snapshots . exporting snapshot logs . exporting job queues . exporting refresh groups and children . exporting database links . exporting sequence numbers . exporting cluster definitions . about to export SCOTT's tables via Conventional Path ... . . exporting table BONUS 0 rows exported . . exporting table DEPT 6 rows exported . . exporting table EMP 14 rows exported . . exporting table SALGRADE 5 rows exported . exporting synonyms . exporting views . exporting stored procedures User to be exported: (RETURN to quit) > [ENTER] . exporting referential integrity constraints . exporting triggers . exporting posttables actions Export terminated successfully without warnings.
■ Export(TABLE) ■
C:ORAWIN95>EXP SCOTT/TIGER Export: Release 7.3.3.0.0 - Production on Wed Sep 24 18:26:58 1997 Copyright (c) Oracle Corporation 1979, 1996. All rights reserved. Connected to: Personal Oracle7 Release 7.3.3.0.0 - 60 day trial license To purchase a production license, call 1-800-633-0586 (U.S. only) With the distributed and replication options PL/SQL Release 2.3.3.0.0 - Pr Enter array fetch buffer size: 4096 > Export file: EXPDAT.DMP > (2)U(sers), or (3)T(ables): (2)U > 3 Export table data (yes/no): yes > Y Compress extents (yes/no): yes > Y Export done in WE8ISO8859P1 character set About to export specified tables via Conventional Path ... Table to be exported: (RETURN to quit) > EMP . . exporting table EMP 14 rows exported Table to be exported: (RETURN to quit) > DEPT . . exporting table DEPT 6 rows exported Table to be exported: (RETURN to quit) > Export terminated successfully without warnings.
