Re: Script to reverse-engineer tablespaces

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: 2006-01-04 00:52:42
Message-id: 01ff01c610c1$98251f20$c4bc21c8@porgand

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_at_concentric.net Cc: oracle-l_at_freelists.org Sent: Tuesday, January 03, 2006 3:24 PM Subject: Re: Script to reverse-engineer tablespaces

tried dbms_metadata?

On 1/3/06, Lou Avrami wrote:
Hi all,

I was looking for a script that would reverse-engineer both locally managed and \ dictionary managed tablespaces. Received on Wed Jan 04 2006 - 00:52:42 CST