Oracle-L: Truncate Table Problem.

From: mahendra <mahendra_at_INF.COM>
Date: Fri, 8 Mar 1996 09:45:01 EST
Message-Id: <9603080526.AA26525@alice.jcc.com>

Hi,

     We are using SQL loader for loading data into a table with 'replace'
     option. It gives following error.

     ORA-01562: failed to extend rollback segment (id = 2)
     ORA-01628: max # extents (10) reached for rollback segment R01

     But oracle utilities manual say that 'replace' option uses oracle
     'truncate table' command. Still we are getting this error.

     We tried to manually truncate the table before loading the data. The
     disadvantage of this method is only owner of the table can do this.

     In the oracle manual it is given that if a user has 'delete any table'
     system privilege then he can use 'truncate table' command. We logged
     in as owner of the table, and granted 'delete any table' to the user.
     Still we are unable to use 'truncate table' command. It gives the
     error insufficient privileges. Anyway 'delete any table' has the
     disadvantage that it allows to use truncate command on all tables
     under that user.

     We are stuck now. We are thinking of writing a Pro *C program which
     deletes the table 1000 rows at a time.

     Please tell me a efficient way of handling this situation.

     Thanks,
     Bopanna K K

Received on Fri Mar 08 1996 - 00:26:34 CST