| Deleting record for using old Database [message #59490] |
Wed, 26 November 2003 08:45  |
Carlos Makaampoh
Messages: 2
Registered: November 2003
|
Junior Member |
|
|
|
I'm using Oracle 8.1.7 and Win 2K for the server, I wonder how to deleting old record so i still can use the database for new transactions. Plz help me, coz I'm realy a beginner in ORACLE... thx
|
|
|
|
|
|
| Re: Deleting record for using old Database [message #59500 is a reply to message #59490] |
Thu, 27 November 2003 02:53  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
I'm not sure I understand your request. One can have several sessions that simultaneously INSERT, UPDATE and DELETE rows into/from a table.
If you want to clear all rows from a table before inserting new data into it, execute the following DDL statement:
SQL> TRUNCATE TABLE tab1;
Best regards.
Frank
|
|
|
|
| Re: Deleting record for using old Database [message #59508 is a reply to message #59499] |
Thu, 27 November 2003 20:21 |
Carlos Makaampoh
Messages: 2
Registered: November 2003
|
Junior Member |
|
|
|
Sory if my question is'nt explained enough, what I mean is, what if I want to use the same Database, but I dont want to use the old data (which is inside the database)I want to use the same database, but with new data, ex: old record ends with 1024 records, I want to make it start from beginning ( zero record)..
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
