Skip to content

Instantly share code, notes, and snippets.

@gladiopeace

gladiopeace/tablespace.sql

Forked from phpfour/tablespace.sql
Created February 8, 2018 08:13
Show Gist options
  • Save gladiopeace/1f3aadbd065695b832abff82a654f7f3 to your computer and use it in GitHub Desktop.
Save gladiopeace/1f3aadbd065695b832abff82a654f7f3 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle
Raw
tablespace.sql
SELECT * FROM DBA_DATA_FILES;
ALTER TABLESPACE TBS_DB
ADD DATAFILE 'D:\APP\RBS\PRODUCT\11.2.0\DBHOME_1\DATABASE\TBS_DB5.DBF'
SIZE 10G
AUTOEXTEND ON;
ALTER DATABASE DATAFILE 'D:\APP\RBS\PRODUCT\11.2.0\DBHOME_1\DATABASE\TITAS_DB2.DBF' AUTOEXTEND ON;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment