1.ps -ef|grep pmon
2.su - oracle
3.export ORACLE_SID=TWJDE
4.sqlplus "/ as sysdba" 后面不加;,加了不work
select owner,object_name,status from dba_objects where object_name like '%F91320'
3. desc SY810.F91300
4.col JSSCHROLE for a5
set long 999
set lines 140
set pages 9999
5.select * from sy810.F91320 where rownum < 5;
SELECT SUM(BYTES) FROM DBA_SEGMENTS WHERE OWNER='SY810' AND SEGMENT_NAME IN ('F91300','F91320');
!df -g
select * from nls_database_parameters;
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
exp \'/ as sysdba\' du
exp help=y
check the table size:
SQL> desc dba_segments
SQL> select sum(bytes/1024/1024)MB from dba_segments where segment_name='F91320';
to be continue .....