Re: Export/Import with Physical Standby

From: David Barbour <david.barbour1_at_gmail.com>
Date: Thu, 1 Oct 2009 21:46:25 -0400
Message-ID: <69eafc3f0910011846m2c565632v6a3391a2fe24214c_at_mail.gmail.com>

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_at_oneneck.com>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.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 01 2009 - 20:46:25 CDT