/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

10 votes205 views2 answers
Forgot my mysql password mac
SQL
1 vote203 views1 answer
Get rows affected mysql python
SQL
0 vote196 views1 answer
Remove from table where
SQL
3 votes180 views4 answers
Show columns from table
SQL
0 vote204 views1 answer
SqlFunction does not exist
SQL
5 votes206 views2 answers
Sql server check port number
SQL
0 vote212 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote211 views1 answer
Sql server alter table column nullable
SQL
4 votes198 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote190 views1 answer
Import in mysql without a software
SQL