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.