OraFAQ Forum: Server Administration » how to load two datafile into two tables using Control file?

Home » RDBMS Server » Server Administration » how to load two datafile into two tables using Control file?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to load two datafile into two tables using Control file? [message #63494]

Mon, 11 October 2004 01:11

LEE SHINYOUNG
Messages: 1
Registered: October 2004

Junior Member

hi! I wnat to load two datafile into two tables by control file.

but next control file is printed error!

What's wrong?

LOAD DATA
INFILE 'E:TPD71M$AUD.prn'
INFILE 'E:TPD72M$AUD.prn'

INTO TABLE tpd71m$audTemp
(Pj_Cd POSITION(01:10) CHAR,
Curr_Sts POSITION(12:13) CHAR,
Pj_Chrct POSITION(20:21) CHAR)

INTO TABLE tpd72m$audTemp
(Pj_Cd POSITION(01:10) CHAR,
Curr_Sts POSITION(13:14) CHAR,
Rvw_Dvsn POSITION(21:22) CHAR,
Outcm_Anly POSITION(29:34) CHAR)

Report message to a moderator

Previous Topic:	SPFILE problem !
Next Topic:	Problem with To_Date

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 23:06:05 CST 2025