RE: Rename table problem

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Tue, 17 Feb 2004 22:49:08 -0500
Message-ID: <D91D9D5A73FC694BBC52F1EB26AD410FA2E4B8@MSGBOSCLD2WIN.DMN1.FMR.COM>

You could:
1) Alter session set current_schema = 'schema-name';

    rename old-table-name to new-table-name or
2) Alter table owner.old-table-name rename to new-table-name.  

Could be mistaken, try it.  

Waleed
-----Original Message-----
From: Viktor [mailto:stant_98_at_yahoo.com] Sent: Tue 2/17/2004 9:43 PM
To: oracle-l_at_freelists.org
Cc:
Subject: Rename table problem

Hello,   

Is it possible for one user to rename a table in another user's schema, Oracle 8.1.7?   

I kept getting
ORA-01765: specifying table's owner name is not allowed

Are there any workarounds?

Thanks

---

Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com <https://access0.fidelity.com/,DanaInfo=www.orafaq.com+>

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

-- 
Archives are at http://www.freelists.org/archives/oracle-l/
<https://access0.fidelity.com/archives/oracle-l/,DanaInfo=www.freelists.org+


>  

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
<https://access0.fidelity.com/help/fom-serve/cache/1.html,DanaInfo=www.freel
ists.org+>  
----------------------------------------------------------------- 



-- Binary/unsupported file stripped by Ecartis --
-- Type: application/ms-tnef


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Feb 17 2004 - 21:49:08 CST