Re: oracle datafile over 2GB - how to get data out?

Hopefully you have been running in archive log mode.Hopefully you have a backup.
If so you could.

1. restore the last known good backup.
2. recover until just before the file extended itself.
3. export the data.(in case you want to rebuild)
4. Turn off autoextend on all files.(or set the max to just under 2 gigs)
5. Add another datafile to the tablespace.

Jim

"Jessica Sharp" <jessicasharpAT_at_yahooDOT.coDOT.uk> wrote in message news:dLnn7.13402$uM2.762080_at_monolith.news.easynet.net...
> Hi everyone,
>
> I wonder if you can help me. There's a couple of us here running an
Oracle
> 8i database on Solaris 2.x, that was developed by an external company, and
> we're kind of picking it up bit by bit. Unfortunately, we've only just
> found out (a little too late!) that our system only supports file sizes of
> us to 2GB. The primary datafile in one of our tablespaces has just gone
> over that size (it's 2052.72MB) and I now can't run any SQL commands on
the
> table without getting errors. Now, I'd be quite happy to just archive the
> oldest data out of the main table in the tablespace onto a CD, but I can't
> do this without running SQL commands on the table!
>
> The weird thing is, when using TOAD as an interface, I can look at the
rows
> in the table up to a certain point before I start getting the same error
> (presumably before the size limit). Does anybody know whether I'm likely
to
> be able to remove either the old data (and hopefully back it up) or remove
> the last four days of data (which is how long ago it went over the 2GB
> limit, and is data I can cope with losing)?
>
> Many thanks in advance for your help! I'd very much appreciate it.
>
> Jessica
>
>
>
>
>
Received on Tue Sep 11 2001 - 08:46:36 CDT