how to logon Oracle DB

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 .....