Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the relationship among Database, Tablespace and Data
file?
- 4 Answers
- 12641 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chaudhry
Each databases logically divided into one or more
tablespaces One or more data files are explicitly created
for each tablespace.
| Is This Answer Correct ? | 8 Yes | 2 No |
Each data base is divided into logical units called table
spaces and each table space is again divided into segments.
Data files are created for table spaces.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi
database contain atleast one tablespace and tablespace must have atleast one datafile
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / riddhi
An Oracle database consists of one or more logical storage
units called tablespaces.
tablespaces is consist of one or more datafiles.
| Is This Answer Correct ? | 0 Yes | 0 No |
select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help
What is the max number of columns in an oracle table?
what is view?
How to synchronize 2 schema's objects?
12. Display the client name in upper case only and in lower case only.
how many columns can a plsql table have
What is open database communication (odbc) in oracle?
What is a shared pool?
when loggined as SYSTEM,how to display all the users of database using sql query?
difference between procedures and function?
What is STATSPACK tool?
What is Partitions in Table ?
Oracle General 
