|
-
Can you create a table with the same name in the same schema?
If you
create table origtable as (select * from origtable);
you get an ORA-955 error - name already used by an existing object
I'm assuming the original requirement was for the reorgainised table
to have the same name and be in the same schema.
Rgds
Moff.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|