To: Multiple recipients of list ORACLE-L
Cc:
Subject:RE: Delete vs. truncate to free up spaces.
In such a case what will happen to the transactions that hit the table
(since the triggers have been disabled)?
Regards
Naveen
-Original Message-
From: Bobak, Mark [mailto:[EMAIL
EE has enterprise on the CD, but it's an extra cost option. Make sure the license
fees have been paid first, otherwise it could be a messy thing to rip out. BTDT.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Monday, December 22, 2003 7:14 PM
To:
Title: Delete vs. truncate to free up spaces.
I am using delete command to delete million records in several tables to free up space in tablespace. I understand delete command does not release unused spaces as truncate command but I could not use truncate to delete ALL records in table as I
This is one of the cases where a partitioned table can be of great use. What version
of Oracle? Standard or Enterprise Edition?
With a partitioned table you can say
alter table ... drop partition ... ;
to easily get rid of a large chunk of data and release the space.
See
Oracle9i Database
you can also do the following:
1. create table as and copy just the records you want to keep.
2. Drop the old table
3. rename new table to old table
4. re-create the indexes. if there are alot, issue them as jobs and do it at
the same time.
- Original Message -
To: Multiple recipients
Nguyen, David M wrote:
I am using delete command to delete million records in several tables
to free up space in tablespace. I understand delete command does not
release unused spaces as truncate command but I could not use truncate
to delete ALL records in table as I need to keep one
... and if your table is not partitioned, consider using
'CREATE TABLE AS' with WHERE clause that eliminates the
rows you wish to delete, recreate indexes and constraints
on the new table, drop the old table, rename the new to
the old.
Keep in mind that stored procedures and triggers that
It's Oracle8i Enterprise Edition.
-Original Message-
Jacques Kilchoer
Sent: Monday, December 22, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L
This is one of the cases where a partitioned table can be of great use.
What version of Oracle? Standard or Enterprise Edition?
With a
And synonyms will have to be re-created. (drop and create).
Grants will have to be given. Jared Still [EMAIL PROTECTED] wrote:
... and if your table is not partitioned, consider using'CREATE TABLE AS' with WHERE clause that eliminates the rows you wish to delete, recreate indexes and
Then you should have the partitioning option. Partition your table if you can.
-Original Message-
Nguyen, David M
It's Oracle8i Enterprise Edition.
-Original Message-
Jacques Kilchoer
This is one of the cases where a partitioned table can be of
great use.
What
ORACLE-L
Cc:
Subject:RE: Delete vs. truncate to free up spaces.
And synonyms will have to be re-created. (drop and create).
Grants will have to be given.
Jared Still [EMAIL PROTECTED] wrote:
.. and if your table is not partitioned, consider using
'CREATE TABLE AS' with WHERE clause
: Mon 12/22/2003 6:59 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject: RE: Delete vs. truncate to free up spaces.
And synonyms will have to be re-created. (drop and create).
Grants will have to be given.
Jared Still [EMAIL PROTECTED] wrote:
.. and if your table
: RE: Delete vs. truncate to free up spaces.
Because there is a lot that could be overlooked, I prefer to do it
the other way around:
create table tmp_tbl nologging
as select * from big_table where (rows you want to keep);
truncate table big_table;
alter trigger trigger_name disable
13 matches
Mail list logo