Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2005
    Location
    Kuala Lumpur, MY
    Posts
    108

    Unanswered: change table owner

    anyone can tell me how to change a the tables which are currently mine to another person within the same database ?
    thanks

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Perhaps using export-import?

  3. #3
    Join Date
    Aug 2005
    Location
    Kuala Lumpur, MY
    Posts
    108
    Littlefoot,
    Is that the only way or there is other ways such as a pl/sql statement wich can do the work.

    Thanks

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I guess there are other ways to do it, but performing export and import is maybe the easiest - you'd do all the job using two simple commands (assuming that both users are already created).

    You might first create tables in another user, grant INSERT on all tables to first user and - connected as first user - insert data from first user tables to second user tables. You'd do that using pure SQL, PL/SQL would not be needed. But, from my point of view, that would be time consuming and unnecessary painful procedure.

  5. #5
    Join Date
    Aug 2005
    Location
    Kuala Lumpur, MY
    Posts
    108
    true true,
    a very good explanation which striked me on "time consuming" as well

    Thanks Littlefoot

Posting Permissions

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