Re: tablespaces ddl extract script

From: David Sharples <davidsharples_at_gmail.com>
Date: Wed, 12 Oct 2005 11:51:37 +0100
Message-ID: <be592d550510120351o45718fc2nec15503f66bc1193@mail.gmail.com>

set long 4000

On 10/12/05, Norman Dunbar <norman.dunbar_at_environment-agency.gov.uk> wrote:
>
>
> Unfortunately, on my 9.2.0.4 <http://9.2.0.4> system, it is incomplete :
>
> SQL>select dbms_metadata.get_ddl('TABLESPACE','NORMAN') as fred from
> dual;
>
> FRED
> ----------------------------------------------------------
>
> CREATE TABLESPACE "NORMAN" DATAFILE
> '/u00/oracle/oradata/lccsdev/norman_01
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 12 2005 - 05:53:49 CDT