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 vote308 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote296 views1 answer
Select amount weeks between two dates mysql
SQL
2 votes286 views1 answer
Date_format for time sql
SQL
0 vote301 views1 answer
Open postgresql.conf in centos
SQL
0 vote300 views1 answer
Mysql select smaller of two values
SQL
9 votes547 views2 answers
Current date in postgresql minus 1 day
SQL
0 vote287 views1 answer
Add SuperUser MySQL
SQL
0 vote431 views1 answer
Sql insert exemplo
SQL
-1 vote348 views1 answer
Difference berween database and data base management system
SQL
0 vote284 views1 answer
Date diff sql
SQL