Exporting tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Exporting tables

  1. #1
    Join Date
    Feb 2001
    Posts
    27
    Does anyone know how - if possible- to export tables from one user but have the export file think the tables are from another user?

    Example:

    I need to export tables from user "A". This export file will then be imported into another database but under user "B". The issue is this will be done programmatically. Since the import process will be "activated" through a program, it has been hard coded to look at the export file and assume the tables were from user "B". But, the export file was created from under "A".

    I can jump through some hoops (and script files) and accomplish this by 1) export file under user "A". 2) import the file using option touser="B" and 3) then re-export the same tables from user "B". The program will then work properly since the export file is "owned" by user "B".

    I was just hoping there is an easier way than what I described.

    I hope I explained this clearly enough.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Your script file would only be the way to go... Oracle is so intelligent to fake user_names

    If both the users are on the same instance, then you can grant selet to user B from user A on table xyz. Then do a

    drop table xyz;
    create table xyz as select * from A.xyz;

    Voila, you have the tables created without a necessity to export or import.

    Sam

    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jul 2000
    Posts
    521
    but why cann't you change the hardcoded stuff ?

    And if you go your way, after you do an import with touser=B as mentioned in step "2)", your job is done. Why do you need to carry out step "3)" and that un-mentioned "4)" ?
    svk

  4. #4
    Join Date
    Jul 2000
    Posts
    521
    And as Sam has suggested, you can grant SELECTs on A's tables to B.

    If A and B are on same db its simple.
    If they are not, explore use of SQL's COPY command or database link.
    svk

  5. #5
    Join Date
    Feb 2001
    Posts
    27
    Thanks for your suggestions. Unfortunately, there are a lot of other issues involved that prevent the code from being changed. But I do thank you all for your suggestions and comments.

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