Interested to Buy Any Domain ? << Click Here >> for more details...
What is SYSTEM tablespace and When is it Created?
- 2 Answers
- 7676 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chaudhry
Every ORACLE database contains a tablespace named SYSTEM, which
is automatically created when the database is created. The
SYSTEM tablespace always contains the data dictionary tables
for the entire database.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / nishi
Every Oracle database contains a tablespace named SYSTEM, which Oracle creates automatically when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain a segment?
How can I combine multiple rows into a comma-delimited list in oracle?
how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........
What is an Oracle index?
Does oracle partitioning improve performance?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
What is the implicit cursor in oracle?
What is the function of Optimizer ?
What is the meaning of recursive hints in oracle?
How to define an anonymous procedure with variables?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
Oracle General 
