Showing posts with label oracle. Show all posts
Showing posts with label oracle. Show all posts

Friday, November 21, 2014

Increase Weblogic memory in Integrated Weblogic server of Jdeveloper

Go to JDEV_HOME\system12.1.2.0.40.66.68\DefaultDomain\bin and open setDomainEnv.cmd  or setDomainEnv.sh based on whether it is a windows or linux machine.

Scroll down until you see WLS_MEM_ARGS, below that enter

In the case of Windows:
set USER_MEM_ARGS = -Xms64m  -Xmx2048m  -XX:MaxPermSize=1024m

In the case of Linux:
USER_MEM_ARGS="-Xms64m  -Xmx2048m  -XX:MaxPermSize=1024m"
export USER_MEM_ARGS

Saturday, February 15, 2014

How to import data into a user when another user with same data exists



Facing ORA-39151 error while trying to import data into a user when there is another user with same tables ??


Answer


impdp user/password DUMPFILE=file_name directory=dir LOGFILE=test.log REMAP_SCHEMA=USERA:USERB TABLE_EXISTS_ACTION=APPEND
USER A is the existing user USER B is the new user