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

0 vote361 views1 answer
Oracle list datafiles
SQL
14 votes340 views1 answer
Sql value of string
SQL
3 votes335 views2 answers
Sql paging query
SQL
1 vote314 views1 answer
Delete mysql from mac
SQL
0 vote347 views1 answer
Postgres can integer fields be negative
SQL
0 vote346 views1 answer
How to update date value in sql
SQL
0 vote317 views1 answer
How to to get current date and time in sql
SQL
0 vote360 views1 answer
.sql File Run in PSQL
SQL
1 vote348 views1 answer
Create new table from old table with data
SQL
0 vote368 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL