Re: ORA-1650 error

From: srivenu <srivenu_at_hotmail.com>
Date: 8 Aug 2002 21:07:49 -0700
Message-ID: <1a68177.0208082007.7a6a3add@posting.google.com>

If you have sufficient space in the file system, Set the AUTO EXTEND property
of the datafile's in the tablespace's to ON. ex- ALTER TABLESPACE DATAFILE 'xxxxxx' AUTOEXTEND ON MAXSIZE xxxx; Hope your rollback segments are all in the same tablespace;

I would prefer to set a specific ROLLBACK SEGMENT for the big transaction and set only that tablespaces datafiles to AUTOEXTEND.

By the way are all the ROLLBACK tablespaces spread across different disks or are they on one single disk ?
If you have all of them on one disk, i would prefer to have a single ROLLBACK tablespace instead of 4. Received on Thu Aug 08 2002 - 23:07:49 CDT