Script to reverse-engineer tablespaces
- From: Lou Avrami <avramil@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 03 Jan 2006 16:21:16 -0500 (EST)
Hi all,
I was looking for a script that would reverse-engineer both locally managed and
dictionary managed tablespaces.
I have inherited some older databases that have a mix of both DMTs and LMTs
(don't ask why ;) and I would like to capture the tablespace definitions in a
file format. One of the things that I would also like to do over time is
migrate all of the DMTs to LMTs, so this script would be very helpful in
identifying the mixed databases and the tablespaces.
I found a couple of scripts that could handle both formats up on
http://www.dbasupport.com, but they both seem to not be working as posted.
There is a script there for LMTs that works. I also have some older scripts
that work well with DMTs. It's the databases with both types of tablespaces
that are troublesome.
If anyone has some links that they could send along, I'd appreciate it.
Thanks,
Lou Avrami
--
//www.freelists.org/webpage/oracle-l
Other related posts:
