/SQL/Alter tablespace add datafile autoextend

Alter tablespace add datafile autoextend

SELECT * FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'my_tbs' ORDER BY FILE_NAME;

ALTER TABLESPACE my_tbs ADD DATAFILE '/path/to/my_file.dbf' 
	SIZE 100M AUTOEXTEND OFF;
-- Autoextend with max size:
ALTER TABLESPACE my_tbs ADD DATAFILE '/path/to/my_file.dbf' 
	SIZE 10G AUTOEXTEND ON NEXT 1G MAXSIZE 32000M;    
-- For TEMP tablespace:
ALTER TABLESPACE my_tbs ADD TEMPFILE '/path/to/my_file.dbf' 
	SIZE 100M AUTOEXTEND OFF;

Source: dba-oracle.com

Similar codes

4 votes293 views2 answers
Postgresql default value
SQL
0 vote294 views2 answers
Transaction php
SQL
0 vote298 views1 answer
Mysql terminal run sql file
SQL
0 vote304 views1 answer
List all permissions on a table in postgres
SQL
5 votes347 views1 answer
Oracle ora-00054 find
SQL
0 vote291 views1 answer
Export partttion and import in oracle
SQL
0 vote302 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
1 vote249 views1 answer
Strict in postgres SQL
SQL
0 vote324 views2 answers
Generate sql trigger through ef migration
SQL
0 vote309 views1 answer
Closure in sql
SQL