Problem Loading data into a table

From: news.bezeqint.net <dst_u_at_yahoo.com>
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

Original text of this message