OraFAQ Forum: Server Utilities » How to load record into a single table by using multiple data files.

Home » RDBMS Server » Server Utilities » How to load record into a single table by using multiple data files.

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

How to load record into a single table by using multiple data files. [message #171904]

Fri, 12 May 2006 04:02

sam_dinesh
Messages: 18
Registered: February 2006
Location: india

Junior Member

How to load record into a single table by using multiple data files.

I have 3 data files to be loaded into a single table.
eg
for table t1, i have three columns
(a1 number,
a2 char,
a3 char)

if i am using datafile_1, i have to insert constant value "active" into column a3.
for datafile_2,a3 will have constant value "inactive" and for datafile_3,a3 will
have constant value "end"

is there any option by achieving it by using a single control file?

Report message to a moderator