RE: Differences between Table Move and table Export
- From: maheswara.rao@xxxxxxx
- To: <Mark.Bobak@xxxxxxxxxxxx>, <jeremiah@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 23 Sep 2008 12:18:37 -0400
My apologies for not completely answering the queries raised by
Jeremiah.
Our Database version: 9i
The problem we are trying to solve:
The tables we are planning to do reorg have lot inserts and deletes in a
day. On an average, around 250,000 to 300,000 records are inserted into
the table in a day. The average record length is 693 for one of our big
table. Around 150,000 records are deleted in a day. Updates are done
to these tables but I do not have the update stats. Indexes are defined
on these tables.
Due to the above heave I/O activity, lot of disk space is wasted and we
want to reclaim the disk space by doing reorg on the tables.
Fragmentation: Lot of unused space in the segment below HWM.
The biggest table size is 125 GB.
We want to move this table into ASSM type tablespace.
Is Alter table move is better or export and import is better?
Regards,
Rao
-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxx]
Sent: Tuesday, September 23, 2008 11:43 AM
To: Rao, Maheswara; jeremiah@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Differences between Table Move and table Export
Hmm...I think you missed the part where Jeremiah asked you what problem
you were trying to solve and what you meant by "fragmentation"....
--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxx
www.proquest.com
www.csa.com
ProQuest...Start here.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
maheswara.rao@xxxxxxx
Sent: Tuesday, September 23, 2008 11:21 AM
To: jeremiah@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Differences between Table Move and table Export
Thanks Jeremiah.
Oracle version: 9i
Regards,
Rao
-----Original Message-----
From: Jeremiah Wilton [mailto:jeremiah@xxxxxxxxxxx]
Sent: Tuesday, September 23, 2008 11:11 AM
To: Rao, Maheswara; oracle-l@xxxxxxxxxxxxx
Subject: RE: Differences between Table Move and table Export
maheswara.rao@xxxxxxx wrote:
> We have tables that are highly fragmented. We are planning to reorg
these
tables...
> Our aim is to reclaim the disk space and reset HWM.
>
> If we use Alter table move, does the HWM get reset
Yes, alter table move resets the HWM. Between exp/imp and alter table
move,
the latter seems far simpler. However, it would be helpful if you could
state more clearly what the problem is that you are trying to solve,
what
you mean by 'fragmentation,' and your version of Oracle. Depending on
the
version, there may be other options available to you that can minimize
disruption. Please see:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/schema.ht
m#AD
MIN10161
http://tinyurl.com/4a8emf
Regards,
Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net
Please do not transmit orders or instructions regarding a UBS account by
e-mail. The information provided in this e-mail or any attachments is
not an official transaction confirmation or account statement. For your
protection, do not include account numbers, Social Security numbers,
credit card numbers, passwords or other non-public information in your
e-mail. Because the information contained in this message may be
privileged, confidential, proprietary or otherwise protected from
disclosure, please notify us immediately by replying to this message and
deleting it from your computer if you have received this communication
in error. Thank you.
UBS Financial Services Inc.
UBS International Inc.
UBS Financial Services Incorporated of Puerto Rico
--
//www.freelists.org/webpage/oracle-l
Please do not transmit orders or instructions regarding a UBS account by
e-mail. The information provided in this e-mail or any attachments is not an
official transaction confirmation or account statement. For your protection, do
not include account numbers, Social Security numbers, credit card numbers,
passwords or other non-public information in your e-mail. Because the
information contained in this message may be privileged, confidential,
proprietary or otherwise protected from disclosure, please notify us
immediately by replying to this message and deleting it from your computer if
you have received this communication in error. Thank you.
UBS Financial Services Inc.
UBS International Inc.
UBS Financial Services Incorporated of Puerto Rico
--
//www.freelists.org/webpage/oracle-l
Other related posts:
