Oracle directories

Few basic information on oracle directories:

Related Data Dictionary Objects: all_directories and dba_directories
Create directory syntax :
sys>create or replace directory XYZ as '/oracle/path';
sys> grant read,write on directory XYZ to apps;
sys> select * from dba_directories;

script to find last 3 months archives generated

select SEQUENCE#,round(BLOCK_SIZE*BLOCKS/1024/1024,2),THREAD#,APPLIED,to_char(COMPLETION_TIME,'DD-MON-YYYY HH24:MI:SS'),to_char(COMPLETION_TIME,'DAY') from V$ARCHIVED_LOG
where to_number(TO_CHAR(COMPLETION_TIME,'HH24'))>=18 and to_number(TO_CHAR(COMPLETION_TIME,'HH24'))<=19
and to_char(COMPLETION_TIME,'DAY')='WEDNESDAY'
and APPLIED='YES'
order by COMPLETION_TIME desc

Io Exception: Got minus one from a read call for TOAD connections

Solution:
1. Go to directory $TNS_ADMIN
2. Modify sqlnet.ora file with following parameter:
tcp.validnode_checking = no
Note: If you don't want to disable this, you can put the machine names as follows:
tcp.invited_nodes=(machine1, machine2)
3. Bounce listener

Ref:342332.1-Troubleshooting Login Problems in Oracle Applications 11i

Constraints querry

select child.owner||'.'||child.table_name||'.'||child.column_name||' must exist in '||
parent.owner||'.'||parent.table_name||'.'||parent.column_name
from
all_cons_columns child
, all_cons_columns parent
, all_constraints c
where c.owner='T2IMGDEV'
and c.constraint_name='EMPR_ID_FK'
and child.owner=c.owner
and child.constraint_name=c.constraint_name
and parent.owner=c.r_owner
and parent.constraint_name=c.r_constraint_name
and child.position=parent.position
/

eg output:
CHILD.OWNER||'.'||CHILD.TABLE_NAME||'.'||CHILD.COLUMN_NAME||'MUSTEXISTIN'||PAREN
--------------------------------------------------------------------------------
T2IMGDEV.IMAGES.EMPR_ID must exist in T2MIFULL3.EMPLOYERS.ID

LRM-00112: multiple values not allowed for parameter 'data'

Solution:
a. Rename the data file so that it does not have spaces in it.
b. FTP the file to a directory on your server without spaces in the directory name.
c. Run the Bank Statement Loader process again, designating the file name without spaces and the
directory on your server without spaces.
d. Confirm you no longer get the LRM-00112 error.
Since this concurrent request runs on the server, it operates with respect to the directories defined on the server. Thus, it is not possible to load a file from another location unless it is setup/mapped as a directory on your server.

Ref:Bank Statement Loader Program Errors as LRM-00112 and SQL*Loader-100 [ID 433580.1]