687 shaares
3 liens privés
3 liens privés
Modification TBS
SELECT tablespace, file_name FROM dba_temp_files;
SELECT tablespace, file_name FROM dba_data_files;
create tablespace STATSPACK datafile '<file>' size 250M reuse extent management local uniform size 1M;
# Temporary
create temporary tablespace STATSTEMP tempfile '<file>' size 50M reuse extent management local uniform size 1M;
ALTER TABLESPACE <tbs> ADD DATAFILE '<file>'SIZE 25M AUTOEXTEND OFF;
ALTER TABLESPACE <tbs> DROP DATAFILE '<file>' ;
ALTER DATABASE DATAFILE '<file>' RESIZE 225M;
ALTER DATABASE TEMPFILE '<file>' RESIZE 2048M;
DROP tablespace <tbs> INCLUDING CONTENTS and datafiles;