Re: Export/Import with Physical Standby
- From: David Barbour <david.barbour1@xxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- Date: Thu, 1 Oct 2009 21:46:25 -0400
Lots of these:
You cannot move a table containing a LONG or LONG RAW column. (
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_3001.htm#i2085301
)
I could export only the tables with long/long raw, but the bulk of the data
is in tables with longs, so I don't gain that much in terms of
time/simplicity.
Idea ... Good. Application ... Bad
However, I just have a bothersome feeling I'm missing something with my
original approach.
On Thu, Oct 1, 2009 at 5:55 PM, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx>wrote:
> For more info:
>
>
>
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#sthref2297
>
>
>
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_3001.htm#i2085301
>
>
>
> Note that the ONLINE option is only for IOTs so DML will be blocked on
> regular tables, but I think you can still query from it during the move.
> Also, you’ll need to rebuild the indexes and gather stats afterwards. If
> you want to move it without interrupting DML, you can use online table
> redefinition:
>
>
>
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#i1006754
>
>
>
> Regards,
>
> Brandon
>
> nderstood as neither given nor endorsed by it.
>
> ------------------------------
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>
Other related posts:
