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

Thread: Can I import into a table with a diiferent name than what is on the export?

  1. #1
    Join Date
    Feb 2001
    Posts
    34

    Exclamation

    Folks!

    I have a full database export with a table called Table1 on it. I want to import the data in Table1 on the export into a table called CopyOfTable1 on the same SID. Is that possible with import? I'm searching the docs, but coming up empty so far.

    Thanks in advance!

    Joe B.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    not possible as I know, if they are local it would be faster using db links

  3. #3
    Join Date
    Feb 2001
    Posts
    34

    Smile Thanks Pando.

    pando. Thanks for your quick reply. That's not the answer I was hoping to hear, but at least I know to stop looking and fall back to Plan B.

    Joe B.

  4. #4
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688

    Re: Thanks Pando.

    It is possible, you have to edite dmp file and change table name, but be carefully, old name and new name must take the same space in dmp file, if new one is shotter add spaces.

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well if you wanna do that just import and do alter table rename no?

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by pando
    well if you wanna do that just import and do alter table rename no?
    That's what I would do. If you have to, you can import to another user, rename the table, export, and then re-import.
    Jeff Hunter

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if we import to another user we dont even need to export again, we can just grant select priv to the user and do insert into xxx select * from new_table

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