SQL Script Generate Create Tablespace Script

Updated: 24-Nov-2004
Version: 3.0

Description

This script generates a create tablespace script from an existing database. It is especially useful of you need a duplicate database on a different machine and have a large number of tablespaces. 

The database will then be ready for a full database import. This script now uses the new 9i DBMS_MEATDATA package

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

set long 50000
set pages 2000
set serveroutput on size 1000000

spool gents.lst

PROMPT 
PROMPT version 9 we can use DBMS_METADATA
PROMPT

select dbms_metadata.get_ddl('TABLESPACE', tablespace_name )
from dba_tablespaces
where tablespace_name != 'SYSTEM';

spool off

Related Links

Oracle 8i: (SQL Script) Generate Create Tablespace Script

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links