select d.file_name,d.tablespace_name,d.autoextensible from dba_temp_files d;
select d.file_name,d.tablespace_name,d.autoextensible from DBA_DATA_FILES d;
drop tablespace tablespace_name including contents and datafiles;
ALTER TABLESPACE users ADD DATAFILE
'/app/oradata/orclnew/orclnew/users02.dbf'
size 7167M autoextend on ;
SELECT sid, serial#, username, osuser FROM v$session where sid in (select session_id from v$locked_object);
刪除連接的session
ALTER SYSTEM KILL SESSION '9,4335';
導出oracle數據
exp xxx/xxx@orclnew file=/app/backup.dmp owner=xxx rows=n
當導出報錯信息是 EXP-00091: Exporting questionable statistics時，執行下面的語句
select userenv('language') from dual;
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK