Home » SQL & PL/SQL » SQL & PL/SQL » Effects of dropping a table
Effects of dropping a table [message #185478] Tue, 01 August 2006 23:41 Go to next message
Matthew Waugh
Messages: 71
Registered: October 2004

Table B is created.
Table A is dropped.
Table B is renamed as Table A.

Do users lose their access to Table A when it is dropped? Do the table grants need to be re-issued?

Does the index need to be rebuilt?

Re: Effects of dropping a table [message #185498 is a reply to message #185478] Wed, 02 August 2006 01:07 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
If you drop a table, all its associated grants and indexes will also dropped. So, you need to recreate the indexes and re-grant access.
Previous Topic: Conversion into CSV file while keeping the comma
Next Topic: How to call a procedure which will return a refcursor from another procedure?
Goto Forum:

Current Time: Thu Oct 27 02:37:19 CDT 2016

Total time taken to generate the page: 0.13875 seconds