In addition to the DBA_TABLESPACES view which is based on the TS$ table, the V$TABLESPACE view is based on the X$KCCTS fixed table. X$ tables are purely read-only from SQL or any other API into the RDBMS.
I believe that this view came into being relatively recently, in either the v8.0 or v8.1 timeframe, mainly to support RMAN functionality, I think, allowing RMAN access to information about tablespaces while the database is in MOUNT mode. So, updating the TS$ table would likely turn your database into scrap. Hope this helps! on 9/5/03 6:34 PM, Ryan at [EMAIL PROTECTED] wrote: > we publish from the same staging server daily to our master server. So we > update our staging server to change the name. Then do the export. We thought > about changing the export file, but its in binary and we couldnt make it > work. > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, September 05, 2003 9:24 PM > > >> ... A stupid solution might be to prefix the name of each tablespace >> with the name of the database it was created in ... you might have to >> play with users' quotas to allow them to create tables in the >> tablespaces you have plugged in but it is infinitely better than >> updating SYS tables ... I have done it in the past but always after a >> very very careful study of the situation and only because I really was >> cornered (and had a good backup). >> >> Jacques Kilchoer wrote: >>> >>> I think this would be the perfect time for you, as DBA, to explain to > the Powers That Be that updating SYS.TS$ is a BAD idea and that the > transportable tablespace plan has to change. You have damning evidence at > this point in time. You will be doing yourself and your successors a big > favour. >>> >>> -----Original Message----- >>> >>> not my call. i posted this on here before. was done that way before i > got here. Its part of the transportable tablespace plan since you cant have > multiple tablespaces with the same name in one instance. >>> >>> ... However, for the second time flushing the shared pool has not > worked. ... >>> -- >>> 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). >> >> -- >> Regards, >> >> Stephane Faroult >> Oriole Software >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.net >> -- >> Author: Stephane Faroult >> 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). >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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).
