select * from ( Select a.tablespace_name, to_char(a.bytes/1024/1024,’99,999.999′) total_bytes, to_char(b.bytes/1024/1024,’99,999.999′) free_bytes, to_char(a.bytes/1024/1024 – b.bytes/1024/1024,’99,999.999′) use_bytes, to_char((1 – b.bytes/a.bytes)*100,’99.99′) || ‘%’ use from (select tablespace_name, sum(bytes) bytes from dba_data_files group by tablespace_name) a, (select tablespace_name, sum(bytes) bytes from dba_free_space group by tablespace_name)…

oracle tablespace isn’t enough，there are 2 reasons： 1. original tablespace is too small, hadn’t been set autoextend； error code: ORA-01653: unable to extend table 2. tablespace…

check relationship between tablespace and username. select username,default_tablespace from dba_users; SQL> select username,default_tablespace from dba_users; USERNAME DEFAULT_TABLESPACE —————————— —————————— NAME_A …

When I delete some archivelogs in order to release some diskspace, I encountered error, like this: RMAN-08137: WARNING: archived log not deleted, needed for standby or…

1、When you execute “sqlplus / as sysdba” to connect SQL,you can stop all processes of oracle with the following command if this error occured ps…

delete backup–DELETE command delete is used for deleting record and corresponding physical file of RMAN backup. It will generate RMAN backup record in RMAN repository…