Oracle Datafile.
SELECT v.file#, t.file_name, v.status FROM dba_temp_files t, v$tempfile v WHERE t.file_id = v.file#; ALTER TABLESPACE "TEMP" ADD TEMPFILE 'C:\ORACLE\ORADATA\DBT\TEMP02.DBF' SIZE 1000M; select file_id,file_name,bytes from dba_data_files where tablespace_name='EXAMPLE'; ALTER TABLESPACE "EXAMPLE" ADD DATAFILE 'C:\ORACLE\ORADATA\DBT\EXAMPLE02.DBF' SIZE 1000M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE 32767M; ALTER DATABASE DATAFILE 'C:\ORACLE\ORADATA\DBT\EXAMPLE02.DBF' RESIZE 500M; ALTER DATABASE DATAFILE 'C:\ORACLE\ORADATA\DBT\EXAMPLE02.DBF' AUTOEXTEND ON MAXSIZE 5000M; ALTER DATABASE DATAFILE 'C:\ORACLE\ORADATA\DBT\EXAMPLE02.DBF' AUTOEXTEND OFF; |
||