Кроик СемёнЧто бы еще попробовать?
alter table rename.
На 9.2.0.8 не воспроизвел.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
SQL*Plus: Release 9.2.0.8.0 - Production on Tue Jan 31 07:39:17 2017
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
SQL> CREATE TABLE "_TO_DROP1"(ID NUMBER);
Table created.
SQL> rename "_TO_DROP1" to "_TO_DROP2";
Table renamed.
SQL> alter table "_TO_DROP2" rename to "_TO_DROP1";
Table altered.
SQL> drop table "_TO_DROP1";
Table dropped.
SQL> select banner from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for Solaris: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production
