What are the different type of Segments ?
Answers were Sorted based on User's Feedback
Answer / orawhiz
Data Segment,
Index Segment,
Rollback Segment and
Temporary Segment
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / nishi
4 types of segment
Index segment, data segment, temporary segment, rollback segment.
Is This Answer Correct ? | 0 Yes | 0 No |
What is a sub query? Describe its types?
How to update a table row with a record?
What are ddl statements in oracle?
Explain the difference between replace() and translate() functions in oracle?
What is SAVE POINT ?
What are the differences between date and timestamp in oracle?
Which of the following is not a database object TABLESPACE TABLE INDEX NONE
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How many types of segments in Oracle?
What are the tools for Oracle ?
How to invoke the original export import utilities?