Re: Any experts here?

Ok , Simple and Easy Solution , You dont even need to know SQL or SQL * Plus..

If you have Forxpro ODBC drvier that is fine enough.

Try to import your data in Access , using access Access Import External Data, selecting Foxpro ODBC data source.

Once you impor all data in Access .

Use Oracle Migration Work bench from Access to Oracle, and it is pretty much transparent to user, and smart enough to convert the basic Data type.

Good Luck !

Faheem Rao

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<ttdv259q54cp65_at_corp.supernews.com>...
> "ftp" <shyan_at_cse.cuhk.edu.hk> wrote in message
> news:9r6s9o$8bc$6_at_eng-ser1.erg.cuhk.edu.hk...
> > I have installed Oracle8i in Windows 2000.
> > I have written a test program to connect to the database by JDBC OCI
> > driver.
> > The job of my test program is to create a table, insert two records into
> > the table, select * from the table, print the data out and then drop the
> > table.
> > I find that it takes about 5 seconds to run the program. I guess that this
> > is due to the long login time.
> > How can I shorten the time to login to Oracle?
> > Where can I configure the Oracle in order to shorten the login time?
> > I'm a beginner to installation of Oracle, please answer me step by step if
> > possible.
> >
> > Thank you very much!
> >
> > --
>
> Five seconds is a meaningless measure and can be just anything, including a
> badly configured database. The Oracle defaults usually just *have* to be
> changed though it seems in latter release some parameters already have
> bumped. You don't provide any clue as to your config, and you seem already
> to know the solution.
> However, as far as I am concerned, you have identified yourself already as
> the typical newbie, that refuses to read any manuals (including the jdbc
> manual, see your other post), and expect this group to help him with just
> *every* step, *every* line of code, etc.
> That's not the purpose of this group nor of .misc and of .tools.
> I strongly *urge* you to start reading.
>
> Regards
> Sybrand Bakker
> Senior Oracle DBA
Received on Wed Oct 24 2001 - 19:33:33 CDT