RE: Free Oracle DBA tests on the web
Not dead. Try this one: http://docs.rinet.ru:8080/ Mark -Original Message- Sent: Thursday, March 22, 2001 11:01 AM To: Multiple recipients of list ORACLE-L Dead link -Message d'origine- De : Ron Rogers [mailto:[EMAIL PROTECTED]] Envoyé : mardi 20 mars 2001 19:32 À : Multiple recipients of list ORACLE-L Objet : Re: Free Oracle DBA tests on the web Andrey ' Electronic books can be found at: RUSSIAN FREE BOOKS HTML FORMAT_+++ http://docs.rinet.ru/ ROR mª¿ªm >>> [EMAIL PROTECTED] 03/20/01 12:36PM >>> Hi DBAs ! I'm looking for some FREE Oracle DBA / developer resources on the web : self-tests , OCP preparations materials , articles , books , etc ... Please share your resources ! Thanks a lot in advance . Andrey . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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 message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy 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 message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Kirk 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 message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
The role is EXP_FULL_DATABASE Grant the roll to a user that has a default and temporary tablespaces that are different than 'SYSTEM' You want to avoid any chance of using the SYSTEM tablespace. That's it for now, Mark Mark Kirk Working toward the Oracle DBA OCP & seeking an entry level position... [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -Original Message- Xing Sent: Thursday, March 22, 2001 7:56 AM To: Multiple recipients of list ORACLE-L Subject: Hi, Can I perform a full export without using System account If I have to create a new user to perform a full export what are the roles that need to be granted ? Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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 message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Kirk 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 message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Someone changed INTERNAL password URGENT
Run orapwd. Replace the password file. This is only possible if you have admin rights on the system. The options will come up if you add nothing to the end of the command, and you can go from there. You can change the system and sys passwords using ALTER USER as an authenticated privileged user. That's it for now, Mark Mark Kirk Working toward the Oracle DBA OCP & seeking an entry level position... [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -Original Message- Vallath Sent: Tuesday, March 20, 2001 4:18 PM To: Multiple recipients of list ORACLE-L URGENT, Someone changed the internal password. How do you connnect or change the internal password, if not able to find it? Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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 message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Kirk 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 message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback segment
If you drop 3 of your 4 rollback segments you will suffer in your database ability to handle transactions. For a complete overview look here: http://technet.oracle.com/doc/oracle8i_816/server.816/a76965/c02block.htm#84 01 That's it for now, Mark Mark Kirk Working toward the Oracle DBA OCP & seeking an entry level position... [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -Original Message- [EMAIL PROTECTED] Sent: Saturday, March 03, 2001 6:45 AM To: Multiple recipients of list ORACLE-L Hi, Anyone have idea, how Oracle8i make used of multiple rollback segments to reduce system contention? I am currently using 4 rollback segments what will happen if 3 of them are offline? :<( Thanxs, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Kirk 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 message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: svrmgrl vs sys account
I am not sure I understand your question, but basically, if you define the tablespace for your new user and the temporary tablespace too, then there is no difference. It is important to avoid using the system tablespace for users data and temporary tables. That could lead to fregmentation and would be a risk to your database. As far as rights and privileges go -- why don't you create a user for yourself with dba privileges and then avoid the use of the sys and system users altogether. Using sys is needed for only a small handful of actions, so try to stay away from causing use of the system tablespace by any actions as a user. That's it for now, Mark Mark Kirk Working toward the Oracle DBA OCP & seeking an entry level position... [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -Original Message- [EMAIL PROTECTED] Sent: Saturday, March 03, 2001 3:50 AM To: Multiple recipients of list ORACLE-L Hi, I am a beginner DBA could you tell me what is the diffrent: create user /tablespace or else using svrmgrl> and sys account oh ya.. I'm using Oracle8i Thank you very much -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Kirk 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 message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: newbie
go to www.oracle.com technet.oracle.com www.lazydba.com pipetalk.revealnet.com That's it for now, Mark Mark Kirk Working toward the Oracle DBA OCP & seeking an entry level position... [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -Original Message- Sent: Saturday, March 03, 2001 9:20 AM To: Multiple recipients of list ORACLE-L halo all, i'm a newbie trying to start learnig about oracle programming problem is.i don't where to start :( enlighten pse... ...azmi... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: u.-azmi 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 message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Kirk 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 message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).