Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Transaction without any Rollback Segment
Good Morning,
Another possible method would be to use SQL*Loader. This might be a good option if you can't directly connect to the first database, but you can get the table info into a delimited text filed. SQL*Loader using the 'direct' and 'unrecoverable' options is very fast. On our system (Dec Alpha, NT, Oracle 8) it takes 17 seconds to load 54000 records. One caution, there are some issues related to indexes and constraints when doing a direct load. See 'Oracle 8 Utilities' in the online docs for details. Hope it helps.
Joe Long
"The only stupid question is the one not asked"
Connor McDonald wrote:
>
> Thomas Meiers wrote:
> >
> > Hallo!
> >
> > I have to do a quite big transaction in my database. I want to import
> > data from another database. Is there a way to write data in a table
> > directly whithout a rollback segment?
> >
> > Any help would be great!
> >
> > Tom
>
> Check out direct load insert (8.0 and above)
>
> There is a good section in "Server Concepts" but in essence
>
> alter table destination_table nologging;
>
> insert /*+ APPEND */
> into destination_table
> select * from source_table;
>
> HTH
> --
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com
>
> "Some days you're the pigeon, and some days you're the statue."
Received on Fri Feb 04 2000 - 08:50:41 CST