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: Multip
2003 1:00 AM
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
ist ORACLE-L
> Subject: 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
;
> -Mark
>
>
> -Original Message-
> From: anu [mailto:[EMAIL PROTECTED]
> Sent: 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-crea
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 is not partitioned, consider using
'CREATE TABL
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
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 constraint
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 p
... 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
refere
> "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 o
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 o
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 Concept
12 matches
Mail list logo