Some time ago i had a need to create identical user on a test database every hour. To solve that i used impdp ability to use transfer over database link.
I have two databases . Production "db_prod" and test database "db_test". User that i am transferring has to preserve its name for easier testing.
1. Create public database link on db_test as SYSTEM:
create a public database link DB_PROD connect to system identified by xxxxx using ‘DB_PROD_ALIAS’;
2. Insert data (create users and all) from db_prod to db_test with impdp:
impdp system/xxxxxx@db_test schemas=user_prod network_link=db_prod_alias
This way there is no need to use remap_schema since both user names are the same. There is no need to use data_pump_dir because all transfer is done by database link.
There is some more job to be done. I ran script by hand at first to see what objects are giving me warning (Roles, references to another user) and to create a script to prepare test database for fresh injection of a test user. That means usually to drop existing user from db_test, create roles if needed (impdp will fill them with appropriate grants).
nedjelja, 24. studenoga 2013.
ponedjeljak, 4. studenoga 2013.
Install Oracle Developer 6i on Windows 7 x64
I have a need to install Oracle Forms and Reports Developer suite 6i with patch 14 on much newer WIndows 7 Professional 64-bit. At first attempt i tried and succeeded to install it all in 64 bit environment using Compatibility options but when i started to work with the tools i encountered many problems.
Next step was to install it in Windows Virtual PC )XP Mode). Steps to do so are:
Next step was to install it in Windows Virtual PC )XP Mode). Steps to do so are:
- Install Windows XP mode and Virtual PC as in instructions: http://windows.microsoft.com/en-us/windows7/install-and-use-windows-xp-mode-in-windows-7
- Download and install XP mode : http://www.microsoft.com/en-us/download/details.aspx?id=8002
- Download and install VirtualPC : http://www.microsoft.com/en-us/download/details.aspx?id=3702
- Create default XP machine and edit settings (i usually get RAM to 1GB):
After that i started XP mode, set up initial password for XPMode (this is required. Windows XP mode remembers this password, but in later actions it can ask for it. Sometimes when that password is blank, XPmode throws an error. On this site there is a manual how to reset: http://www.mydigitallife.info/resetand-fix-incorrect-or-wrong-password-for-windows-xp-mode-xpmuser/) and install Developer 6i. After that i put valid tnsnames.ora and sqlpnet.ora at %ORACLE_HOME%\network\admin directory.
Now Developer tools could be run directly in XPmode machine (some people find it easier) or from Windows 7 Start menu:
Pretplati se na:
Postovi (Atom)