Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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;
Comment

PREVIOUS NEXT
Code Example
Sql :: Inser Dataframe into mysql 
Sql :: homebrew mysql service not starting 
Sql :: sql check constraint 
Sql :: update query in linked server 
Sql :: sql order by except one row 
Sql :: how to dump .csv file into mysql 
Sql :: .env pgsql 
Sql :: how to completely uninstall sql server 
Sql :: oracle logfile switch 
Sql :: concatenation in sql 
Sql :: how convert into in in sql query 
Sql :: window function sql 
Sql :: automate mysql cli query 
Sql :: mysql not 
Sql :: sql server epoch to datetime 
Sql :: creating a database sql 
Sql :: timestamp(0) postgresql 
Sql :: delete sql 
Sql :: show create table in postgresql 
Sql :: read sql file in python pandas 
Sql :: laravel subquery in from clause 
Sql :: oracle select 
Sql :: sql comment 
Sql :: aggregate functions 
Sql :: stored procedure 
Sql :: Why mysql is used? 
Sql :: SQL Delete and Truncate Rows 
Sql :: sql to linq converter 
Sql :: create-toys-table-with-toy_name-column 
Sql :: tipos da linguagem SQL 
ADD CONTENT
Topic
Content
Source link
Name
7+1 =