What happens to the data files if a tablespace is dropped?
- 1 Answers
- 1138 Views
- I also Faced
- E-Mail Answers
Answer / Syed Danish Mushtaq
When you drop a tablespace, all the associated datafiles are also deleted unless they are used by another tablespace. If there are no other dependent objects using the datafiles, they will be deleted as well. If the datafiles are needed for other tablespaces, they remain intact.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the different pseudo commands? Explain in general?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is the quickest way to fetch the data from a table?
What is an UTL_FILE.What are different procedures and functions associated with it?
How to assign a table row to a record variable?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Is oracle an operator?
what are the different types of cursors? explain?
How to list all tables in your schema?
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.
What are nested tables?
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
Oracle General 
