Access to oracle
vikram
In our company we have been using access, now we are planning to use
Oracle. I am not that well versed in DBA. Anyone can guide with some
links or some materials or advice me the neccessary
Thanks
vikram
AnaCDent
http://tahiti.oracle.com <- complete online documentation set
http://asktom.oracle.com <- lots of GOOD How Tos
http://otn.oracle.com <- many good white papers & other goodies
It is time for you to go & RTFMs.
Daniel Morgan
I know some will interpret this as harsh and horrible ... but I
trade in truth ... not smoke and mirrors.
The chances of you being successful in Oracle are absolutely zero
based on your background and experience.
This does not mean you couldn't learn ... but we are talking about
months or years ... not days and weeks.
My suggestion. Get a copy of Tom Kyte's book Expert one-on-one
Oracle and read the first three chapters until your eyes bleed.
Then reread the entire book.
After that go to http://tahiti.oracle.com and read the concept
and architecture documents.
Then, and only then, try to write some SQL and PL/SQL in Oracle.
There a lot of demos to help you at http://www.psoug.org. Click
on the link to Morgan's Library.
And very importantly ... remember we will gladly help you. But
you must demonstrate that you have put in some real effort to
read and learn before you ask a question on a subject.
Best wishes.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damo...@x.washington.edu
(replace 'x' with a 'u' to reply)
Mark Townsend
Thomas T
news:5ce659ec.04032...@posting.google.com...
Good thing you're moving away from Access; the only thing it's good for is a
single-user. Even a flat file would be better for a business than Access!
Along with everyone else's suggestions, see if you can find the "Oracle 8i,
A Beginner's Guide" book, published by Osborne/Oracle Press. And while
you're at the bookstore, see if you can find the Oracle Certification books.
Remember the basic rule of "Do tests of everything!" Create a test server
on an old PC with whatever operating system you use for your network. Once
your test server is set up, do a test installation of Oracle on it. Set up
your client to connect to the test server and run test queries against the
test database. Take notes on Everything and use them when you set up your
production server.
As you develop your programs and plan your migration, always test everything
on the test server first. Practice your backups, recoveries, auditing,
tuning, schema creation, and everything else on the test server. Once
you're sure one thing is perfect on the test server, then you should
replicate it on the production server. You'll only feel slighly upset if
you destroy the test server/database, but you might be fired if you destroy
the production server/database! And it's much more fun to learn on a test
server, because test servers can be rebuilt in a few hours. You don't want
to ever have to rebuild a production box.
-Thomas