Job Seekers   Employers

dbapool: Authors | Submissions | Contact Us

Forgot password? | Sign up

Home

Discussion Forum

Articles

Interview Questions

FAQs

Scripts

Rewards

Analyzer

White Papers

Blog

Certification

Downloads

Tools

Generating script for Tablespace from current database By: Azaz Husain Apr 26 2008 Generating script for Tablespace from current database. Script generated can be use to create tablespace in event of system failure or creating replica of the same database.   REM:***************************************** REM: Generating script for Tablespace from current database REM: Script generated can be use to create tablespace in event of system failure REM: Or creating replica of the same database REM: REM: Author: Azaz REM: Date Submitted: 26-April-2008 REM: REM: NOTE: PLEASE TEST THIS SCRIPT BEFORE USE. REM: Author will not be responsible for any damage that may be cause by this script. REM:***************************************** set trimspool on set pages 0 spool gentbsp.sql SELECT 'create tablespace' ||' '||tablespace_name ||' '||'logging' ||' '||'datafile' ||' '||file_name ||' '||'size'||' '||bytes ||' '||'EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO' FROM Dba_Data_Files spool off;

About Us

Advertise

Terms of Use

Privacy

Newsletters

Contact Us

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads

Our Premium Sponsor