Re: Problem Loading data into a table

[Quoted] On Sat, 7 Feb 2004 16:50:08 +0200, "news.bezeqint.net" <dst_u_at_yahoo.com> wrote:

>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
>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
>can see the databases and tables.
>
>I hope that someone will manage to solve that problem for me. It drives me
>nuts.
>
>Thanks,
>
>David
>

[Quoted] Before doing anything else, click on the Navigator menu option, choose Discover nodes, follow the prompts and type your node name. If that doesn't work you don't have the Intelligent Agent running. As you don't come up with any platform and/or version info (/rant Why is that so difficult for people, and everyone thinks we can look over your shoulder /end rant), it is impossible to tell you how to resolve that potential problem.

--
Sybrand Bakker, Senior Oracle DBA