Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

mNem
Answer

did you try right-click on the project name from Projects panel and Copy ... option?

Marked as Answer by OTG-467455 · Sep 27 2020
1 person found this helpful
mNem

If I were you, for "exploring different scenarios", I would just stick with creating a new class (copy the existing one if you like) and make modifications all in the same project (instead of cloning the entire project).

HTH.

1 person found this helpful
OTG-467455

Hi mNem,  Both of your suggestions are good.  I just wanted to create a replica, mess around and then drop it.  So the clone works just right for me.  Thanks for your quick thinking.

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

Post Details

Locked on May 6 2010
Added on Apr 8 2010
#general-database-discussions, #index, #oracle
9 comments
4,415 views