I've an Oracle database backup that was taken from Oracle 11g database server and I need to restore it on Oracle 10g Server. Is there any way to do this?
I got this error in the begining of the restore process:
imp-00038: could not convert to environment character set's handle
OS: SunSolaris Oracle version: 10g
I think it's a problem of different charactersets. You can move data from Oracle 11g to Oracle 10g, but you need to use an Oracle 10g exp utility. To make sure, use exp from your 10g database using sqlnet.
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…
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…