Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> create index then dropped it how to recover it
reem
post Sep 11 2017, 07:58 AM
Post #1


Newbie
*

Group: Members
Posts: 6
Joined: 7-May 16
Member No.: 51,315



please I am learning oracle and i need help from this pretty site , i create table then create to it index then i drop this index
my question how to restore it to my table from recycle bin
Go to the top of the page
 
+Quote Post
boobal_ganesan
post Sep 11 2017, 08:19 AM
Post #2


Advanced Member
***

Group: Members
Posts: 77
Joined: 6-June 16
From: India
Member No.: 51,370



Hello Reem,

Welcome to the forum!!

You can only retrieve the dropped index if you have dropped the table along with the index. Now, as you have just dropped the index it is irrecoverable.

Logically, you dont lose anything by dropping an index. You can easily recreate the index and it will work like a charm as there will be no difference between the old (dropped index) and the new (newly created index) one.

Index in Oracle is just like any book's index page. It has a shortest path to reach a value in a table, which will fasten up your data search.

Happy learning!


Regards,
Boobal Ganesan


--------------------
Check out my new Advanced PL/SQL book here - http://www.rampant-books.com/book_1701_pls...initive_ref.htm
Go to the top of the page
 
+Quote Post
reem
post Sep 11 2017, 09:20 AM
Post #3


Newbie
*

Group: Members
Posts: 6
Joined: 7-May 16
Member No.: 51,315



QUOTE (boobal_ganesan @ Sep 11 2017, 09:19 AM) *
Hello Reem,

Welcome to the forum!!

You can only retrieve the dropped index if you have dropped the table along with the index. Now, as you have just dropped the index it is irrecoverable.

Logically, you dont lose anything by dropping an index. You can easily recreate the index and it will work like a charm as there will be no difference between the old (dropped index) and the new (newly created index) one.

Index in Oracle is just like any book's index page. It has a shortest path to reach a value in a table, which will fasten up your data search.

Happy learning!


Regards,
Boobal Ganesan




HELLO SIR :
thanks for you very much ,you are very nice for rapidly discuss me ,your answer is right and i am very pleased depend you in my problems
thanks for god and thanks for you and i hope for you more success
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd September 2017 - 10:12 PM