What are the components of Logical database structure of
ORACLE database?
Answer Posted / jidnesh
The Logical Database Structure of an Oracle include the
schema objects, data blocks, extents, segments and tablespaces.
schema objects means table, index, synonyms, sequences etc.
Data blocks are the smallest part of the oracle database
defined by DB_BLOCK_SIZE parameter.
A group of data blocks forms an extent.
An extents groups tends to segments, and lastly a group of
segment forms a tablespace.
| Is This Answer Correct ? | 26 Yes | 4 No |
Post New Answer View All Answers
How many categories of data types?
Explain mutating triggers.
please explain.. DB architecture ...
What is oracle open database communication (odbc)?
How to get execution path reports on query statements?
How to revoke create session privilege from a user in oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What are the differences between char and varchar2 in oracle?
How to use "while" statements in oracle?
What happens if the imported table already exists?
Explain an exception?
What the is the diff between local index and global index. give some example.
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How to use group functions in the select clause using oracle?