Database Administration (MOSC)

MOSC Banner

dropping and recreating index and tables

edited Apr 18, 2016 10:39AM in Database Administration (MOSC) 7 commentsAnswered

I have error ORA-00600 involving indexes and tables.

As for the index, the general consensus is to drop and recreate it.

First, I was able to connect to the db using SQL Developer. And I was able to navigate to the related index and click on SQL. That is the SQL needed to re-create the index, am I right?

How do I get the same SQL command from via SQLPlus?

Should I need to backup the index before dropping it, the Export function exactly do that, right?

Is there also ways to do the same via SQLPlus?

Table.

I know tables contain data.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center