Search results for query: *

Hey, I think KenCunningham gave you the clue. if CONSOLE=/dev/console is not commented, then you cannot remotely login to the server as ROOT. Login as reg. user and use "su -" cmd to switch to root user.

No, C is wrong. A "ROLLBACK TO SAVEPOINT" will not complete a transaction. It just rollbacks to savepoint. So, it seems like D & E are correct answer.

1z0-001 exam has small PL/SQL portion, but 1Z0-007 does not cover PL/SQL. So, I don't any other reason to take 1Z0-001.

Yes, it's correct that Oracle 8i Cert has been retired. But, fortunately for you that you can still use Oracle 8i first exam (1Z0-001) for ORacle 9i. So you can take either 1Z0-001 or 1Z0-007 exam for the first exam of oracle9i

Here's the excerpt from the book: If you specify a date value without the time component the default time is 12AM. If you specify a date value without the date component the default value is the FIRST DAY OF THE CURRENT MONTH. So, the date on the TIME column is seems to be correct. Even though...

It seems like the database is not started. To make sure, shutdown the database from SQL*PLUS with this command "shutdown immediate" and "startup" to restar the database. Also, make sure the listener is started by typing this command from shell prompt (unix) or command prompt (Windows): "lsnrctl...

Hi, Well, I can only speak from DBA's point of view. "Snap shot too old" can be avoid by increasing undo tablespace or avoiding a long running query, but you can't do anything about that since you don't have control over them. But, your plan of using session-specific temporary table should...

About using XP, i hardly used it for a few days. After that I trashed it. I've got WinME since my non-Linux family members dont like Linux very much." You went back to WinME. That thing is piece of garbage. It's worse than WIn98. I can't believe Microsft convince people to buy that JUNK. I...

Hey Adrian, I am a recent college grad w/ BS in CS and Oracle9i DBA(OCP) cert. I'm planning to take 1Z0-147 for developer OCA soon. Joe

Well, its true for Orcale9i DBA(OCP). I had to pay $1250 for one online course to meet that requirment.Its requirement for 9i OCP, but it doesn't pertains to OCA. I am also planning to take 1Z0-147 too. It might be required for 9i form (OCP), but I'm not 100% certain.

For Oracle9i DBA, it's required to take at least one course from Oracle university. It's pretty expensive. I paid $1250 for an online course and $2500 for in-class course. One way to get around that is to take the Oracle8i DBA cert and then take upgrade exam to 9i. One draw back is that you have...