|
|
| 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
