Prem Somasekaram

Greenhorn
+ Follow
since Jan 14, 2002
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Prem Somasekaram

Hi Bal,
Yes I've been using download utility program for bigger files but then I've also a >512Kb connection. Please note that for windows 98/ME only personal edition is available which is good enough to start with and actually contains the most of standard edition.
Regards,
Prem
[ March 17, 2002: Message edited by: Prem Somasekaram ]
[ March 17, 2002: Message edited by: Prem Somasekaram ]
22 years ago
Hi,
You may also want to use a download utility program such as http://www.getright.com so that the downloading can be resumed at a later time.
Regards,
Prem
22 years ago
Congratulations Satya,
Regards,
Prem
Hi Krishnan,
The first three exams have the status "production" while the fourth one is still in the beta and expected to be available in May/June.
http://www.oracle.com/education/certification/news/index.html?o9ibeta_sched.html

Regards,
Prem
22 years ago
Congratulations Kent,
Regards,
Prem
Hi Gaja,
Sybex has just released the first book and other books are about to follow.
OCA/OCP: Introduction to Oracle9i SQL Study Guide
http://www.sybex.com/SybexBooks.nsf/booklist/4062
OCA/OCP: Oracle9i DBA Fundamentals I Study Guide
http://www.sybex.com/sybexbooks.nsf/ae092569548ddb4688256989 0063ee4e/8f866a41e19180fd88256a9d00319ef2!OpenDocument
OCP: Oracle9i DBA Fundamentals II Study Guide
http://www.sybex.com/sybexbooks.nsf/ae092569548ddb4688256989 0063ee4e/a0a5c28c709a08be88256a9d00319ef4!OpenDocument
OCP: Oracle9i Performance Tuning Study Guide
http://www.sybex.com/sybexbooks.nsf/ae092569548ddb4688256989 0063ee4e/041d993afd47ede088256a9d00319ef7!OpenDocument
Regarding selftest software, you can download a demo test just see how good it is.
Regards,
Prem
[ March 04, 2002: Message edited by: Prem Somasekaram ]
22 years ago
Congratulations!
Regards,
Prem
22 years ago
Not exactly a DBA kit but a boxed set to cover the entire OCP track will be available from July 2002.
http://www.amazon.com/exec/obidos/ASIN/007219524X/ref=pd_pym_sim_1_2/103-9759218-6406267

Regards,
Prem
22 years ago
Congratulations!
Regards,
Prem
22 years ago
All four books for the new track are now almost available. Please check:
OCP Introduction to Oracle9i: SQL Exam Guide
http://www.amazon.com/exec/obidos/ASIN/0072195371/qid=1015021869/sr=2-1/ref=sr_2_1/103-9759218-6406267
OCP Oracle9i Database: Fundamentals I Exam Guide
http://www.amazon.com/exec/obidos/ASIN/0072195401/qid=1015021869/sr=2-3/ref=sr_2_3/103-9759218-6406267
OCP Oracle9i Database: Fundamentals II Exam Guide
http://www.amazon.com/exec/obidos/ASIN/0072195436/ref=pd_sim_books/103-9759218-6406267
OCP Oracle9i Database: Performance Tuning Exam Guide, not yet published. I expect it to be available within one-two weeks.
http://www.amazon.com/exec/obidos/ASIN/0072195274/ref=pd_sim_books/103-9759218-6406267
A boxed set to cover the entire OCP track will also be available from July 2002.
http://www.amazon.com/exec/obidos/ASIN/007219524X/ref=pd_pym_sim_1_2/103-9759218-6406267

Regards,
Prem
22 years ago
There is a brief introduction to data warehouse here.
http://www.olapvision.com/datawarehse.htm
This one is a more technical.
http://www.kenorrinst.com/dwpaper.html

SAP specific info
http://www.sap.com/solutions/bi/brochures.asp
SAS specific info
http://www.sas.com/rnd/warehousing/concept.html

Regards,
Prem
22 years ago
Controlfiles are unique for each database and have updated data specific for that database such as database name, checkpoint information, timestamp info, log sequence, and locations of data files so even if we copy from an existing database, it�ll still not work. I�d recommend creating new control files by starting the database in nomount mode only and issuing the CREATE CONTROLFILE statement. Please also make sure that you have more than one set of control files by defining it in init.ora.

Regards,
Prem
22 years ago
Not yet but there are a few demo version of commercial tests.

http://www.boson.com/tests/dba.htm
http://www.selftestsoftware.com
Regards,
Prem
22 years ago
Congratulations Joe,
Rgds,
Prem
22 years ago
Collateral Damage
22 years ago