coolcommands.com - the search engine for unix sysadmins :: unix commands and scripts
Sunday May 27, 2012


 Home
 Search
 Advanced Search
 Category Search
 Affiliates
 Acknowledgements
 Cool Links

Username

Password

Remember me
Forgot your password?
Create an account

Who's Online
We have 23 guests online

Newest Member

beyondimagem

Hit Counter
9133552 Visitors

cool Statistics
coolcommands:1330
Categories:83
Total queries:595500
Members:16437





Category Search coolcommands.com
Select Category:


coolcommand

how to delete all the data in an Oracle table while keeping the structure
Description

To delete all the data in an Oracle database table but maintain the table definition and structure:

Log into Oracle and then run the truncate command on the table name:

# sqlpus user/passwd@instance

> truncate table TABLE_NAME
Example

truncate table TABLE_NAME

Return to search results

Random coolcommands

coolcommand: how to verify the bootlist in IBM Virtual I/O Server
Example: bootlist -mode normal -ls
[show me the details]
coolcommand: wait.pl - script to open xterm on remote hosts using ssh
Example: wait.pl remote_host
[show me the details]
coolcommand: showrev - how to show machine, software revision, and patch revision information in Sun Solaris
Example: showrev -p
[show me the details]
coolcommand: procstack - how to display hex addresses and symbolic names of a process in AIX 5L
Example: procstack 233628
[show me the details]

coolcommands.com - the search engine for UNIX sysadmins :: unix commands and scripts



FREE
myPMS

Password
Management
System
by

LVOware.com




Top 5 Submitters

lvo1152
audet37
kah00na32
Mariom24
lebjf00014

Top 5 Searches

Category Solaris49379
Category AIX46267
Category General UNIX43933
solaris22927
aix22116

Terms of Use
Privacy
Contact


 
coolcommands.com © 2012. All Right Reserved.
Programming by PRATTICO Consulting . Hosting by Apricusum