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

Home -> Community -> Usenet -> c.d.o.server -> Re: Full db Export but exclude some tables

Re: Full db Export but exclude some tables

From: Jonathan Gauthier <jonathan.gauthier_at_cgi.ca>
Date: Wed, 12 Jan 2000 15:56:17 GMT
Message-ID: <Bu1f4.1021$yO2.747@198.235.216.4>


If you are on a unix platform you can pipe the output to a compress utility and that will allow you to go up to 2GB of compressed data. I'm able to do a full export of a 10GB database with this solution on solaris 2.6. There is also the possibility to split the export by tables but that could be a problem if a lot of tables are involved.

--
---
S. Han <shan168_at_yahoo.com> wrote in message news:85gonl$45t$1_at_nnrp1.deja.com...
> Hi,
>
> I need to export the full database. But the problem is it's too big (>
> 3GB). I have to break the export into some smaller ones. How am I able
> to export the full database by excluding some HUGE tables? 90% of tables
> in this db belong to one user. So there is no way I can use "user"
> export. Any help will be appreciated!
>
> Steph
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jan 12 2000 - 09:56:17 CST

Original text of this message

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