bbed使用

SQL> select owner,header_file, header_block from dba_segments where segment_name = 'T';

OWNER			       HEADER_FILE HEADER_BLOCK
------------------------------ ----------- ------------
SCOTT					 4	   1866
TEST					10	    256

SQL> show user
USER 为 "TEST"

BBED> set file 10 block 257
BBED-00312: no LISTFILE specified

SQL> select file#||' '||name||' '||bytes from v$datafile ;

FILE#||''||NAME||''||BYTES
--------------------------------------------------------------------------------
1 /oradata/june/system01.dbf 744488960
2 /oradata/june/sysaux01.dbf 597688320
3 /oradata/june/undotbs01.dbf 2034237440
4 /oradata/june/users01.dbf 3354132480
5 /oradata/june/example01.dbf 104857600
6 /oradata/june/test.dbf 209715200
7 /oradata/june/users02.dbf 4294967296
8 /oradata/june/example02.dbf 2147483648
9 /oradata/june/test1.dbf 1073741824
10 /oradata/june/test2.dbf 1073741824

已选择10行。

[oracle@june2