How does one rename a table

[shyamal]

The rename command:

rename table a to table b is incorrect if you are logged
on as the administrator. I want to rename a table in the schema.

That is:
SL.table1

sl is the schema name.

 

[Scunningham99]

You need to use create table as <table name> then do an insert in to new table from previous, as rename of table is not poss.

sy

 

[jee]

Well, it is possible to rename a table in Oracle 8i (not in earlier Oracle versions), but you can only do this to a table in the schema you are connected to. So in order to rename a table called:

SL.table1

You must login as user SL.

 

[JamesGordon]

Just be careful as any underlying indexes and constraints will still be the same name when you use &quot;rename table&quot;.