Re: import
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: "Zelli, Brian" <Brian.Zelli@xxxxxxxxxxxxxxx>
- Date: Mon, 16 May 2011 16:05:32 -0300
As usual, Ask Tom:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:869096700346654484
"probably the easiest, safest way will be to use dbms_redefinition - it'll
copy over the grants, indexes, constraints, everything. ..."
Alan.-
On Mon, May 16, 2011 at 3:44 PM, Zelli, Brian
<Brian.Zelli@xxxxxxxxxxxxxxx>wrote:
> I created the same table using a different name so I can partition it. I
> can't seem to load the data into the newer partitioned one. I've tried
> sqlldr, imp and select into.....
>
>
>
>
> ciao,
>
> Brian
>
>
>
> *Brian J. Zelli*
>
> title => Senior Database Administrator
>
> dept => Enterprise Applications/Systems Integration
>
> org => Roswell Park Cancer Institute
>
> phone => (716) 845-4460
>
> email => brian.zelli@xxxxxxxxxxxxxxx
>
>
> ------------------------------
> *From:* alanbort@xxxxxxxxx [mailto:alanbort@xxxxxxxxx] *On Behalf Of
> *Guillermo
> Alan Bort
> *Sent:* Monday, May 16, 2011 2:33 PM
> *To:* Zelli, Brian
> *Cc:* Oracle I List
> *Subject:* Re: import
>
> You can create the table as select if your objective is to simply populate
> the table. Or you can insert select. Anyway, are you using traditional
> import/export or datapump? in Data pump you have the REMAP_TABLE clause
> which will allow you to change the table name... with traditional
> import/export I'm not sure you can do what you want... you can use the
> fromuser touser clause but I think the table names remain the same.
>
> Again, if your problem is that you need to get all the data from one table
> to another in the same database, there are easier ways (even datapump can
> help you there).
>
> Cheers.
> Alan.-
>
>
> On Mon, May 16, 2011 at 3:01 PM, Zelli, Brian <Brian.Zelli@xxxxxxxxxxxxxxx
> > wrote:
>
>> Ok, it has been awhile and I completely have gone brain-dead on this. I
>> want to import one table to another. I looked up my import options and
>> can't seem to locate how to go about this.
>>
>> I have a table that I exported called requestitem. I created a new
>> partitioned table called requestitem2.
>> How do I import requestitem into requestitem2? I can't seem to
>> remember.....
>>
>>
>>
>> ciao,
>>
>> Brian
>>
>> This email message may contain legally privileged and/or confidential
>> information. If you are not the intended recipient(s), or the employee or
>> agent responsible for the delivery of this message to the intended
>> recipient(s), you are hereby notified that any disclosure, copying,
>> distribution, or use of this email message is prohibited. If you have
>> received this message in error, please notify the sender immediately by
>> e-mail and delete this email message from your computer. Thank you.
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
>
Other related posts:
