Explain the relationship among Database, Tablespace and Data
file?

Answer Posted / sahaja mallarapu

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is postgres faster than oracle?

561


How do I call oracle stored procedures that take no parameters?

567


How remove data files before opening a database?

566


How to export data to a csv file?

627


How does one get the view definition of fixed views/tables?

606






What is system global area (sga) in oracle?

576


What is oracle analytical function?

529


What is the quickest way to fetch the data from a table?

568


Give the various rollback segment states.

579


What is the difference between view and materialized view in Oracle?

610


How to convert characters to dates in oracle?

561


Are truncate and delete commands same? If so why?

654


How to best split csv strings in oracle 9i?

590


What is the oracle implicit cursor?

596


Differentiate between post-database commit and post-form commit?

545