Guys I am investigating thid scenario.
Say I creating compressed rman backup sets and they are copied to tape. then a disaster occurs and i completly loose that server I now need to use these backups on a totally differen server with a different folder configuration I dont have a rman catalog.
What do I do.
I thougth I could use a command named catalog but i read some where that this may not be the case.
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
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.