Re: Script to reverse-engineer tablespaces
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 3 Jan 2006 17:52:42 -0600
Hi,
DBMS_METADATA.GET_DDL would be the way I'd go as well
Note that GET_DDL has a bug (fixed in 9.2.0.6 I think) which reports the
original datafile sizes as they were set during their creation, not the sizes
they might have extended to. GET_DDL just queried wrong column of v$datafile
view...
Tanel.
----- Original Message -----
From: David Sharples
To: avramil@xxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Tuesday, January 03, 2006 3:24 PM
Subject: Re: Script to reverse-engineer tablespaces
tried dbms_metadata?
On 1/3/06, Lou Avrami <avramil@xxxxxxxxxxxxxx> wrote:
Hi all,
I was looking for a script that would reverse-engineer both locally managed
and dictionary managed tablespaces.
Other related posts:
