Home » SQL & PL/SQL » SQL & PL/SQL » truncate
truncate [message #216969] Wed, 31 January 2007 01:48 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
hello everyone

sir i want to kn that while using delete keyword rows r deleted from table. but when use truncate, got error
sql>truncate subject;
    truncate ramu
              *
    error at line 1:
ORA:-03290:Invalid truncate command-missing cluster or table keyword

sql>truncate from subject;

same error getting .can any one please tell me how will i make it in use.

thanxx

regards

[Updated on: Wed, 31 January 2007 01:49]

Report message to a moderator

Re: truncate [message #216970 is a reply to message #216969] Wed, 31 January 2007 01:57 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
TRUNCATE TABLE ramu;
Re: truncate [message #216972 is a reply to message #216970] Wed, 31 January 2007 02:16 Go to previous message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
thanx
thanxx for ur quick response

regards
Previous Topic: utl_file write error
Next Topic: Temporary Table - Insertion dynamically
Goto Forum:
  


Current Time: Fri Dec 09 17:14:54 CST 2016

Total time taken to generate the page: 0.24691 seconds