Skip to content

Instantly share code, notes, and snippets.

@phpfour

phpfour/tablespace.sql

Last active February 8, 2018 08:13
Show Gist options
  • Save phpfour/43f6d5154277fa7a7cd3 to your computer and use it in GitHub Desktop.
Save phpfour/43f6d5154277fa7a7cd3 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