CREATE TABLE TEST_LOAD (SEQ_NO NUMBER, ADDRESS VARCHAR2(500),CREATE_DATE DATE);
CREATE SEQUENCE LOAD_SEQ MINVALUE 1 MAXVALUE 99999 START WITH 1 INCREMENT BY 1;

LOAD DATA
INTO TABLE SCH1.TEST_LOAD APPEND
fields terminated by "~"
TRAILING NULLCOLS
(
SEQ_NO "SCH1.LOAD_SEQ.NEXTVAL",
ADDRESS,
CREATE_DATE "sysdate"
)

123 someplace, somewhere
456 anyplace, nowhere

LOAD DATA
INTO TABLE SCH1.TEST_LOAD APPEND
fields terminated by "~"
TRAILING NULLCOLS
(
ADDRESS,
SEQ_NO "SCH1.LOAD_SEQ.NEXTVAL",
CREATE_DATE "sysdate"
)

SCH1@orcl_11gR2> CREATE TABLE TEST_LOAD (SEQ_NO NUMBER, ADDRESS VARCHAR2(500),CREATE_DATE DATE);

Table created.

SCH1@orcl_11gR2> CREATE SEQUENCE LOAD_SEQ MINVALUE 1 MAXVALUE 99999 START WITH 1 INCREMENT BY 1;

Sequence created.

SCH1@orcl_11gR2> grant insert on test_load to sch2
  2  /

Grant succeeded.

SCH1@orcl_11gR2> grant select on load_seq to sch2
  2  /

Grant succeeded.

SCH2@orcl_11gR2> host sqlldr sch2/sch2 control=test.ctl data=test.dat log=test.log

SCH1@orcl_11gR2> column address format a30
SCH1@orcl_11gR2> select * from test_load
  2  /

    SEQ_NO ADDRESS                        CREATE_DA
---------- ------------------------------ ---------
         1 123 someplace, somewhere       05-JAN-12
         2 456 anyplace, nowhere          05-JAN-12

2 rows selected.

output=`sqlplus -s $username/$password@$tnsname <<EOF
SELECT SCH1.LOAD_SEQ.NEXTVAL
FROM DUAL;
exit;
EOF
`
echo $output

NEXTVAL ---------- 1067

SQL*Loader: Release 10.2.0.4.0 - Production on Fri Jan 6 08:33:23 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Control File:   /loc/test.ctl
Data File:      /loc/Content.txt
Bad File:     /loc/Content_BAD.txt
  Discard File:  none specified
 
 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 10000
Continuation:    none specified
Path used:      Direct

Table SCH1.TEST_LOAD, loaded from every logical record.
Insert option in effect for this table: APPEND
TRAILING NULLCOLS option in effect

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ADDRESS                          FIRST     *   ,       CHARACTER            
CREATE_DATE                          NEXT     *   ,       CHARACTER            
    SQL string for column : "sysdate"
SEQ_NO                               NEXT     *   ,       CHARACTER            
    SQL string for column : "SCH1.LOAD_SEQ.NEXTVAL"


Table SCH1.TEST_LOAD:
  1 Row successfully loaded.
  0 Rows not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.

LOAD DATA
INTO TABLE SCH1.TEST_LOAD APPEND
fields terminated by "~"
TRAILING NULLCOLS
(
ADDRESS,
CREATE_DATE "sysdate",
SEQ_NO "SCH1.LOAD_SEQ.NEXTVAL"
)

EXECUTE IMMEDIATE 'CREATE TABLE TEST_LOAD (SEQ_NO NUMBER, ADDRESS VARCHAR2(500),CREATE_DATE VARCHAR2(25))';
EXECUTE IMMEDIATE 'CREATE SEQUENCE LOAD_SEQ MINVALUE 1 MAXVALUE 99999 START WITH 1 INCREMENT BY 1';

EXECUTE IMMEDIATE 'GRANT select on  LOAD_SEQ to SCH2'
EXECUTE IMMEDIATE 'GRANT select on TEST_LOAD to SCH2';
EXECUTE IMMEDIATE 'GRANT INSERT, UPDATE, DELETE ON TEST_LOAD TO SCH2';

LOAD DATA
INTO TABLE SCH1.TEST_LOAD APPEND
fields terminated by ","
TRAILING NULLCOLS
(
ADDRESS,
CREATE_DATE "sysdate",
SEQ_NO "SCH1.LOAD_SEQ.NEXTVAL"
)

hello

sqlldr $username/$password@$tnsname errors=10000 control="loc/test.ctl"  data="loc/Content.txt"  log="loc/test_load.log" bad="loc/Content_BAD.txt"  direct=true

select * 
from   all_tab_privs
where  grantee = 'SCH2'
and    table_schema = 'SCH1'
and    table_name = 'LOAD_SEQ';

select * 
from   all_tab_privs
where  
table_name = 'LOAD_SEQ';

GRANTOR                        GRANTEE                        TABLE_SCHEMA                   TABLE_NAME                     PRIVILEGE                                GRANTABLE HIERARCHY 
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --------- --------- 
SCH1                           SCH1_SEL_ROL          SCH1                  LOAD_SEQ               SELECT                                   NO        NO        

LOAD DATA
INTO TABLE TEST_LOAD APPEND
fields terminated by ","
TRAILING NULLCOLS
(
ADDRESS,
CREATE_DATE "sysdate",
SEQ_NO "SCH1.LOAD_SEQ.NEXTVAL"
)

LOAD DATA
INTO TABLE TEST_LOAD APPEND
fields terminated by ","
TRAILING NULLCOLS
(
ADDRESS,
CREATE_DATE "sysdate",
SEQ_NO SEQUENCE(MAX,1)
)

select * 
from   all_tab_privs
where  grantee = 'SCH2'
and    table_schema = 'SCH1'
and    table_name = 'LOAD_SEQ';

GRANT select on  LOAD_SEQ to SCH2;

"GRANTOR"	"GRANTEE"	"TABLE_SCHEMA"	"TABLE_NAME"	"PRIVILEGE"	"GRANTABLE"	"HIERARCHY"
"SCH1"	      "SCH1_SEL_ROL"	"SCH1"	         "LOAD_SEQ"	"SELECT"	"NO"	        "NO"

SQL> GRANT SELECT ON LOAD_SEQ TO SCH2;

Grant succeeded.

select * 
from   all_tab_privs
where  grantee = 'SCH2'
and    table_name = 'LOAD_SEQ';

GRANTOR                        GRANTEE                        TABLE_SCHEMA                   TABLE_NAME                     PRIVILEGE                                GRANTABLE HIERARCHY 
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --------- --------- 

0 rows selected

select owner, object_type from all_objects where object_name = 'ALL_TAB_PRIVS';

OWNER                          OBJECT_TYPE
------------------------------ -------------------
SYS                            VIEW
PUBLIC                         SYNONYM

http://www.sample.com/ümlat.html&q=user

[url]http://www.sample.com/?mlat.html&q=user[/url]

http://www.sample.com/\FFFDmlat.html&q=user