I am new to the Administration part of the Oracle server,Just want to know will deleting a user means data related to that user will also get deleted? Thanks you.
views:
61answers:
2
A:
Depends upon what you mean by "related". Every user in the database has a corresponding schema, with tables, indexes and so on. If you drop a user, their schema and all the data in it goes too. If the user has put data into other tables, that data does not go anywhere.
Thomas Jones-Low
2009-10-28 15:31:19
+1
A:
Review cascade option for drop user command http://download.oracle.com/docs/cd/B19306%5F01/server.102/b14200/statements%5F9008.htm#SQLRF01811
ZaiS
2009-10-28 17:31:05