What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-11-12 18:09:15
oracle alter tablespace add datafile autoextend max size
SELECT * FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'my_tbs' ORDER BY FILE_NAME; 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.... Add solution -
SQL 2021-10-04 17:21:04
oracle add datafile to tablespace
SELECT * FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'my_tbs' ORDER BY FILE_NAME; 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.... Add solution -
SQL 2021-10-03 09:50:03
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; ... Add solution -
SQL 2021-09-29 18:37:02
alter tablespace add datafile autoextend
SELECT * FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'my_tbs' ORDER BY FILE_NAME; 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.... Add solution