Or unless you have Oracle 10G. rgaffuri, are you still updating TS$, you rascal?
You could try the following:
set long 1000000
spool c:\temp\views.log
select
a.view_name, a.text
from
dba_views a
where
a.owner = 'SYS'
and a.view_name like 'DBA\_%' escape '\'
and exists (select * from dba_tab_columns b
where b.owner = a.owner
and b.table_name = a.view_name
and upper (b.column_name) like '%TABLESPACE%') ;
Then read the file, figure out which views are showing tablespace name and from which
SYS table the tablespace name comes from.
Or you could modify your code to be independent of tablespace name, which would be the
better solution.
-----Original Message-----
Sounds like you want to rename a tablespace.
Not recommended without approval from Oracle support.
<[EMAIL PROTECTED]>
Does oracle store the tablespace_name or any data about a tablespace anywhere else
accept TS$?
Im looking for base data dictionary tables. Not views. Are there any documents out
there about how oracle stores information in the data dictionary tables other than
what Steve Adams has in his book or on his website? Has anyone else published on this?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
