Example:
SQL> alter table MY_PART_TABLE modify partition PR198 ALLOCATE EXTENT;
Table altered.
The need for the above might arise after creating a partition table with deferred segment allocation.
Oracle DBA and beyond; these are practical tips for day to day DBA operation and maintenance; a place where you would come to look for a quick fix for a burning situation. I hope that by sharing all these, we all will become better in what we do. And on the way, I hope to save you some sweat :-)
Thursday, 14 July 2016
How to allocate an extent for a partitioned table?
Example:
SQL> alter table MY_PART_TABLE modify partition PR198 ALLOCATE EXTENT;
Table altered.
The need for the above might arise after creating a partition table with deferred segment allocation.
SQL> alter table MY_PART_TABLE modify partition PR198 ALLOCATE EXTENT;
Table altered.
The need for the above might arise after creating a partition table with deferred segment allocation.
Tuesday, 5 July 2016
Manual recovery until specific time (not with RMAN)
RECOVER DATABASE UNTIL TIME '1992-12-31:12:47:30' USING BACKUP CONTROLFILE;
Subscribe to:
Posts (Atom)