Shulou(Shulou.com)06/01 Report--

View the storage path of the data file

Select FILE_ID,FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE from dba_data_files order by file_id

Create tablespace table name datafile 'absolute path' size size (M) G) AUTOEXTEND ON NEXT 100m

Alter temporary tablespace temp add tempfile'/ oracle/smp/sapdata1/system_1/temp.data1' size 100m AUTOEXTEND ON NEXT 100m

Query the storage path of the table space

Select FILE_ID,FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE from dba_data_files order by file_id

Query the storage path of temporary tablespace

Select FILE_ID,FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE from dba_temp_files order by file_id

For example: + DATA_DG01/ebiz/datafile/appmon.876.868135365

Delete temporary tablespace

DROP TEMPORARY TABLESPACE temp INCLUDING CONTENTS and datafiles

Delete tablespace

DROP TABLESPACE users INCLUDING CONTENTS and datafiles

Create a tablespace

CREATE TABLESPACE USERS DATAFILE'/ oracle/Q99/sapdata1/system_1/users.data1' SIZE 100m AUTOEXTEND ON NEXT 100m

Common temporary tablespaces

CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE'F:\ ORACLE\ SMP\ SAPDATA1\ TEMP_1\ temp1.data1' SIZE 100m AUTOEXTEND ON NEXT 100m

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.