Re: ORA-01562 & ORA-01547 ERRORS
Date: 1996/07/10
Message-ID: <DuC6yM.1Mo_at_avenger.daytonoh.ncr.com>#1/1
>==========Mike Stenzler, 7/8/96==========
>
>new to oracle dba duties....
>
>while attempting a global delete of approx. 107,000 rows from a table
>I keep encountering the errors listed in the subject line.
>
>01562 hints that there may be a databse space problem
>01547 is not in my server error message reference!
>
>I was able to perform my delete by changing the where clause &
>deleteing smaller (much!) groups of rows at a time.
>
Sounds like you do not have a large enough rollback segment.
If you are deleting an entire table use the Truncate command. It flies!
>Any ideas? If you need more detailed info let me know.
>
>TIA - mike
>
>mstenzler_at_rxr.com
>rxrgroup_at_mail.idt.net
>
>
Rodney Patterson - NCR
"I didn't do it, nobody saw me, you can't prove it!" Bart Simpson
Received on Wed Jul 10 1996 - 00:00:00 CEST