import a table's data within same schema to different table

Hi

How can i import a table from an export file with different name within same schema.
e.g i have a table a1 in user1 schema and have exported this table only.
now i want to import this table as a2 with same schema user1

Code:

---

create table a2 as select * from a1;

---

Is it what you want?

Quote:

---

Originally Posted by SANJAY_G

Code:

---

create table a2 as select * from a1;

---

Is it what you want?

---

I know this. but can i do same from imp utility.

no, you cant rename tables

export your table first, rename table to table_old, import table back, rename imported table to table_new, rename table_old to table.

Quote:

---

Originally Posted by BV1963

export your table first, rename table to table_old, import table back, rename imported table to table_new, rename table_old to table.

---

Wondering why someone would want to do this. :confused:
and not 'create table as select'.