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 vote134 views1 answer
Md5 encryption for existing records
SQL
-1 vote136 views1 answer
Auto increment psql not primary key
SQL
13 votes157 views3 answers
Sql select from multiple tables without join
SQL
19 votes133 views3 answers
Grant mysql
SQL
0 vote138 views1 answer
One table with another
SQL
4 votes130 views1 answer
Oracle show error line number
SQL
10 votes136 views4 answers
SELECT FROM WHERE
SQL
0 vote143 views1 answer
How to print sql query
SQL
8 votes121 views2 answers
Phpmyadmin password
SQL
0 vote128 views1 answer
Sql count more than 1
SQL