Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calculate disk space needed for INDEX

guruparanApr 8 2010 — edited Apr 8 2010
Hi,

How to calculate disk space needed for creating an INDEX? Please point me to resources where I can get detail.

For Example:
I need to create an non UNIQUE INDEX on the following columns, a rough size would do.

<PRE>
EVENT_DATE NOT NULL DATE
APPT_DATE_SLOT VARCHAR2(15)
EVENT_STATUS VARCHAR2(4)
</PRE>

The table has some 7,300,000 rows. Let me know how to calculate too.

All helps are greatly appreciated.
This post has been answered by Mark D Powell on Apr 8 2010
Jump to Answer

Comments

SH_INT
Answer

If it is a question of just assigning HSP_NOLINK to an Account just use the Account as the Source and map the UDA based on that value

Marked as Answer by 3047423 · Sep 27 2020
3047423

thanks for your reply.

i have added UDA extract column in target application and mapping for it in data loading mapping.

Thanks

Venkataraju saripella

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 6 2010
Added on Apr 8 2010
9 comments
4,543 views