USER별 데이타 백업

(4)[stone]/ > exp

Export: Release 8.1.7.0.0 - Production on Thu Feb 7 18:29:56 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Username: stone
Password:

Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp >

(2)U(sers), or (3)T(ables): (2)U >

Export grants (yes/no): yes >

Export table data (yes/no): yes >

Compress extents (yes/no): yes > no

Export done in KO16KSC5601 character set and KO16KSC5601 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user STONE
. exporting object type definitions for user STONE
About to export STONE's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export STONE's tables via Conventional Path ...
. . exporting table IW_EVENT_CATEGORIES 252 rows exported
. . exporting table IW_LOCK_TREE 0 rows exported
. . exporting table IW_MONITOR_VERSION 1 rows exported
. . exporting table IW_PLAN_TABLE 0 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 snapshots
. 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.
(5)[stone]/ > ls
TT_DB etc lib old sbin xfn
bin expdat.dmp lost+found opt tmp
cdrom export mbox platform usr
dev home mnt proc var
devices kernel net qtmp vol
(6)[stone]/ > ls -l expdat.dmp
-rw-r--r-- 1 root other 61440 2월 7일 18:31 expdat.dmp
(7)[stone]/ >