OraFAQ Forum: Server Administration » how to load two datafile into two tables by control file?

Home » RDBMS Server » Server Administration » how to load two datafile into two tables by control file?

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

how to load two datafile into two tables by control file? [message #63471]

Thu, 07 October 2004 21:05

LEESHINYOUNG
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:	Some Recommendations Please
Next Topic:	Recovering a dropped table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 22:24:27 CST 2025