Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ** export excluding some tables

Re: ** export excluding some tables

From: rjamya <rjamya_at_gmail.com>
Date: Thu, 15 Jun 2006 12:49:00 -0400
Message-ID: <9177895d0606150949pcefc0cdyc87825251cb07614@mail.gmail.com>


yes

  1. by listing tables you want to export in parfile or
  2. (probably unupported) by hacking couple of views in catexp.sql and then re-reunning them on the system.

I wouldn't use option except on a trash/test system. Raj

On 6/15/06, A Joshi <ajoshi977_at_yahoo.com> wrote:
>
> Hi,
> I am trying to take an export of whole database but it fails due to
> some big tables with rollback segment eror Ora-1555. I know we can specify
> tables but is there a way to exclude certain tables. Thanks for your help.
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>

-- 
----------------------------------------------
Got RAC?

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 15 2006 - 11:49:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US