oracle version: 10.2.0.4.0
SQL> alter table ai_xx rename to ai_xx_old;
alter table ai_xx rename to ai_xx_old
*
ERROR at line 1:
ORA-00942: table or view does not exist
The table is valid and exists
SQL> select 1 from schema.ai_xx where rownum < 2;
1
----------
1
These are the privileges the user executing this command has:
PRIVILEGE ADM
---------------------------------------- ---
ADMINISTER DATABASE TRIGGER NO
ALTER ANY CLUSTER NO
ALTER ANY DIMENSION NO
ALTER ANY INDEX NO
ALTER ANY INDEXTYPE NO
ALTER ANY LIBRARY NO
ALTER ANY OUTLINE NO
ALTER ANY PROCEDURE NO
ALTER ANY SEQUENCE NO
ALTER ANY SQL PROFILE NO
ALTER ANY TABLE YES
PRIVILEGE ADM
---------------------------------------- ---
ALTER ANY TRIGGER NO
ALTER ANY TYPE NO
ALTER SESSION NO
ALTER USER YES
ANALYZE ANY NO
COMMENT ANY TABLE NO
CREATE ANY CLUSTER NO
CREATE ANY CONTEXT NO
CREATE ANY DIMENSION NO
CREATE ANY DIRECTORY NO
CREATE ANY INDEX NO
PRIVILEGE ADM
---------------------------------------- ---
CREATE ANY INDEXTYPE NO
CREATE ANY JOB NO
CREATE ANY LIBRARY NO
CREATE ANY OUTLINE NO
CREATE ANY PROCEDURE NO
CREATE ANY SEQUENCE NO
CREATE ANY SYNONYM NO
CREATE ANY TABLE NO
CREATE ANY TRIGGER NO
CREATE ANY TYPE NO
CREATE ANY VIEW NO
PRIVILEGE ADM
---------------------------------------- ---
CREATE CLUSTER NO
CREATE DATABASE LINK NO
CREATE PROCEDURE NO
CREATE PUBLIC SYNONYM NO
CREATE SEQUENCE NO
CREATE SESSION NO
CREATE SYNONYM NO
CREATE TABLE NO
CREATE TRIGGER NO
CREATE USER NO
CREATE VIEW NO
PRIVILEGE ADM
---------------------------------------- ---
DEBUG ANY PROCEDURE NO
DEBUG CONNECT SESSION NO
DELETE ANY TABLE YES
DROP ANY CLUSTER NO
DROP ANY CONTEXT NO
DROP ANY DIMENSION NO
DROP ANY DIRECTORY NO
DROP ANY INDEX NO
DROP ANY INDEXTYPE NO
DROP ANY LIBRARY NO
DROP ANY OUTLINE NO
PRIVILEGE ADM
---------------------------------------- ---
DROP ANY PROCEDURE NO
DROP ANY SEQUENCE NO
DROP ANY SYNONYM NO
DROP ANY TABLE NO
DROP ANY TRIGGER NO
DROP ANY TYPE NO
DROP ANY VIEW NO
DROP PUBLIC SYNONYM NO
EXECUTE ANY CLASS NO
EXECUTE ANY INDEXTYPE NO
EXECUTE ANY LIBRARY NO
PRIVILEGE ADM
---------------------------------------- ---
EXECUTE ANY PROCEDURE NO
EXECUTE ANY PROGRAM NO
EXECUTE ANY TYPE NO
FLASHBACK ANY TABLE NO
FORCE TRANSACTION NO
GLOBAL QUERY REWRITE NO
GRANT ANY OBJECT PRIVILEGE YES
INSERT ANY TABLE YES
MANAGE FILE GROUP NO
MANAGE SCHEDULER NO
ON COMMIT REFRESH NO
PRIVILEGE ADM
---------------------------------------- ---
QUERY REWRITE NO
SELECT ANY DICTIONARY NO
SELECT ANY SEQUENCE NO
SELECT ANY TABLE YES
UNLIMITED TABLESPACE NO
UPDATE ANY TABLE YES
83 rows selected.
Is there a missing privilege to be added for rename to work?.
Thanks