Can I create a tablespace synonym?
February 2nd, 2006 By bhales
I was wondering if it was possible to create a tablespace synonym. I have seen many _poorly_ written applications that do not allow the DBA (without a recursive search & replace) to specify a tablespace. It would be great if a tablespace synonym could be created so the DBA could use their standard naming convention and point objects to that location rather than changing scripts or submitting to the vendor.
February 2nd, 2006 at 1:26 pm
I do not believe you can. Assuming that all synonyms are created by the CREATE SYNONYM command, the documentation says:
Use the CREATE SYNONYM statement to create a synonym, which is an alternative name for a table, view, sequence, procedure, stored function, package, materialized view, Java class schema object, user-defined object type, or another synonym.
I do not see a tablespace there.
February 2nd, 2006 at 1:51 pm
Hi,
No synonyms as mentioned are allowed on tablespaces; But in Orcacle 10G you can RENAME Tablespaces – and that is a revolution either :
ALTER TABLESPACE :oldname: RENAME TO :newname:;
http://www.oracle.com/technology/pub/articles/10gdba/week3_10gdba.html
Karl