Re: Problem Loading data into a table

Hi,

Indeed, the agent was not started in the "Services".

I activated it and found the node (and the database appears in the OEM), but I still can't upload the file. Nothing happens.

Any other idea?

Thanks,

David
"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message news:d8ib2099biednr9ahdur8t52omnf6s84un_at_4ax.com...
> 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
> >
>
> 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
Received on Sun Feb 08 2004 - 18:55:10 CET