Answer Posted / javeed_mj
An Oracle database consists of one or more logical storage
units called tablespaces, which collectivley store all of
the database's data.
Each tablespace in an ORACLE database consists of one or
more files called datafiles, which are physical structures
that conform with the operating system in which Oracle is
running.
For Example::: A simple Oracle Database have one tablespace
and one datafile
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How oracle handles dead locks?
How to list all tables in your schema?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Explain the use of tables option in exp command.
How to update values in a table in oracle?
What is a read write transaction in oracle?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
various types of hints and their usage
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is connection pooling in oracle?
What is null value in oracle?
How do you tell what your machine name is and what is its IP address?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
Is oracle a language?
How to start your 10g xe server?