Oracle datafile max size 32gb

SELECT * FROM DBA_DATA_FILES;

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 32G;    
-- For TEMP tablespaces:
ALTER TABLESPACE my_tbs ADD TEMPFILE '/path/to/my_file.dbf' 
	SIZE 100M AUTOEXTEND OFF;

Similar codes

1 vote322 views1 answer
Oracle first row
SQL
3 votes354 views3 answers
Create a view postgres
SQL
0 vote333 views1 answer
Get number of rows in every table mysql
SQL
2 votes347 views1 answer
Codeigniter print last sql query
SQL
-1 vote321 views2 answers
On delete set default sql server
SQL
0 vote367 views1 answer
Left join vs inner join performance
SQL
0 vote328 views1 answer
Console output pl sql
SQL
0 vote351 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote335 views2 answers
How to get json data mysql
SQL
0 vote315 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL