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 vote146 views1 answer
Pass array parameter to stored procedure c#
SQL
3 votes132 views1 answer
Uppercase and lowercase in sql
SQL
1 vote135 views1 answer
Apex ORA-20999
SQL
1 vote136 views3 answers
Postgresql connect to database
SQL
5 votes141 views3 answers
Day of week postgresql
SQL
0 vote141 views1 answer
Power bi union columns
SQL
3 votes131 views1 answer
Index using in query plsql
SQL
0 vote152 views3 answers
Run sql command line
SQL
0 vote147 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote187 views1 answer
Cahnge column name apex oracle
SQL