The database is Oracle8.1.7. I used the syntax:
alter table foo drop column bar;
Why it gives run out of RBS error? Is alter table a
DDL? How does it use RBS?
TIA
Chris Harvest
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
Probably to undo the changes in system tables (extents, etc.)
-Original Message-
Sent: Monday, March 05, 2001 11:10 AM
To: Multiple recipients of list ORACLE-L
The database is Oracle8.1.7. I used the syntax:
alter table foo drop column bar;
Why it gives run out of RBS error? Is alter
Chris, be careful,
Truncate will kill all 9 million records - everything. Truncate acts
vertically. Drop column has very different effect :) Records a safe, but one
column is gone. It acts horizontally. Use set unused, if waste space is not
an issue.
Just my $0.02
Vadim Gorbounov
Oracle DBA
Ruth to drop a column, use truncate?
Joe
Ruth Gramolini wrote:
Use truncate instead of drop. Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Monday, March 05, 2001 11:10 AM
The database is Oracle8.1.7. I used the syntax:
alter