Problem Loading data into a table
Date: Sat, 7 Feb 2004 16:50:08 +0200
Message-ID: <4024fb3f$1_at_news.bezeqint.net>
[Quoted] Hi Folks,
I am a novice in Oracle, and it's the first time I try to use the Oracle Enterprise Manager.
My goal is to upload large quantities of data into an oracle table. I followed the instructions in the help file, but for some reason, when I try [Quoted] to upload the data into the database table using the Oracle Data Manager, nothing happens.
this is an example of a Control file I tried to upload with no success:
LOAD DATA
INFILE *
APPEND INTO TABLE dvc_grp_mems
FIELDS TERMINATED BY ’,’
(mem_id,mem_type,group_id)
BEGINDATA
300,2,6 301,2,6 302,2,6
One information you might find important: When I open the Enterprise manager and login, I only see the tree: Networks
Databases
Groups
Databases Groups Listener Groups
...
but I can't see anything in them, although when I open the Data Manager, I [Quoted] can see the databases and tables.
I hope that someone will manage to solve that problem for me. It drives me nuts.
Thanks,
David Received on Sat Feb 07 2004 - 15:50:08 CET