Re: How best to recreate a table

Two approaches come to mind.

First, download an "unloader" script such as the ones on either Jared Still or Thomas Kyte's web sites. Running the script will dump the table to a flat file and create the SQL*Loader control file needed to reload the table.

Second, copy the table and when necessary copy it back.

hth

Kevin O'Gorman wrote:

> I have a large table (about a gigabyte) that I created unrecoverable.
> I could do it again, but it takes a long time to create, and I need
> to do this over and over (this is a research project, not normal data).
>
> I thought I might do this with backup and recovery, but I'm completely
> new to this (I have no backups at all: just raw data, because I could
> rebuild from raw data in under a day). However, rebuilding this pesky
> table takes enough time that it's slowing me down.
>
> What's the best (i.e. fastest) way to restore a table or tablespace to
> a known point in time without fooling with or altering the other tables
> or indexes in the database? Right now, I'm thinking of SQL*Loader,
> because it's pretty fast. But I was hoping for an OS solution because
> I can restore from a compressed backup in that case.
>
> I'm having a lot of trouble reading through all the considerations and
> options in the Backup and Recovery manual, so go easy on me please.
>
> -- kevin
>
> --
> Kevin O'Gorman (805) 650-6274 kogorman_at_pacbell.net
> At school: kogorman_at_cs.ucsb.edu
> Permanent e-mail forwarder: Kevin.O'Gorman.64_at_Alum.Dartmouth.org

--
Once I figured out how to spell DBA I became one -- Jerry Gitomer Received on Tue Dec 21 1999 - 23:04:13 CST