How to Identify Connected Database Instance is Primary or Standby?

For primary and standby database the database name will be same and instance name will be different. These are the main differences to identify the primary and standby database instances.

Primary

1.  SQL> select name from v$database;

NAME

---------

KMPRD

SQL*Loader PARFILE Parameter

There are 2 ways to specify the parameters to the SQL* loader-command line and parameter file. Suppose if you are running the SQL* loader through command line by giving the credentials you cannot hide the password from the process list (ps –ef). Also, if you have more number of parameters needs to specified with the SQL* loader in that case there are some limitations for the command prompt.