lvzhqi的专栏

SummarySymptomORA-01628: max # extents reached for rollback segment ORA-01629: max # extents reached saving undo for tablespace ORA-01630: max # extents reached in temp segment in tablespace ORA-0

SummarySymptom1. What is reorganization?2. Which objects can I reorganize?3. In which situations is reorganization useful?4. In which situations does reorganization not make sense?5. Which

SummarySymptom1. Why is a temporary tablespace required?2. What is the default name of the temporary tablespace in the SAP environment?3. Which types of temporary tablespaces are available?4

SummarySymptom1. What types of database objects exist?2. How can I determine the type of database objects?3. What are extents and segments?4. Can extents or segments extend across several da

SummarySymptom1. What are database statistics used for?2. When are database statistics not required?3. What type of information is covered by database statistics?4. What are histograms?5.

SummarySymptomORA-01650: unable to extend rollback segment in tablespace ORA-01651: unable to extend save undo segment for tablespace ORA-01652: unable to extend temp segment in tablespace ORA-01

1. List all datafile for tablespace PSABTABD 2. shutdown DB 3. move datafile using brtools or copy using OS level 4. startup mount database (if using copy OS Level) 5. execute this command to change c