Re: OCP 7.3 8 upgrade to 9i

Hi All, >From the Oracle Education Certification Page: http://www.oracle.com/education/certification/index.html?dba9i_upgrade.html Shows 4 possible tests: Oracle9i DBA OCP Upgrade Path Upgrade exams for Oracle7.3, Oracle8 and Oracle8i DBA OCPs. In order to make the process of staying

Re: Oracle License for Training

Hi All, This conversation didn't start out in dealing with educational institutions, it started out as a group that wants to use it to make money. Oracle is making every effort to work with legitimate education institutions. The Oracle Academic Initiative does exactly what you describe.

Re: Oracle License for Training

You are WRONG! The Oracle Academic Initiative has 100's of members. In California there are more than 200. John [EMAIL PROTECTED] wrote: Quoting Markus Reger [EMAIL PROTECTED]: I have to manage MySQL and ORACLE for the web likewise. There seems to be a strong tendency towards

Tkprof On Windows 9.0

Hi All, Go to metalink and download patch 2271678 to install tkprof on 9i Release 1. As was already mentioned this has been resolved in 9iR2. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: Configuring back up in Oracle 9i

-Original Message- From: Ora NT DBA [SMTP:[EMAIL PROTECTED]] Sent: Saturday, January 25, 2003 11:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: Configuring back up in Oracle 9i Another common problem is that in Windows environments that the user on the node must be granted

Re: Configuring back up in Oracle 9i

Another common problem is that in Windows environments that the user on the node must be granted the "log on as batch" privilege . This is true even if they are in the admin group. John [EMAIL PROTECTED] wrote: RE: Configuring back up in Oracle 9i look in your

Re: CBO not using the index even though it is faster when hinted

mode = Choose also using Tim Gormans 90 and 50 values for the other optimizer parms. Select col1, col2, col3, blah1, blah2 from table order by col1, col2, col3; Concatenate index on col1, col2, col3. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ora NT DBA INET

Re: simple question on DDL

Hi Rachel, Good point about the autonomous transactions. If I remember correctly that was new in 8i. My general theory on WHY questions is "That's the way they coded it!". They probably could have coded it differently, but they didn't. The important thing is that it is well documented how

Re: Truncate system tables.

Hi Tom, Nothing I would feel comfortable with. Be happy that it was new. I would recomend trashing it and starting over. John Terrian, Tom (Contractor) (DAASC) wrote: Message ummm...I just truncated all of the system tables in a new database (that's not good). No

Re: Oracle 8i Certification Will Terminate When???

Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET

Re: 9i Lite

would appreciate it. Thanks, Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: HOW TO FIND FREQUNT OBJECT ACCESS

McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Get together at OOW

dropped into a car-salesman's convention :-) Connor -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: Where is output of analyze table ... validate structure cascade?

://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

Re: No Nulls? (was: Warehouse design: snowflake vs

Sounds like they needed a business rule, enforced by a constraint saying the date of death must be less than or equal to sysdate :-). John Toepke, Kevin M wrote: I was once a consultant on a large Payroll project and ran into a case where someone had entered a date of death 1 year in

Re: No Nulls? (was: Warehouse design: snowflake vs star schem

Both would likely do FTS since at any given time more than 50% of your employees will be current (have an end date of 1/1/4000' making it very unlikely that the cbo would choose this index. The RBO, would, but it would likely degrade not improve your performance. John Grabowy, Chris

Re: remove move a user

-- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send

Re: Orace setting on NT

Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Lost ofall redo logs

I agree, there is never a problem because you backed up redo log files. There could be a problem with inadvertently restoring them, covering up needed information in the current online redo logs. John [EMAIL PROTECTED] wrote: My long standing position on this is that you take backups so

Re: Estat Bstat

. Does anyone have a cleaner version? R. Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Moving data between tablespaces[Scanned]

created in the SYSTEM tablespace. Is there any way to move the records and the table to some other tablespace? regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: SQLPlus was Oracle - can you imagine ;-)

SQLPLUS related issues can you imagine;-) Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED

Re: OT: 8i OCP questions

NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail

Re: How to know if another database is running on the same machine?

or perhaps the view shows the one that is active). How do I know whether the other database is there or not and how to make it accessible? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services

Re: Can't Connect to DB

Hi Ken, Is your listener started?? That appears to be the case based on this message. Go to your services and see if the Oracleorahomenamelistener service is started. If not then start this service and try to connect then. If you are getting an error when attempting to start the service you

Re: How to deinstall oracle 9i and leave 8i intact

Hi Rick, I would first shut down the 9i versions of the services for any database, listeners, intelligent agents, etc. Then using the installer I would deinstall all 9i software. Then using regedt32 I would remove the home key for the Oracle9i home. That should just about do it. John

Re: DB Config. Assistant

Hi Ken, When you run the database configuration assistant (DBCA) it asks you to provide the sid for the database. You should be able to see the service associated with this database by looking at the "services". Don't know ANY XP but the service should be named "OracleServiceSID". Check to

Re: Dangerous BUG in Oracle. Oracle Unbreakable ???

://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

Re: SQL help

/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: URGENT : contact phone of Oracle Support

phone no. for contacting Oracle support. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: RAC

Which reminds me of a joke I heard once. You know what the difference between a used car salesman and a computer salesman The used car salesman usually knows when he is lying! ba-dum-dum John [EMAIL PROTECTED] wrote: I agree with Scott's reply. Compaq may be able to claim the

Re: sql isql

the difference between 'sql' and 'isql' in Oracle. I shall be grateful if anyone please mention some differences. mks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Re: TKPROF?

- online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: anyone see my DBA_AUDIT_TRAIL ??? (solved) bug or Architecture ?

object for describe Why I can not describe my DBA_AUDIT_TRAIL ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: Cold NT backups

see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Failed login attempts

--+C.S Waibale SimonMTN-Uganda,Cell: +256 77-212655,http://mtn.co.ug+---+ --Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Ora NT DBA INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX:

Re: Failed login attempts

-212655,http://mtn.co.ug +---+ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: refer to SYSDATE function in a CHECK constraint--doable?

anything that refers to the sysdate function--is it just not allowed? I'm pretty sure you can use it as a DEFAULT... Thanks! -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA

Re: Oracle Certification Upgrade 8 to 8i

Certified DBA __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services

Re: Sql loader - schedule

day. This sqlloader simply loads a textfile into a table in the database. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELOG mo

The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

You can call them whatever you like, nothing in the world will save the clueless person you describe below :-). You are correct in saying it is a training issue, I personally use hot and cold but think offline and online are just fine as well. The issue is that the mode "archive vs

Re: cannot find database in OEM ???

/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Oracle.exe taking too much physical ram

Hi Arslan, Without know anything else it would be difficult to diagnose exactly what to do. But from the size of the allocated SGA it appears that you need to reduce some of these parameters. >From v$sga you have 640 MB of database buffer cache 80 MB of shared pool and other things What

Re: Cost vs Rule

This shouldn't be a problem, hints just look like comments to other db's. John [EMAIL PROTECTED] wrote: not much - desire is to keep sql ANSI compliant due to cross-platform issues(want to be able to run the app on multiple db's)-Original Message-Sent: Thu, March 07, 2002 2:44

Re: row level lock

Hi Shishir, This is oracle's default behaviour. As you update , insert or delete a row oracle places a lock at the row level. John HOugh [EMAIL PROTECTED] wrote: HI list! I want to lock a table on row level ( not table level). how do we pass the pass that value in syntax which

Re: FRAGMENTATION QUESTION?

with fragmented tables data? Thx -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED

Re: # of datafiles per tablespace

Hi Kathy, The only thing I can think of for your original question is a bad guess on the file size. They guessed 500 mb, ran out of file space, added a 50 mb file to the Tablespace, ran out again added 50 mb again. never ran out again. Reading other dba's minds is so much fun :-) John

Re: TABLE SIZE?

_ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: Clash of the DBs in eWeek

, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Unused users for the last 30 and 60 days.

-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Re: Clash of the DBs in eWeek

ex, WI USA --Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Ora NT DBA INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051

Re: Unused users for the last 30 and 60 days.

and then setthe grace period to a day or so and then check for users whose accountsare locked?--- Ora NT DBA [EMAIL PROTECTED] wrote: Hi Deepender,I know of know builtin oracle view that will tell you thisinfomation. At a formerjob we were required to disable accounts that had not been used

Re: MIGRATION

on another disk g partition would be fine. g Any suggestion please? g Thx g guri -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California