About five hours ago i went through OEM to resize a datafile in the TEMP tablespace which had zero data. TEMP is not the default temporary tablespace. Looking at OEM all i see is that pink 'other' blocked sessions 1 root blockers 1. What needs to be done to have Oracle actually complete the resize this century?
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.