How to define Data Block size ?
Answers were Sorted based on User's Feedback
Answer / orawhiz
A data block size is specified for each ORACLE database when
the database is created. A database users and allocated free
database space in ORACLE datablocks. Block size is specified
in INIT.ORA file and cann't be changed latter.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nishi
A data block size is specified for each ORACLE database when the database is created. A database users and allocated free database space in ORACLE datablocks. Block size is specified in INIT.ORA file and can't be changed latter.
Is This Answer Correct ? | 0 Yes | 0 No |
Explain database link?
What is the implicit cursor in oracle?
How to store pictures on to the database?
what is the use of composite key constraint?
types of indexes and the rationale behind choosing a particular index for a situation.
How to drop an existing view in oracle?
what is the exact definition for pointer?
Difference between pre-select and pre-query
How to export your own schema?
what are the advantages of running a database in archive log mode?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is difference between SUBSTR and INSTR?