I have a oracle 8i database on a server. I would like to move the database to a different server. The new server has oracle 9i installed but not Oracle 8i. I would like to MOVE AND UPGRADE the database. How can I do this? The data, users, permissions and everything should be moved and upgraded.
Thanks in advace.
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…
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 setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines