-
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.
-
not possible as I know, if they are local it would be faster using db links
-
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.
-
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.
-
well if you wanna do that just import and do alter table rename no?
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|