Re: newbie question - late response.
1) select * from v$database; Note: Picky perhaps, but instance and database may be different. ... 3) grant create session to scott; Note: CONNECT is a role that includes the create session system privilege and a LOT more. It is NOT a synonym for create session. ... Don Granaman OraSaurus - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, February 08, 2003 11:33 PM 1)How to find out from sqlplus what is the current database ? once, connected, do select * from v$instance; 2)and how to switch to another one ? from DOS prompt: by chaning your ORACLE_SID environment variable or via Net8: either from SQL*Plus: connect system/manager@another_db or from DOS: sqlplus system/manager@another_db. 3)How to create users in my new database ? after creating users do I have to do something to allow them get connected from another machine ? create user scott identified by tiger default tablespace users temporary tablespace temp; grant connect to scott; 4)Do I need to create a tablespace for my new database, if so how to do it ? OK, now I am gonna suggest you to read the Oracle's documentation: especially the Administrator's Guide. It's availabe on otn.oracle.com. 5)How to create tables ? See answer for #4. Thank you your help is appreciated. __ 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.net -- Author: majid 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 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.net -- Author: Richard Ji 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 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.net -- Author: Don Granaman 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 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 question
I would strongly recommend a good beginner DBA text such as DBA 101. http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1044859784 This will give you a good foundation for reading the docs. Jared On Saturday 08 February 2003 18:28, majid wrote: Hi, I used to use mysql databse, now I am new to Oracle, I just created a database called majidDB in Oracle8i using Database Configuration Assistant, a directory is created automatically after creation of the database : D:\Oracle\ORADATA\majidDB 1)How to find out from sqlplus what is the current database ? 2)and how to switch to another one ? 3)How to create users in my new database ? after creating users do I have to do something to allow them get connected from another machine ? 4)Do I need to create a tablespace for my new database, if so how to do it ? 5)How to create tables ? Thank you your help is appreciated. __ 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.net -- Author: Jared Still 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 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 question
Majid: 1) Try select name from v$database; 2) Use the connect keyword to connect to another database. Example : connect userid@database_name. 3) To create users, try create user [username] identified by [password] default tablespace [tablespace_name] temporary tablespace [tablespace_name] ; grant create session to [username]; That is the minimum needed to create a user. For further instructions I suggest you try reading the Oracle documentation. From your questions I believe you need to become a little more familiar with Oracle. There is a difference between questions that are typical for a newbie and those that signify I haven't got a clue. To answer the rest of your questions and to become more familiar with Oracle usage, try technet.oracle.com. Good hunting! RWB majid [EMAIL PROTECTED]@fatcity.com on 02/08/2003 08:28:35 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi, I used to use mysql databse, now I am new to Oracle, I just created a database called majidDB in Oracle8i using Database Configuration Assistant, a directory is created automatically after creation of the database : D:\Oracle\ORADATA\majidDB 1)How to find out from sqlplus what is the current database ? 2)and how to switch to another one ? 3)How to create users in my new database ? after creating users do I have to do something to allow them get connected from another machine ? 4)Do I need to create a tablespace for my new database, if so how to do it ? 5)How to create tables ? Thank you your help is appreciated. __ 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.net -- Author: majid 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 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.net -- Author: 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 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 question
1)How to find out from sqlplus what is the current database ? once, connected, do select * from v$instance; 2)and how to switch to another one ? from DOS prompt: by chaning your ORACLE_SID environment variable or via Net8: either from SQL*Plus: connect system/manager@another_db or from DOS: sqlplus system/manager@another_db. 3)How to create users in my new database ? after creating users do I have to do something to allow them get connected from another machine ? create user scott identified by tiger default tablespace users temporary tablespace temp; grant connect to scott; 4)Do I need to create a tablespace for my new database, if so how to do it ? OK, now I am gonna suggest you to read the Oracle's documentation: especially the Administrator's Guide. It's availabe on otn.oracle.com. 5)How to create tables ? See answer for #4. Thank you your help is appreciated. __ 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.net -- Author: majid 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 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.net -- Author: Richard Ji 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 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 question - still: please help
thanks a lot 4 your replies. /*i followed the way dick and mark suggested.*/ daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Wisser 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 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 question - still: please help
Daniel - Can you explain the two alternatives in a little more detail, especially the difference between the two. What types of systems are involved (Unix, Windows)? Thanks. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 13, 2003 10:14 AM To: Multiple recipients of list ORACLE-L hi! a DBA inteds to speed up a script that is looping and sending hundred thousands of sequential update statements like: UPDATE ISIS_DOCAR SET STATUS = 2000 WHERE ID = n; he suggests copying the table to a file, change it and then load it into the DB again. i am strongly convinced that this is nonsense. what is the best way to go for a script like this, doing tons of updates? (except convincing him to swith to sell burgers) thx daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Wisser 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 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.net -- Author: DENNIS WILLIAMS 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 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 question - still: please help
hi! a DBA inteds to speed up a script that is looping and sending hundred thousands of sequential update statements like: UPDATE ISIS_DOCAR SET STATUS = 2000 WHERE ID = n; he suggests copying the table to a file, change it and then load it into the DB again. i am strongly convinced that this is nonsense. what is the best way to go for a script like this, doing tons of updates? (except convincing him to swith to sell burgers) thx daniel Would be curious to know your DBA's background. The most reasonable thing might be to size rollback segments as needed, and remove the loop (I guess your loop is here to enable you to commit regularly). The second best option would be (8.1.5 and over) to load PL/SQL arrays and do bulk updates (refer to the PL/SQL doc for bulk updates). Files have their use, but not this one. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul 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 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 question - still: please help
Daniel, Your gut reaction is right on-target. It is always a struggle to keep certain folks from killing the entire village while trying to cure a single case of the sniffles. What's worse is that such folks are usually quite bright and talented. After, very few mediocre folks can either cure the sniffles or kill entire villages... ;-) Longer response: This is a common argument that eventually distills down to something like I don't need a stupid database engine to do this. I can do it all in (choose one): C, C++, Perl, shell script, Java. What the person has to realize is that those 'stupid database engines' started out as lone programmers doing what he is describing but then running into problems such as transaction recoverability (aka rollback), concurrency, and its close cousin read-consistency. Oh yeah, and then there is also what my good friend Gary once called DFB or diddly file build-up (i.e. an excess of diddly files in a file-system), which very few people see up front but invariably grows to dominate such approaches. After some decades of effort by thousands of developers and designers (very few of whom are stupid), what results is the modern database engine. Such people who think they can outperform database engines without losing such crucial features do not have any sense of humility about their place in the world. Ask him to skim through Gray and Reuter's Principles of Transaction Processing to gain some of that humility... Shorter response: look into using PL/SQL bulk-bind operations (i.e. FORALL, BULK COLLECT, etc) instead of one-row-at-a-time processing. I suspect the latter approach will be more effective... :-) Hope this helps...and keep up the good work! -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 13, 2003 9:14 AM hi! a DBA inteds to speed up a script that is looping and sending hundred thousands of sequential update statements like: UPDATE ISIS_DOCAR SET STATUS = 2000 WHERE ID = n; he suggests copying the table to a file, change it and then load it into the DB again. i am strongly convinced that this is nonsense. what is the best way to go for a script like this, doing tons of updates? (except convincing him to swith to sell burgers) thx daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Wisser 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 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.net -- Author: Tim Gorman 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 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 question - still: please help
Even with this little bit of information, it's obvious your DBA is on the right track. Any script that loops and executes 'hundred thousands of sequential update statements' is total nonsense. This will bring most any database to it's knees in a hurry. Oh yes, I've had developers pull this one on me. How about a 10gig text file of INSERT statements? Please supply more info, but from what you have here, I would say you should start listening to your DBA. Jared On Monday 13 January 2003 08:14, Daniel Wisser wrote: hi! a DBA inteds to speed up a script that is looping and sending hundred thousands of sequential update statements like: UPDATE ISIS_DOCAR SET STATUS = 2000 WHERE ID = n; he suggests copying the table to a file, change it and then load it into the DB again. i am strongly convinced that this is nonsense. what is the best way to go for a script like this, doing tons of updates? (except convincing him to swith to sell burgers) thx daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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 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 question
Yep, I've done it before without any problems -Original Message- Sent: 17 May 2001 05:06 To: Multiple recipients of list ORACLE-L Thank you so much for the info, DC. I have another stupid question. Can I have two different ports for two database in the same tnsname.ora on the same server? Cheers, Julia -Original Message- Sent: Wednesday, May 16, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Hi, Yes, you can modify instance parameters in the initXYZ.ora file. After you change them, they take effect when you bounce the instance (shutdown and startup) Also, there are some parameters that can be modify on the fly, without bouncing the instance. check this. SQL desc v$parameter NameNull?Type --- NUM NUMBER NAME VARCHAR2(64) TYPE NUMBER VALUEVARCHAR2(512) ISDEFAULTVARCHAR2(9) ISSES_MODIFIABLE VARCHAR2(5) ISSYS_MODIFIABLE VARCHAR2(9) ISMODIFIED VARCHAR2(10) ISADJUSTED VARCHAR2(5) DESCRIPTION VARCHAR2(64) SQL column name format a60 SQL column value format a20 SQL column ISSYS_MODIFIABLE format a6 SQL select name,value,ISSYS_MODIFIABLE from v$parameter; NAME VALUE ISSYS_ --- - -- processes50 FALSE sessions 60 FALSE timed_statistics TRUE IMMEDIATE--- You can change timed_statistics value with this command: alter system set timed_statistics=true; Hope it helps DC - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 16, 2001 3:19 PM Hi, guru, After I created a XYZ database using the Database Configuration Assistant, can I modify some parameters in the initXYZ.ora file? What steps should I take after the modification? Please advise. Regards, Julia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PHU,JULIA (HP-Sunnyvale,ex2) 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: Diego Cutrone 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: PHU,JULIA (HP-Sunnyvale,ex2) 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee
RE: newbie question
Hi, Yes, you can modify instance parameters in the initXYZ.ora file. After you change them, they take effect when you bounce the instance (shutdown and startup) Also, there are some parameters that can be modify on the fly, without bouncing the instance. check this. SQL desc v$parameter NameNull?Type --- NUM NUMBER NAME VARCHAR2(64) TYPE NUMBER VALUEVARCHAR2(512) ISDEFAULTVARCHAR2(9) ISSES_MODIFIABLE VARCHAR2(5) ISSYS_MODIFIABLE VARCHAR2(9) ISMODIFIED VARCHAR2(10) ISADJUSTED VARCHAR2(5) DESCRIPTION VARCHAR2(64) SQL column name format a60 SQL column value format a20 SQL column ISSYS_MODIFIABLE format a6 SQL select name,value,ISSYS_MODIFIABLE from v$parameter; NAME VALUE ISSYS_ --- - -- processes50 FALSE sessions 60 FALSE timed_statistics TRUE IMMEDIATE--- You can change timed_statistics value with this command: alter system set timed_statistics=true; Hope it helps DC - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 16, 2001 3:19 PM Hi, guru, After I created a XYZ database using the Database Configuration Assistant, can I modify some parameters in the initXYZ.ora file? What steps should I take after the modification? Please advise. Regards, Julia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PHU,JULIA (HP-Sunnyvale,ex2) 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: Diego Cutrone 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 question
Thank you so much for the info, DC. I have another stupid question. Can I have two different ports for two database in the same tnsname.ora on the same server? Cheers, Julia -Original Message- Sent: Wednesday, May 16, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Hi, Yes, you can modify instance parameters in the initXYZ.ora file. After you change them, they take effect when you bounce the instance (shutdown and startup) Also, there are some parameters that can be modify on the fly, without bouncing the instance. check this. SQL desc v$parameter NameNull?Type --- NUM NUMBER NAME VARCHAR2(64) TYPE NUMBER VALUEVARCHAR2(512) ISDEFAULTVARCHAR2(9) ISSES_MODIFIABLE VARCHAR2(5) ISSYS_MODIFIABLE VARCHAR2(9) ISMODIFIED VARCHAR2(10) ISADJUSTED VARCHAR2(5) DESCRIPTION VARCHAR2(64) SQL column name format a60 SQL column value format a20 SQL column ISSYS_MODIFIABLE format a6 SQL select name,value,ISSYS_MODIFIABLE from v$parameter; NAME VALUE ISSYS_ --- - -- processes50 FALSE sessions 60 FALSE timed_statistics TRUE IMMEDIATE--- You can change timed_statistics value with this command: alter system set timed_statistics=true; Hope it helps DC - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 16, 2001 3:19 PM Hi, guru, After I created a XYZ database using the Database Configuration Assistant, can I modify some parameters in the initXYZ.ora file? What steps should I take after the modification? Please advise. Regards, Julia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PHU,JULIA (HP-Sunnyvale,ex2) 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: Diego Cutrone 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: PHU,JULIA (HP-Sunnyvale,ex2) 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 question on Packages
Hi Rakesh, The Oracle user you are logged in as does not have select permission on V$SESSION. Log in as sys and issue the command: grant select on SYS.V_$SESSION to oracle user name; HTH, -Rocky --- Rakesh Dinger [EMAIL PROTECTED] wrote: Hi, I a newbie in Oracle and am trying to create a package body in PL/SQL, so please bear with me. The statements are: SQL create or replace package body RA_GET_TX_INFO_ 2 as 3 begin 4 select SID from V$SESSION; 5 end RA_GET_TX_INFO_; / Warning: Package Body created with compilation errors. SQL show errors package body RA_GET_TX_INFO_; Errors for PACKAGE BODY RA_GET_TX_INFO_: LINE/COL ERROR - 3/10 PL/SQL: SQL Statement ignored 3/26 PLS-00201: identifier 'SYS.V_$SESSION' must be declared How can I select from V_$SESSION inside the body? The user account has dba role granted and I can select from V_$SESSION from a normal PL/SQL session. Any help greatly appreciated. Thanks Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rakesh Dinger 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). = Rocky Welch Senior Consultant - Internet Services Group Arthur Andersen __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch 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 question on Packages
Did you create the package spec before you created the body? Kev -Original Message- Dinger Sent: Thursday, March 01, 2001 3:27 PM To: Multiple recipients of list ORACLE-L Hi, I a newbie in Oracle and am trying to create a package body in PL/SQL, so please bear with me. The statements are: SQL create or replace package body RA_GET_TX_INFO_ 2 as 3 begin 4 select SID from V$SESSION; 5 end RA_GET_TX_INFO_; / Warning: Package Body created with compilation errors. SQL show errors package body RA_GET_TX_INFO_; Errors for PACKAGE BODY RA_GET_TX_INFO_: LINE/COL ERROR - 3/10 PL/SQL: SQL Statement ignored 3/26 PLS-00201: identifier 'SYS.V_$SESSION' must be declared How can I select from V_$SESSION inside the body? The user account has dba role granted and I can select from V_$SESSION from a normal PL/SQL session. Any help greatly appreciated. Thanks Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rakesh Dinger 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: Kevin Kostyszyn 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 question on Packages
Let the beatings begin! grin The package will compile, but the error is basically a security issue. For some stupid reason, Oracle requires that access to objects referenced within packages and procedures (and views, too, methinks) be done explicitly to the owner of the package, and not to a role that the grantee is in. Try "GRANT SELECT ON V_$SESSION TO MYUSER;" from SYS, then recompiling the package. NOTE THE UNDERSCORE IN THE "V_$SESSION"! If you don't have it there in the GRANT, you'll get an error (ORA-2030?) about only being able to do this on a fixed view or something. HAND! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Disclaimer: As President of the Beer Ale Lager Lovers Society, I must leave work soon to drink beer to celebrate Beer Day. And since Beer Day only occurs every other Payday, I must have more than one. So don't blame me for my opinions stated in this email. That is all. -Original Message- Sent: Thursday, March 01, 2001 14:41 To: Multiple recipients of list ORACLE-L Beat me with an overextended RBS if you need be, but other than any permission issue, don't you need to SELECTINTO... in PL/SQL? Ready for my beating, - Ross -Original Message- Sent: Thursday, March 01, 2001 3:27 PM To: Multiple recipients of list ORACLE-L Hi, I a newbie in Oracle and am trying to create a package body in PL/SQL, so please bear with me. The statements are: SQL create or replace package body RA_GET_TX_INFO_ 2 as 3 begin 4 select SID from V$SESSION; 5 end RA_GET_TX_INFO_; / Warning: Package Body created with compilation errors. SQL show errors package body RA_GET_TX_INFO_; Errors for PACKAGE BODY RA_GET_TX_INFO_: LINE/COL ERROR - 3/10 PL/SQL: SQL Statement ignored 3/26 PLS-00201: identifier 'SYS.V_$SESSION' must be declared How can I select from V_$SESSION inside the body? The user account has dba role granted and I can select from V_$SESSION from a normal PL/SQL session. Any help greatly appreciated. Thanks Rakesh --- This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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 question on Packages
yup :) From: "Mohan, Ross" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Newbie question on Packages Date: Thu, 01 Mar 2001 12:40:41 -0800 Beat me with an overextended RBS if you need be, but other than any permission issue, don't you need to SELECTINTO... in PL/SQL? Ready for my beating, - Ross -Original Message- Sent: Thursday, March 01, 2001 3:27 PM To: Multiple recipients of list ORACLE-L Hi, I a newbie in Oracle and am trying to create a package body in PL/SQL, so please bear with me. The statements are: SQL create or replace package body RA_GET_TX_INFO_ 2 as 3 begin 4 select SID from V$SESSION; 5 end RA_GET_TX_INFO_; / Warning: Package Body created with compilation errors. SQL show errors package body RA_GET_TX_INFO_; Errors for PACKAGE BODY RA_GET_TX_INFO_: LINE/COL ERROR - 3/10 PL/SQL: SQL Statement ignored 3/26 PLS-00201: identifier 'SYS.V_$SESSION' must be declared How can I select from V_$SESSION inside the body? The user account has dba role granted and I can select from V_$SESSION from a normal PL/SQL session. Any help greatly appreciated. Thanks Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rakesh Dinger 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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 question on Packages
Now it's MY turn to get a beating! blush Obviously, the code won't compile as a package, and after trying it out as a procedure, I saw the light. Off to find a beer... :9 Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Jesse, Rich Sent: Thursday, March 01, 2001 15:46 To: Multiple recipients of list ORACLE-L Subject: RE: Newbie question on Packages Let the beatings begin! grin The package will compile, but the error is basically a security issue. For some stupid reason, Oracle requires that access to objects referenced within packages and procedures (and views, too, methinks) be done explicitly to the owner of the package, and not to a role that the grantee is in. Try "GRANT SELECT ON V_$SESSION TO MYUSER;" from SYS, then recompiling the package. NOTE THE UNDERSCORE IN THE "V_$SESSION"! If you don't have it there in the GRANT, you'll get an error (ORA-2030?) about only being able to do this on a fixed view or something. HAND! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Disclaimer: As President of the Beer Ale Lager Lovers Society, I must leave work soon to drink beer to celebrate Beer Day. And since Beer Day only occurs every other Payday, I must have more than one. So don't blame me for my opinions stated in this email. That is all. -Original Message- Sent: Thursday, March 01, 2001 14:41 To: Multiple recipients of list ORACLE-L Beat me with an overextended RBS if you need be, but other than any permission issue, don't you need to SELECTINTO... in PL/SQL? Ready for my beating, - Ross -Original Message- Sent: Thursday, March 01, 2001 3:27 PM To: Multiple recipients of list ORACLE-L Hi, I a newbie in Oracle and am trying to create a package body in PL/SQL, so please bear with me. The statements are: SQL create or replace package body RA_GET_TX_INFO_ 2 as 3 begin 4 select SID from V$SESSION; 5 end RA_GET_TX_INFO_; / Warning: Package Body created with compilation errors. SQL show errors package body RA_GET_TX_INFO_; Errors for PACKAGE BODY RA_GET_TX_INFO_: LINE/COL ERROR - 3/10 PL/SQL: SQL Statement ignored 3/26 PLS-00201: identifier 'SYS.V_$SESSION' must be declared How can I select from V_$SESSION inside the body? The user account has dba role granted and I can select from V_$SESSION from a normal PL/SQL session. Any help greatly appreciated. Thanks Rakesh -- - This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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). This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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).
