I am no DBA and currently working on supporting Oracle ETL processes. I need to get a better explanation regarding Oracle architecture, as I do not quite get it from the manual.
The system I deal with is Oracle 10g on Sun Solaris.
I am aware that there is no relationship between tablespace and schema. I would have thought that the datafile somehow related to the schema. (I might be wrong here). I am concerned that the fact table is getting big and failing to insert is because it cannot extend the table due to no more free space. To prevent this, I would monitor the datafile where the table write. Thus, I wonder if there is a clear relationship between the schema and the datafile (physical storage). Is it because a schema is logical storage and a datafile is physical storage?
The naming of the tablespace is not related to the table name. It is using the size naming (M10A = allocate 10MB) convention.
Many thanks in advance.
Dig Deeper on Oracle DBA jobs, training and certification
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.