Rebuild with a storage clause.

-----Original Message-----
From: j f [mailto:[Email Address Removed] Thursday, August 29, 2002 12:44 PM
To: LazyDBA.com Discussion
Subject: rebuilding primary index


I want to rebuilt and move the primary key to another tablespace.

Do I need to delete and recreate it, or can I simply rebuilt it with a
storage clause?

Same thing for other indexes.

Thanks.

Jerry



_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page