go to oracle installation directory,like C:\oracle\product\10.2.0\db_1\network\ADMIN\
check for listener.ora and tnsnames.ora file at DB server.
if there is IP/port change make sure to reflect same here.
if OS is windows : Net Manager tool can be run from:
windows > start > oracle entry in
to check what system level DB privilege have been granted:sqlplus /nolog
SQL>conn username/pwd
SQL> select * from session_privs;
using SQLPLUS login from sys or system user:
sqlplus /nolog
SQL> conn sys/pwd as sysdba
drop user username cascade;
grant connect,resource to username identified by pwd;
From 11g onward connect role has only the create session privilege.
then from cmd line:
imp username/pwd file=filename.dmp fromuser=scott touser=username log=impuser.log
Oracle easy connect feature from 10g onward:
sqlplus username/pwd@IP_ADDRESS_OF_DB_SERVER:PORT_NUMBER/SERVIVCE_NAME
sqlplus scott/tiger@192.168.90.100:1521/DEVDB
check for listener.ora and tnsnames.ora file at DB server.
if there is IP/port change make sure to reflect same here.
if OS is windows : Net Manager tool can be run from:
windows > start > oracle entry in
to check what system level DB privilege have been granted:sqlplus /nolog
SQL>conn username/pwd
SQL> select * from session_privs;
using SQLPLUS login from sys or system user:
sqlplus /nolog
SQL> conn sys/pwd as sysdba
drop user username cascade;
grant connect,resource to username identified by pwd;
From 11g onward connect role has only the create session privilege.
then from cmd line:
imp username/pwd file=filename.dmp fromuser=scott touser=username log=impuser.log
Oracle easy connect feature from 10g onward:
sqlplus username/pwd@IP_ADDRESS_OF_DB_SERVER:PORT_NUMBER/SERVIVCE_NAME
sqlplus scott/tiger@192.168.90.100:1521/DEVDB
Posts
