Home » SQL & PL/SQL » SQL & PL/SQL » drop bitmap indexes (10g)
drop bitmap indexes [message #393189] Fri, 20 March 2009 12:13 Go to next message
Messages: 8
Registered: February 2009
Location: New Jersey
Junior Member
I have a fact table with 12 bitmap indexes.
I want to drop bitmap indexes before load and recreate after the load is compelte
table name is "schema.xxx"

I used
drop bitmap index indexname on schema.xxx
above command to drop single bitmap index.
But the response says "invalid option"
Can you please give me the appropriate code to
drop the index
recreate the index
analyze the index
The table has around 8 million records for each month and it keeps growing

Thanks in Advance
Re: drop bitmap indexes [message #393190 is a reply to message #393189] Fri, 20 March 2009 12:17 Go to previous messageGo to next message
Messages: 25475
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.

When all else fail, Read The Fine Manual!

http://tahiti.oracle.com contains the whole Oracle Doc. set!

I suggest you obtain the SQL to build the index before you drop it.

[Updated on: Fri, 20 March 2009 12:22]

Report message to a moderator

Re: drop bitmap indexes [message #393263 is a reply to message #393190] Fri, 20 March 2009 23:35 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
keep trying, you'll get it.

I suggest DROP INDEX ... rather than DROP BITMAP INDEX ...

BITMAP is a valid option for the CREATE INDEX command, but BITMAP is an invalid option for the DROP INDEX command. Hence the error "INVALID OPTION".

Re: drop bitmap indexes [message #393290 is a reply to message #393189] Sat, 21 March 2009 01:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64953
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
[Messsage removed: was an answer to another topic]

Re: drop bitmap indexes [message #393572 is a reply to message #393263] Mon, 23 March 2009 07:30 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you don't have the SQL to create the indexes, you can use DBMS_METADATA.GET_DDL to generate the SQL from the indexes before you drop them.
Previous Topic: dbms_job.submit is not taking variable in INTERVAL column
Next Topic: show row level records in single column in hirarchy
Goto Forum:

Current Time: Sun Jun 25 19:26:25 CDT 2017

Total time taken to generate the page: 0.10866 seconds