How to Duplicate a Schema from One to Another
Suppose you are planning to duplicate user01 schema into user02 schema. Tools like TOAD, SQL Developer can be helpful. But you may also like to… Read More »How to Duplicate a Schema from One to Another
expdp
How to impdp AS SYSDBA without Password
impdp AS SYSDBA Like I talked about expdp as sysdba in the previous post, we usually use system who has sufficient privileges to perform data… Read More »How to impdp AS SYSDBA without Password
How to expdp AS SYSDBA without Password
expdp AS SYSDBA Normally, we use system to migrate data from one to another, who has pretty enough privileges for all kinds of manipulation at… Read More »How to expdp AS SYSDBA without Password
What Oracle Command-line Utilities Need Authentication - Oracle
Oracle provides many utilities to operate the infrastructure and database. Some of them need authentications to access database, but some don't. The bottom line is… Read More »What Oracle Command-line Utilities Need Authentication - Oracle
A Systematic Approach to Migrate Databases
There are several kinds of database migration: Moving a database. It is to move a database to a more powerful server with the same version.… Read More »A Systematic Approach to Migrate Databases