DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: How to copy the tables of one user to another in the same schema

  1. #1
    Join Date
    Jul 2002
    Posts
    42
    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

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    It's impossible.

    Owner(schema name) = user (username)!!!

  3. #3
    Join Date
    Jul 2002
    Posts
    42
    Hi I didn't get u , what do u mean to say....
    Oracle

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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


  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  6. #6
    Join Date
    Jul 2002
    Posts
    42
    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

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    OK. Now its clear.
    The easiest way is EXPORT/IMPORT
    using FROMUSER TOUSER

    Sanjay

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if it´s one table then use create table as select

  9. #9
    Join Date
    Jul 2002
    Posts
    42
    Thanks lot
    Oracle

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width