-
Hi,
I want to copy the tables of one user in the schema to another user in the same schema. How do i can achive this.
thanx in advance.
Oracle
-
It's impossible.
Owner(schema name) = user (username)!!!
-
Hi I didn't get u , what do u mean to say....
Oracle
-
Hi I didn't get u , what do u mean to say....
I too didn't get what do you mean by this..
I want to copy the tables of one user in the schema to another user in the same schema. How do i can achive this.
Sanjay
-
an user is a schema, a schema is an user so noone understand what do you mean by another user in same schema since there is only one user per schema
-
I have one database. In that db, there are two users. I want to copy one user table(or objects) to another user in the same database. this is what i meant.
Oracle
-
OK. Now its clear.
The easiest way is EXPORT/IMPORT
using FROMUSER TOUSER
Sanjay
-
if it´s one table then use create table as select
-
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
|