|
Re: truncate / drop an on line table [message #169818 is a reply to message #169797] |
Fri, 28 April 2006 19:27 |
nmacdannald
Messages: 460 Registered: July 2005 Location: Stockton, California - US...
|
Senior Member |
|
|
Create index <table_name_NDX>
ON <table_name> (column1, column2, column3)
PCTFREE 10
INITRANS 14
MAXTRANS 99
TABLESPACE <Your_Index_tablespace>
STORAGE ( INITIAL 1M
NEXT 2M
MINEXTENTS 1
MAXEXTENTS 200
)
;
OR
Truncate table <table_name>;
OR
Drop table <table_name>;
you must have the correct priveliges.
[Updated on: Fri, 28 April 2006 19:28] Report message to a moderator
|
|
|