ODU> unload dict
CLUSTER C_USER# file_no: 1 block_no: 89
TABLE OBJ$ file_no: 1 block_no: 121
CLUSTER C_OBJ# file_no: 1 block_no: 25
CLUSTER C_OBJ# file_no: 1 block_no: 25
found IND$’s obj# 19
found IND$’s dataobj#:2,ts#:0,file#:1,block#:25,tab#:3
found TABPART$’s obj# 266
found TABPART$’s dataobj#:266,ts#:0,file#:1,block#:2121,tab#:0
found INDPART$’s obj# 271
found INDPART$’s dataobj#:271,ts#:0,file#:1,block#:2161,tab#:0
found TABSUBPART$’s obj# 278
found TABSUBPART$’s dataobj#:278,ts#:0,file#:1,block#:2217,tab#:0
found INDSUBPART$’s obj# 283
found INDSUBPART$’s dataobj#:283,ts#:0,file#:1,block#:2257,tab#:0
found IND$’s obj# 19
found IND$’s dataobj#:2,ts#:0,file#:1,block#:25,tab#:3
found LOB$’s obj# 151
found LOB$’s dataobj#:2,ts#:0,file#:1,block#:25,tab#:6
found LOBFRAG$’s obj# 299
found LOBFRAG$’s dataobj#:299,ts#:0,file#:1,block#:2393,tab#:0
ODU> scan extent parallel 2
scan extent start: 2013-08-06 02:42:19
scanning extent…
scanning extent finished.
scan extent completed: 2013-08-06 02:43:23
ODU> unload table sys.source$
Unloading table: SOURCE$,object ID: 72
Unloading segment,storage(Obj#=72 DataObj#=72 TS#=0 File#=1 Block#=529 Cluster=0)
295765 rows unloaded
ODU> exit
[ora10g@killdb data]$ cp SYS_SOURCE$.sql create.sql
[ora10g@killdb data]$ sqlplus roger/roger
SQL*Plus: Release 10.2.0.5.0 Production on Tue Aug 6 02:56:52 2013
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @ create.sql
Table created.
SQL> exit