/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

1 vote283 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
8 votes304 views1 answer
Oracle search stored procedures for text
SQL
0 vote270 views1 answer
Dump multiple tables mysql
SQL
0 vote266 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote263 views1 answer
Postgres call view
SQL
-1 vote259 views1 answer
Mysql coalesce
SQL
0 vote279 views2 answers
What is the default password for sql server sa
SQL
0 vote286 views1 answer
How to create a table based on another table in mysql
SQL
-1 vote255 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
12 votes259 views2 answers
Delete all data in neo4j
SQL