Re: Exporting a Large Table

Hi,

If your on Unix, you could export to a compressed file:

mkfifo exportfile.dmp.pipe cat exportfile.dmp.pipe | \   compress > exportfile.dmp.Z &

exp ... file=exportfile.dmp.pipe ...

If your just going for a table rebuild, perhaps there is space within the database (temp space?) to copy the table to, and then back to the orginal space. Turn off logging and use parallel query to increase speed.

(syntax is not verified here)

create table temp_tablename nologging parallel(degree 4) tablespace temp pctfree 0 as select * from tablename;

drop table tablename;

create table tablename nologging parallel(degree 4) tablespace normal_tablespace as select * from tablename;

Keep in mind storage management caveats involved with parallel query and non-recoverability with turning off logging.

Alan.

In article <8p3lgm$c96$1_at_nnrp1.deja.com>, EnderW <ender29_at_my-deja.com> wrote:
> Hi,
> I am kind of into a problem. The client doesnot have space to export
> a large table. Well if they don't export it, they refuse to drop it. And
> they don't have the space to export it. What are my options ? Should I
> recommend them to use export with a sql statement ? if I remember
> correctly, you can put a condition in your export. That way, they can
> export and delete and export and then delete. Is there way to concat all
> these small files into one large export file ? Thanks in advn.
>
>
> --
> Ender Wiggin
>
>
> Sent via Deja.com http://www.deja.com/ Before you buy.
  Received on Wed Sep 06 2000 - 14:32:03 CDT