Hi,

How can I generate tablespace creation scripts provided I've admin
access to that DB.

Regards,
Anand

I assume quite many GUI DBA tools can generate DDL, for example
Enterprise manager (on java) surely can do that.
The other possibility is to use dbms_metadata

SQL> set long 10000
SQL> select dbms_metadata.get_ddl('TABLESPACE', 'USERS') from dual;

DBMS_METADATA.GET_DDL('TABLESPACE','USERS')
--------------------------------------------------------------------------------

CREATE TABLESPACE "USERS" DATAFILE
<skipped>

Gints Plivna
http://www.gplivna.eu

On Thu, 19 Apr 2007 00:22:11 -0700, anandmohans wrote:

> Hi,
>
> How can I generate tablespace creation scripts provided I've admin
> access to that DB.
>
By using SQL.

--
http://www.mladen-gogala.com

On Apr 19, 3:08 pm, Mladen Gogala <mgogala.SPAM-ME....@verizon.net>
wrote:
> On Thu, 19 Apr 2007 00:22:11 -0700, anandmohans wrote:
> > Hi,
>
> > How can I generate tablespace creation scripts provided I've admin
> > access to that DB.
>
> By using SQL.
>
> --http://www.mladen-gogala.com

They tried to make me go to rehab I said no no no