Re: Package standard - 9i for W2000 installation
Thank you Paul, Jared, Yosi, One of my friend checked my database, and he discovered that my database is not working properly. We removed the database and installed it again. Now it is working well. He also does not know what was the problem. Thank you very much for your instant help, Harun. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, October 01, 2001 12:25 AM > Harun, > > connect in sqlplus as user sys and execute: > > ALTER PACKAGE dbms_standard COMPILE; > > hth, > > Paul > > > Harun Altay wrote: > > > > I did it at last, as you and Jared had described. I run that script. I got > > those messages below. Later on, I tryed to give privilages to SYS user by > > administrator, and I got the same error message as before : ORA-06553: > > PLS-213: package STANDARD not accesible. > > > > Thanks. > > > > the very(!) last part of the output message in the ms-dos screen for > > SQL*Plus is below: > > > > -- > > create or replace public synonym dba_ias_objects for dba_ias_objects > > * > > ERROR at line 1: > > ORA-00604: error occurred at recursive SQL level 1 > > ORA-06553: PLS-213: package STANDARD not accessible > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Drake > 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: Harun Altay 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).
directory manager
I am tryingt log in the orcle directory manager but it says that the server is down... I try with system manager, localhost, and the server is runing, it says server is not up and running 389/localhost... so whaqt shoudl I do to get the server up and running, e becasue it is up and runnig, I mean I can conect via dbastudio, other thing when I open the dbastudio, it gives me 2 different choisses, login to the oracle managment server and launch dbastudio standl alone, welll I have to select standalone because when I tryto login tho the OMS it asks for the anagment server wich is localhost, but it says unable to connect, asks for verifing the host name, it is localhost... the host is localhost, am I wrong? how do I correct this, how can I login to the OM I am strarting with thiso of oracle, I have aoracle 81, winn2000 server, on a laptop pc, some things work but some other do not ask o for thigs that I do not know, so please give me a hand, other question I read in a book that there is an oracle apication server, with many web interfaces for administrative tasks, how do I get there? I am talking about the Oracle appliactin server, I have isntalled oracle 8i ver 17, and I have never been able to get any kind of web interfaces, another thing I am getting this error msg, for http://localhost/demo/sql/bean/ConnBeanDemo.jsp `m using connection and a query bean and i'm quering EMP names and Salary from EMP table in schema SCOTT.. There was an error doing the query: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=135294976)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4 why is tis erro comming up? it is an example that comes with oracle installatin, and it sithe sme error msg for all the jsp examples of database conctin... conection.. so is my oracle not well installed? if it is not ok, I will reinstalled but what do I have to do in order to get it right? I would like to use the desgner, but it has been ipsible to use it, everytime I try to use it it says that it cannot conect to the databaseI am trying to run the examples, the oralce jssp demo section, the localhost/demo, but I am getting mistakes in most of them. so I assume I have sm mistakes, but how can I do the things rihgt, I just installed oracle and I am runnig the demo and what do I have to do are not the demos suppouse to work with no configuration of any kind just after the installationhere is another mistake: Employee List in XML (View Page Source in your browser to see XML output) SQL error: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=135294976)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4 and I have not changed anythng, it has just comed uot after the installation so what shoudl I do, hey one ting that o comes out of no well better not tosay anything else but pelase please what do I have to do in ordr to have this oracle working ifne, what Iam I doing wrong? the only examples that are running are the basic examples- lotto and hello user but nothing that has to do with dbso please I really would like to get oracle runing, but really it is diving me crazy so me any mistakes after what was suuposue to be a sccesful installation... cheers -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: agc 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: Package standard - 9i for W2000 installation
Harun, connect in sqlplus as user sys and execute: ALTER PACKAGE dbms_standard COMPILE; hth, Paul Harun Altay wrote: > > I did it at last, as you and Jared had described. I run that script. I got > those messages below. Later on, I tryed to give privilages to SYS user by > administrator, and I got the same error message as before : ORA-06553: > PLS-213: package STANDARD not accesible. > > Thanks. > > the very(!) last part of the output message in the ms-dos screen for > SQL*Plus is below: > > -- > create or replace public synonym dba_ias_objects for dba_ias_objects > * > ERROR at line 1: > ORA-00604: error occurred at recursive SQL level 1 > ORA-06553: PLS-213: package STANDARD not accessible > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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: One more to the list of Myths exploded
unfortunately yes Thanks to jared's example i have a clearer idea now :) coz I am a NoviceDBA Oracle Certifiable DBBS - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, September 28, 2001 3:00 PM > > Which myth did you have in mind ? > > I hadn't heard any that suggested that PL/SQL > was particularly subtle or memory efficient. > > You're not associating this pl/sql implementation > detail with the fact that a varchar2() column when > stored in a datablock uses only the exact length > required to store the current value, are you ? > > > Jonathan Lewis > http://www.jlcomp.demon.co.uk > > Host to The Co-Operative Oracle Users' FAQ > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > Author of: > Practical Oracle 8i: Building Efficient Databases > > Screen saver or Life saver: http://www.ud.com > Use spare CPU to assist in cancer research. > > > I was reading the Oracle PL/SQL manual and this is what I found. One > more myth goes down > > The VARCHAR2 datatype involves a trade-off between memory use and > efficiency. For a VARCHAR2(>= 2000) variable, PL/SQL dynamically > allocates only enough memory to hold the actual value. However, for a > VARCHAR2(< 2000) variable, PL/SQL preallocates enough memory to hold a > maximum-size value. So, for example, if you assign the same 500-byte > value to a VARCHAR2(2000) variable and to a VARCHAR2(1999) variable, > the latter uses 1499 bytes more memory. > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jonathan Lewis > 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: novicedba 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: Package standard - 9i for W2000 installation
I did it at last, as you and Jared had described. I run that script. I got those messages below. Later on, I tryed to give privilages to SYS user by administrator, and I got the same error message as before : ORA-06553: PLS-213: package STANDARD not accesible. Thanks. the very(!) last part of the output message in the ms-dos screen for SQL*Plus is below: -- create or replace public synonym dba_ias_objects for dba_ias_objects * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible Grant succeeded. from system.repcat$_template_sites * ERROR at line 4: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible create or replace public synonym dba_ias_sites for dba_ias_sites * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible Grant succeeded. select 1 pkexists, cd.obj# from sys.cdef$ cd * ERROR at line 2: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible Grant succeeded. from system.repcat$_refresh_templates rt, * ERROR at line 4: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible create or replace public synonym dba_ias_gen_stmts for dba_ias_gen_stmts * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible Grant succeeded. from system.repcat$_template_objects ro * ERROR at line 4: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible Grant succeeded. select * from sys.dba_ias_gen_stmts_exp gs * ERROR at line 2: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible Grant succeeded. select * from sys.dba_ias_gen_stmts_exp gs * ERROR at line 2: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible Grant succeeded. create or replace package sys.dbms_ias_template as * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible create or replace public synonym dbms_ias_template for dbms_ias_template * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible Grant succeeded. CREATE OR REPLACE PACKAGE dbms_ias_inst wrapped * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible Grant succeeded. CREATE OR REPLACE PUBLIC SYNONYM dbms_ias_inst FOR dbms_ias_inst * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible CREATE OR REPLACE PACKAGE dbms_ias_mt_inst wrapped * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible Grant succeeded. CREATE OR REPLACE PUBLIC SYNONYM dbms_ias_mt_inst FOR dbms_ias_mt_inst * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible CREATE OR REPLACE PACKAGE dbms_ias_mt_inst_internal wrapped * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible CREATE OR REPLACE PACKAGE dbms_ias_inst_utl wrapped * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible CREATE OR REPLACE PACKAGE dbms_ias_inst_utl_exp wrapped * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible Grant succeeded. FROM dba_repgenerated r * ERROR at line 28: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible FROM sys.user$ u, * ERROR at line 5: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible FROM dba_cacheable_tables_base t * ERROR at line 4: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible create or replace public synonym DBA_CACHEABLE_TABLES for DBA_CACHEABLE_TABLES * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible Grant succeeded. FROM dba_cacheable_tables_base t * ERROR at line 9: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible create or replace public synonym DBA_CACHEABLE_OBJECTS_BASE * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package
Re: rollback segments during export
Without proof though, there are other explanations. Like no DML was taking place while you ran the export. The way to test it is check while running an export. I don't know how to do that off the top of my head. Jared On Sunday 30 September 2001 18:05, Reardon, Bruce (CALBBAY) wrote: > We use export / import to refresh our test system. > > We do the exports from OEM with consistent=y (this is on NT, version 8.1.5 > and 8.1.7). > > We have lots of tables with foreign key constraints and have not had any > problems with the constraints being reenabled in test. > That is, consistent=y seems to me to prevent the tables getting out of > sync. > > At one stage, I ran into an OEM bug (1429380 / 1080622) related to the > copying of OEM advanced export job settings - this lead to doing a > consistent=N export and then when we imported into our test system some of > the constraints could not be enabled. > > This adds weight to consistent=y keeping tables in sync across the entire > database. > > HTH, > Bruce Reardon > > -Original Message- > Sent: Sunday, 30 September 2001 5:40 > > Chris, > > > Just because there is a PK/FK between tables, it does not mean they will > > be > > > exported in the same transaction. And thus, possibly out of sync. > > I didn't say there was. My implication was that your > tables would get out of sync. Setting 'consistent=y' > > won't prevent that: > : If you specify CONSISTENT=N (the default), each table is usually exported > : in a single transaction. However, if a table contains nested tables, th > > Now it *could* be that I'm misreading the docs. It' been known > to happen, but that sentence says to me that each table is > exported as part of a single transaction. > > Anyone have proof to the contrary? The tech writer is being > rather ambigous, at least I think so. > > Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Package standard - 9i for W2000 installation
Harun, Here's a way that should work. use a cmd window cd %ORACLE_HOME%/rdbms/admin sqlplus internal @catproc This should take care of the problem Jared On Sunday 30 September 2001 20:15, Harun Altay wrote: > Hello Jared, and other friends, > > I am new in Oracle Administration. I have experience on MS SQL Server. I am > in learning phase now. > > I have installed my first Oracle Database, as Oracle 9i for Windows2000, > previous week. I got a similar problem. There is SYS and SYSTEM users. They > are not capable of adding a new table to SCOTT Schema, for example. I want > to give them more priviledges. I am running "Enterprise Manager Console", > and lounching it as "Standalone", connecting to database with the NT's > "administrator" user. When I try to add some more priviledges to that > users, I am getting this message below: > > ORA-06553: PLS-213: package standard not accessible. > > I saw your advice for leo: that is "run > ORACLE_HOME/rdbms/admin/catproc.sql". I did it. I got the log below: > > Can you advice me something? (other than reading manuals more :) > > Best Regards, > Harun. > > > > SQL*Plus: Release 9.0.1.0.1 - Production on Sun Sep 30 20:52:52 2001 > > (c) Copyright 2001 Oracle Corporation. All rights reserved. > > Connected. > Connected. > > > SP2-0310: unable to open file "catprc.sql" > > SP2-0310: unable to open file "catjobq.sql" > SP2-0310: unable to open file "catrpc.sql" > SP2-0310: unable to open file "dbmsstdx.sql" > SP2-0310: unable to open file "plitblm.sql" > SP2-0310: unable to open file "plspur.sql" > SP2-0310: unable to open file "pipidl.sql" > > Grant succeeded. > > SP2-0310: unable to open file "pidian.sql" > > Grant succeeded. > > SP2-0310: unable to open file "diutil.sql" > SP2-0310: unable to open file "pistub.sql" > SP2-0310: unable to open file "prvtpckl.plb" > SP2-0310: unable to open file "utlfile.sql" > SP2-0310: unable to open file "prvtfile.plb" > SP2-0310: unable to open file "utlraw.sql" > SP2-0310: unable to open file "prvtrawb.plb" > SP2-0310: unable to open file "utltcp.sql" > SP2-0310: unable to open file "prvttcp.plb" > SP2-0310: unable to open file "utlinad.sql" > SP2-0310: unable to open file "prvtinad.plb" > SP2-0310: unable to open file "utlsmtp.sql" > SP2-0310: unable to open file "prvtsmtp.plb" > SP2-0310: unable to open file "utlhttp.sql" > SP2-0310: unable to open file "prvthttp.plb" > SP2-0310: unable to open file "utlurl.sql" > SP2-0310: unable to open file "prvturl.plb" > SP2-0310: unable to open file "utlenc.sql" > SP2-0310: unable to open file "prvtenc.plb" > SP2-0310: unable to open file "catspace.sql" > SP2-0310: unable to open file "catactx.sql" > SP2-0310: unable to open file "catsvrmg.sql" > SP2-0310: unable to open file "dbmsutil.sql" > SP2-0310: unable to open file "prvthtxn.plb" > SP2-0310: unable to open file "dbmsapin.sql" > SP2-0310: unable to open file "dbmssyer.sql" > SP2-0310: unable to open file "dbmslock.sql" > SP2-0310: unable to open file "dbmspipe.sql" > SP2-0310: unable to open file "dbmsalrt.sql" > SP2-0310: unable to open file "dbmsotpt.sql" > SP2-0310: unable to open file "dbmsdesc.sql" > SP2-0310: unable to open file "dbmssql.sql" > SP2-0310: unable to open file "dbmspexp.sql" > SP2-0310: unable to open file "dbmsjob.sql" > SP2-0310: unable to open file "dbmsstat.sql" > SP2-0310: unable to open file "prvthddl.plb" > SP2-0310: unable to open file "prvthjob.plb" > SP2-0310: unable to open file "prvthsye.plb" > SP2-0310: unable to open file "prvthssq.plb" > SP2-0310: unable to open file "prvtutil.plb" > SP2-0310: unable to open file "prvtapin.plb" > SP2-0310: unable to open file "prvtsyer.plb" > SP2-0310: unable to open file "prvtlock.plb" > SP2-0310: unable to open file "prvtpipe.plb" > SP2-0310: unable to open file "prvtalrt.plb" > SP2-0310: unable to open file "prvtotpt.plb" > SP2-0310: unable to open file "prvtdesc.plb" > SP2-0310: unable to open file "prvtssql.plb" > SP2-0310: unable to open file "prvtsql.plb" > SP2-0310: unable to open file "prvtpexp.plb" > SP2-0310: unable to open file "prvtzhlp.plb" > SP2-0310: unable to open file "prvtzexp.plb" > SP2-0310: unable to open file "prvtjob.plb" > SP2-0310: unable to open file "prvtstas.plb" > SP2-0310: unable to open file "prvtstat.plb" > SP2-0310: unable to open file "dbmspsp.sql" > SP2-0310: unable to open file "prvtpsp.plb" > SP2-0310: unable to open file "dbmstran.sql" > SP2-0310: unable to open file "prvttran.plb" > SP2-0310: unable to open file "catrule.sql" > SP2-0310: unable to open file "dbmsread.sql" > SP2-0310: unable to open file "prvtread.plb" > SP2-0310: unable to open file "catxpend.sql" > SP2-0310: unable to open file "dbmslob.sql" > SP2-0310: unable to open file "prvtlob.plb" > SP2-0310: unable to open file "cattrans.sql" > SP2-0310: unable to open file "dbmstxfm.sql" > SP2-0310: unable to open file "prvttxfm.plb" > SP2-0310: unable to open file "catqueue.sql" > SP2-0310: unable to open file "catrm.sql" > SP2-0310: unable to open fil
Re: Package standard - 9i for W2000 installation
Harun, How about opening a command window, changing to the ORACLE_HOME/rdbms/admin directory, and then running catproc.sql. There's also a registry setting you can set somewhere, called SQLPATH (or is it SQL_PATH), that will tell Oracle where to look for SQL scripts. This is a more functional alternative, and you'd want to do that to name a general directory where you keep most of your regularly run scripts, but the first way is easier, quicker, and will get the job done, so you can get started. < I've been away for a while, and I'm not fully back for like two more weeks, but I'm back a little, in case anyone was wondering. > hth, Yosi Harun Altay wrote: > Hello Jared, and other friends, > > I am new in Oracle Administration. I have experience on MS SQL Server. I am > in learning phase now. > > I have installed my first Oracle Database, as Oracle 9i for Windows2000, > previous week. I got a similar problem. There is SYS and SYSTEM users. They > are not capable of adding a new table to SCOTT Schema, for example. I want > to give them more priviledges. I am running "Enterprise Manager Console", > and lounching it as "Standalone", connecting to database with the NT's > "administrator" user. When I try to add some more priviledges to that users, > I am getting this message below: > > ORA-06553: PLS-213: package standard not accessible. > > I saw your advice for leo: that is "run > ORACLE_HOME/rdbms/admin/catproc.sql". I did it. I got the log below: > > Can you advice me something? (other than reading manuals more :) > > Best Regards, > Harun. > > SQL*Plus: Release 9.0.1.0.1 - Production on Sun Sep 30 20:52:52 2001 > > (c) Copyright 2001 Oracle Corporation. All rights reserved. > > Connected. > Connected. > > SP2-0310: unable to open file "catprc.sql" > SP2-0310: unable to open file "catjobq.sql" > SP2-0310: unable to open file "catrpc.sql" > SP2-0310: unable to open file "dbmsstdx.sql" > SP2-0310: unable to open file "plitblm.sql" > SP2-0310: unable to open file "plspur.sql" > SP2-0310: unable to open file "pipidl.sql" > > Grant succeeded. > > SP2-0310: unable to open file "pidian.sql" > > Grant succeeded. > > SP2-0310: unable to open file "diutil.sql" > SP2-0310: unable to open file "pistub.sql" > SP2-0310: unable to open file "prvtpckl.plb" > SP2-0310: unable to open file "utlfile.sql" > SP2-0310: unable to open file "prvtfile.plb" > SP2-0310: unable to open file "utlraw.sql" > SP2-0310: unable to open file "prvtrawb.plb" > SP2-0310: unable to open file "utltcp.sql" > SP2-0310: unable to open file "prvttcp.plb" > SP2-0310: unable to open file "utlinad.sql" > SP2-0310: unable to open file "prvtinad.plb" > SP2-0310: unable to open file "utlsmtp.sql" > SP2-0310: unable to open file "prvtsmtp.plb" > SP2-0310: unable to open file "utlhttp.sql" > SP2-0310: unable to open file "prvthttp.plb" > SP2-0310: unable to open file "utlurl.sql" > SP2-0310: unable to open file "prvturl.plb" > SP2-0310: unable to open file "utlenc.sql" > SP2-0310: unable to open file "prvtenc.plb" > SP2-0310: unable to open file "catspace.sql" > SP2-0310: unable to open file "catactx.sql" > SP2-0310: unable to open file "catsvrmg.sql" > SP2-0310: unable to open file "dbmsutil.sql" > SP2-0310: unable to open file "prvthtxn.plb" > SP2-0310: unable to open file "dbmsapin.sql" > SP2-0310: unable to open file "dbmssyer.sql" > SP2-0310: unable to open file "dbmslock.sql" > SP2-0310: unable to open file "dbmspipe.sql" > SP2-0310: unable to open file "dbmsalrt.sql" > SP2-0310: unable to open file "dbmsotpt.sql" > SP2-0310: unable to open file "dbmsdesc.sql" > SP2-0310: unable to open file "dbmssql.sql" > SP2-0310: unable to open file "dbmspexp.sql" > SP2-0310: unable to open file "dbmsjob.sql" > SP2-0310: unable to open file "dbmsstat.sql" > SP2-0310: unable to open file "prvthddl.plb" > SP2-0310: unable to open file "prvthjob.plb" > SP2-0310: unable to open file "prvthsye.plb" > SP2-0310: unable to open file "prvthssq.plb" > SP2-0310: unable to open file "prvtutil.plb" > SP2-0310: unable to open file "prvtapin.plb" > SP2-0310: unable to open file "prvtsyer.plb" > SP2-0310: unable to open file "prvtlock.plb" > SP2-0310: unable to open file "prvtpipe.plb" > SP2-0310: unable to open file "prvtalrt.plb" > SP2-0310: unable to open file "prvtotpt.plb" > SP2-0310: unable to open file "prvtdesc.plb" > SP2-0310: unable to open file "prvtssql.plb" > SP2-0310: unable to open file "prvtsql.plb" > SP2-0310: unable to open file "prvtpexp.plb" > SP2-0310: unable to open file "prvtzhlp.plb" > SP2-0310: unable to open file "prvtzexp.plb" > SP2-0310: unable to open file "prvtjob.plb" > SP2-0310: unable to open file "prvtstas.plb" > SP2-0310: unable to open file "prvtstat.plb" > SP2-0310: unable to open file "dbmspsp.sql" > SP2-0310: unable to open file "prvtpsp.plb" > SP2-0310: unable to open file "dbmstran.sql" > SP2-0310: unable to open file "prvttran.plb" > SP2-0310: unable to open file "catrule.sql" > SP2-0310: unable to open file "dbmsread.sql" > SP2-
Re: Package standard - 9i for W2000 installation
Hello Jared, and other friends, I am new in Oracle Administration. I have experience on MS SQL Server. I am in learning phase now. I have installed my first Oracle Database, as Oracle 9i for Windows2000, previous week. I got a similar problem. There is SYS and SYSTEM users. They are not capable of adding a new table to SCOTT Schema, for example. I want to give them more priviledges. I am running "Enterprise Manager Console", and lounching it as "Standalone", connecting to database with the NT's "administrator" user. When I try to add some more priviledges to that users, I am getting this message below: ORA-06553: PLS-213: package standard not accessible. I saw your advice for leo: that is "run ORACLE_HOME/rdbms/admin/catproc.sql". I did it. I got the log below: Can you advice me something? (other than reading manuals more :) Best Regards, Harun. SQL*Plus: Release 9.0.1.0.1 - Production on Sun Sep 30 20:52:52 2001 (c) Copyright 2001 Oracle Corporation. All rights reserved. Connected. Connected. > SP2-0310: unable to open file "catprc.sql" SP2-0310: unable to open file "catjobq.sql" SP2-0310: unable to open file "catrpc.sql" SP2-0310: unable to open file "dbmsstdx.sql" SP2-0310: unable to open file "plitblm.sql" SP2-0310: unable to open file "plspur.sql" SP2-0310: unable to open file "pipidl.sql" Grant succeeded. SP2-0310: unable to open file "pidian.sql" Grant succeeded. SP2-0310: unable to open file "diutil.sql" SP2-0310: unable to open file "pistub.sql" SP2-0310: unable to open file "prvtpckl.plb" SP2-0310: unable to open file "utlfile.sql" SP2-0310: unable to open file "prvtfile.plb" SP2-0310: unable to open file "utlraw.sql" SP2-0310: unable to open file "prvtrawb.plb" SP2-0310: unable to open file "utltcp.sql" SP2-0310: unable to open file "prvttcp.plb" SP2-0310: unable to open file "utlinad.sql" SP2-0310: unable to open file "prvtinad.plb" SP2-0310: unable to open file "utlsmtp.sql" SP2-0310: unable to open file "prvtsmtp.plb" SP2-0310: unable to open file "utlhttp.sql" SP2-0310: unable to open file "prvthttp.plb" SP2-0310: unable to open file "utlurl.sql" SP2-0310: unable to open file "prvturl.plb" SP2-0310: unable to open file "utlenc.sql" SP2-0310: unable to open file "prvtenc.plb" SP2-0310: unable to open file "catspace.sql" SP2-0310: unable to open file "catactx.sql" SP2-0310: unable to open file "catsvrmg.sql" SP2-0310: unable to open file "dbmsutil.sql" SP2-0310: unable to open file "prvthtxn.plb" SP2-0310: unable to open file "dbmsapin.sql" SP2-0310: unable to open file "dbmssyer.sql" SP2-0310: unable to open file "dbmslock.sql" SP2-0310: unable to open file "dbmspipe.sql" SP2-0310: unable to open file "dbmsalrt.sql" SP2-0310: unable to open file "dbmsotpt.sql" SP2-0310: unable to open file "dbmsdesc.sql" SP2-0310: unable to open file "dbmssql.sql" SP2-0310: unable to open file "dbmspexp.sql" SP2-0310: unable to open file "dbmsjob.sql" SP2-0310: unable to open file "dbmsstat.sql" SP2-0310: unable to open file "prvthddl.plb" SP2-0310: unable to open file "prvthjob.plb" SP2-0310: unable to open file "prvthsye.plb" SP2-0310: unable to open file "prvthssq.plb" SP2-0310: unable to open file "prvtutil.plb" SP2-0310: unable to open file "prvtapin.plb" SP2-0310: unable to open file "prvtsyer.plb" SP2-0310: unable to open file "prvtlock.plb" SP2-0310: unable to open file "prvtpipe.plb" SP2-0310: unable to open file "prvtalrt.plb" SP2-0310: unable to open file "prvtotpt.plb" SP2-0310: unable to open file "prvtdesc.plb" SP2-0310: unable to open file "prvtssql.plb" SP2-0310: unable to open file "prvtsql.plb" SP2-0310: unable to open file "prvtpexp.plb" SP2-0310: unable to open file "prvtzhlp.plb" SP2-0310: unable to open file "prvtzexp.plb" SP2-0310: unable to open file "prvtjob.plb" SP2-0310: unable to open file "prvtstas.plb" SP2-0310: unable to open file "prvtstat.plb" SP2-0310: unable to open file "dbmspsp.sql" SP2-0310: unable to open file "prvtpsp.plb" SP2-0310: unable to open file "dbmstran.sql" SP2-0310: unable to open file "prvttran.plb" SP2-0310: unable to open file "catrule.sql" SP2-0310: unable to open file "dbmsread.sql" SP2-0310: unable to open file "prvtread.plb" SP2-0310: unable to open file "catxpend.sql" SP2-0310: unable to open file "dbmslob.sql" SP2-0310: unable to open file "prvtlob.plb" SP2-0310: unable to open file "cattrans.sql" SP2-0310: unable to open file "dbmstxfm.sql" SP2-0310: unable to open file "prvttxfm.plb" SP2-0310: unable to open file "catqueue.sql" SP2-0310: unable to open file "catrm.sql" SP2-0310: unable to open file "catdefer.sql" SP2-0310: unable to open file "catsnap.sql" SP2-0310: unable to open file "prvtdfrd.plb" SP2-0310: unable to open file "prvtitrg.plb" SP2-0310: unable to open file "prvtxpsw.plb" SP2-0310: unable to open file "dbmspb.sql" SP2-0310: unable to open file "prvtpb.plb" SP2-0310: unable to open file "dbmssum.sql" SP2-0310: unable to open file "dbmssnap.sql" SP2-0310: unable to open file "dbmshord.sql" SP2-0310: unable to open f
RE: Autoextend - how many times has a datafile extended
No. There isn't (although it would be nice if there was). Oracle only tracks the original and current sizes. The only record of any resizing would be in the alert log if you issued an explicit alter database datafile ... resize command. Jon Walthour -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 30, 2001 8:55 PM To: Multiple recipients of list ORACLE-L Is it possible to determine how many times a file has extended? I know that v$datafile.CREATE_BYTES will show what size the file was initially created at. And dba_data_files.INCREMENT_BY shows how much each datafile is currently set to extend by (number of database blocks). But, given that we can manually resize a file and that we can alter the value of next for a datafile, does Oracle store how many times each file has extended? Why is this of interest - this number can be related to / help explain the degree of OS fragmentation for the datafile. Thanks, Bruce Reardon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: Walthour, Jon (GEAE, Compaq) 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 segments during export
We use export / import to refresh our test system. We do the exports from OEM with consistent=y (this is on NT, version 8.1.5 and 8.1.7). We have lots of tables with foreign key constraints and have not had any problems with the constraints being reenabled in test. That is, consistent=y seems to me to prevent the tables getting out of sync. At one stage, I ran into an OEM bug (1429380 / 1080622) related to the copying of OEM advanced export job settings - this lead to doing a consistent=N export and then when we imported into our test system some of the constraints could not be enabled. This adds weight to consistent=y keeping tables in sync across the entire database. HTH, Bruce Reardon -Original Message- Sent: Sunday, 30 September 2001 5:40 Chris, > Just because there is a PK/FK between tables, it does not mean they will be > exported in the same transaction. And thus, possibly out of sync. I didn't say there was. My implication was that your tables would get out of sync. Setting 'consistent=y' won't prevent that: : If you specify CONSISTENT=N (the default), each table is usually exported : in a single transaction. However, if a table contains nested tables, th Now it *could* be that I'm misreading the docs. It' been known to happen, but that sentence says to me that each table is exported as part of a single transaction. Anyone have proof to the contrary? The tech writer is being rather ambigous, at least I think so. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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).
Autoextend - how many times has a datafile extended
Is it possible to determine how many times a file has extended? I know that v$datafile.CREATE_BYTES will show what size the file was initially created at. And dba_data_files.INCREMENT_BY shows how much each datafile is currently set to extend by (number of database blocks). But, given that we can manually resize a file and that we can alter the value of next for a datafile, does Oracle store how many times each file has extended? Why is this of interest - this number can be related to / help explain the degree of OS fragmentation for the datafile. Thanks, Bruce Reardon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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).
Bitmap index - how many rows get locked
Hi, Is it possible to find out the actual number of locked rows? For example: SQL> desc test Name Null?Type - F NUMBER(38) SQL> select * from test; F -- 1 1 1 2 3 5 rows selected. SQL> update test set f=f where f=2 or f=3; 2 rows updated. SQL> Is there a view I can query to find out that 2 rows are locked? v$locked_object will let me see that there is 1 table locked and find out which table it is. v$lock will show 1 * TM lock and 1 * TX lock. Putting this another way, if I use bitmap indexes and update a field in the index, I may lock more than 1 row (Oracle will use bitmap-segment-level locking). How can I find out how many rows are locked in this case. For a specific case I guess I should find out how many rows are in a single bitmap-segment but I haven't yet investigated how to do this. Thanks, Bruce Reardon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: 8.1.7 Migration
Thanks. The point is not to leave it to default. - Kirti > -Original Message- > From: K Gopalakrishnan [SMTP:[EMAIL PROTECTED]] > Sent: Sunday, September 30, 2001 2:55 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: 8.1.7 Migration > > Kirti, > > Starting from 8.1.6 you can set to 32K. The 1MB min > value is applicable only for 8.1.5. > > Best Regards, > K Gopalakrishnan > > > -Original Message- > Kirti > Sent: Sunday, September 30, 2001 10:50 AM > To: Multiple recipients of list ORACLE-L > > > But if your are not planning on using Java, explicitly set java_pool_size > = > 100 (~ 1MB), it's min value, else it will default and consume ~ 20MB > of > your SGA. A total waste of memory, since it can not be used for any other > things. You can increase it later, when Java is needed.. > > Regards, > > - Kirti Deshpande > Verizon Information Services >http://www.superpages.com > > > -Original Message- > > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > > Sent: Friday, September 28, 2001 7:45 PM > > To: Multiple recipients of list ORACLE-L > > Subject:Re: 8.1.7 Migration > > > > Kevin, > > > > in short no. But install them if you have time/room, set > > compatibility to 8.0.5 9so your app will run as it did) and then change > > that and use the new functionality as you get to it > > > > Rachel (who just moved from 8.0.5 to 8.1.6) > > > > --- Kevin Lange <[EMAIL PROTECTED]> wrote: > > > We are about to enter into an upgrade to 8.1.7. > > > > > > In reading the documentation I have seen a lot of new things being > > > added to > > > the database Java support ... an HTTP server, etc. > > > > > > Are all of these things neccessary if you just want , at first, to > > > migrate > > > an 8.0.5 database functionally to the 8.1.7 ?? We will add new > > > items as > > > soon as we see a need for them. > > > > > > Kevin > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Kevin Lange > > > 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). > > > > > > __ > > Do You Yahoo!? > > Listen to your Yahoo! Mail messages from any phone. > > http://phone.yahoo.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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > 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). > > _ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: K Gopalakrishnan > 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).
queries on licences
Hi , Can you pls. Clarify on the below. 1. What is the typical ratio of users to licenses in a concurrent licensing scheme? 2. How does Oracle keep track of the licenses? 3. Suppose someone logs in and does not do any transaction, will it be counted as a used license? 4. Does Oracle logs you off if you don't do any transaction for time? Is there a time in the day like mid-night when the users are automatically logged off? Thanks and regards, Basaiah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hiremath, Basaih 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: Package standard
run ORACLE_HOME/rdbms/admin/catproc.sql That should have been run when the database was created. Jared On Saturday 29 September 2001 19:25, Joe LaCascio wrote: > I've just installed 8.1.6.2.0, created a database and found that > dbms_standard is not there. When I try to run utlrp.sql I get the > message STANDARD is not available. I found this out because DBMS_PIPE > is missing and can't create created unles DBMS_STANDARD is there. > > Any help would be appreciated. > > Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: For update - Where current of
There are no docs or sites that I am aware of other than the standard Oracle docs. Try Steven Feuerstein's books and Tom Kyte's book as well. asktom.oracle.com may have something. As for the 'select ... for update part', you did notice didn't you that 'where current of' only requires locking a single row at a time? Jared On Sunday 30 September 2001 05:05, Nirmal Kumar Muthu Kumaran wrote: > Hi jarad, > > Thanks. In SQLPLUS, we can lock the records using the select ... update > of The same thing i can do it pl/sql > using cursor ... select... update of and ... where current of > . This was i understood before regarding > the same. > > Is i'm rt or not... Can you give more breif on this... i would be more > thankful if u redirected me for some sites/docs > to refer... > > Regards, > Nirmal > > > -Original Message- > > From: Jared Still [SMTP:[EMAIL PROTECTED]] > > Sent: Sunday, September 30, 2001 7:55 AM > > To: Multiple recipients of list ORACLE-L > > Subject:Re: For update - Where current of > > > > On Saturday 29 September 2001 07:50, Nirmal Kumar Muthu Kumaran wrote: > > > Hi gurus > > > > > > Can any one give the usage of 'for update' clause, while declaring a > > > cursor in Pl/sql? > > > > 'Where current of' can be very useful. > > > > You can for instance use it to avoid 'select for update' > > on a large number of rows. You can use it to commit in > > a loop while avoiding the dreaded 'fetch across commit' error. > > > > Here's an example from some real code. > > > > Jared > > > > > > declare > > > > cursor cUpdatePersons( login_id_in persons.login_id%type ) > > is > > select * > > from persons > > where login_id = login_id_in > > for update; > > > > rPersons persons%rowtype; > > rEmptabActive emptab_tmp%rowtype; > > > > cursor cEmpTabInactive > > is > > select distinct login_id > > from emptab_tmp > > where status = 'I'; > > > > cursor cEmpTabActive( login_id_in persons.login_id%type ) > > is > > select * > > from emptab_tmp > > where login_id = login_id_in > > and status = 'A' > > and effective_end_date > sysdate; > > > > begin > > > > for irec in cEmpTabInactive > > loop > > > > open cEmpTabActive( irec.login_id ); > > fetch cEmpTabActive into rEmptabActive; > > > > if not cEmpTabActive%found then > > > > open cUpdatePersons( irec.login_id ); > > fetch cUpdatePersons into rPersons; > > > > if cUpdatePersons%found then > > > > update persons > > set status = 'I' > > where current of cUpdatePersons; > > > > end if; > > > > close cUpdatePersons; > > > > end if; > > > > close cEmpTabActive; > > > > > > end loop; > > > > end; > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Jared Still > > 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). Content-Type: text/html; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: 8.1.7 Migration
Kirti, Starting from 8.1.6 you can set to 32K. The 1MB min value is applicable only for 8.1.5. Best Regards, K Gopalakrishnan -Original Message- Kirti Sent: Sunday, September 30, 2001 10:50 AM To: Multiple recipients of list ORACLE-L But if your are not planning on using Java, explicitly set java_pool_size = 100 (~ 1MB), it's min value, else it will default and consume ~ 20MB of your SGA. A total waste of memory, since it can not be used for any other things. You can increase it later, when Java is needed.. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > Sent: Friday, September 28, 2001 7:45 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: 8.1.7 Migration > > Kevin, > > in short no. But install them if you have time/room, set > compatibility to 8.0.5 9so your app will run as it did) and then change > that and use the new functionality as you get to it > > Rachel (who just moved from 8.0.5 to 8.1.6) > > --- Kevin Lange <[EMAIL PROTECTED]> wrote: > > We are about to enter into an upgrade to 8.1.7. > > > > In reading the documentation I have seen a lot of new things being > > added to > > the database Java support ... an HTTP server, etc. > > > > Are all of these things neccessary if you just want , at first, to > > migrate > > an 8.0.5 database functionally to the 8.1.7 ?? We will add new > > items as > > soon as we see a need for them. > > > > Kevin > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Kevin Lange > > 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). > > > __ > Do You Yahoo!? > Listen to your Yahoo! Mail messages from any phone. > http://phone.yahoo.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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: Hit rate is a negative number
I've never really bothered about things like hit-ratios. Once you have roughly the right amount of memory in place, the system is either doing things the right way or it isn't. So I tend to look at v$sql if Oracle is too busy, and v$session_event if Oracle isn't working hard enough. Otherwise v$filestat is a quick indicator of possible I/O threats and v$sess_io is a quick guide to which session to target. Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases Screen saver or Life saver: http://www.ud.com Use spare CPU to assist in cancer research. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: 8.1.7 Migration
But if your are not planning on using Java, explicitly set java_pool_size = 100 (~ 1MB), it's min value, else it will default and consume ~ 20MB of your SGA. A total waste of memory, since it can not be used for any other things. You can increase it later, when Java is needed.. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > Sent: Friday, September 28, 2001 7:45 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: 8.1.7 Migration > > Kevin, > > in short no. But install them if you have time/room, set > compatibility to 8.0.5 9so your app will run as it did) and then change > that and use the new functionality as you get to it > > Rachel (who just moved from 8.0.5 to 8.1.6) > > --- Kevin Lange <[EMAIL PROTECTED]> wrote: > > We are about to enter into an upgrade to 8.1.7. > > > > In reading the documentation I have seen a lot of new things being > > added to > > the database Java support ... an HTTP server, etc. > > > > Are all of these things neccessary if you just want , at first, to > > migrate > > an 8.0.5 database functionally to the 8.1.7 ?? We will add new > > items as > > soon as we see a need for them. > > > > Kevin > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Kevin Lange > > 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). > > > __ > Do You Yahoo!? > Listen to your Yahoo! Mail messages from any phone. > http://phone.yahoo.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Query
Try this select statement: select ID, P1||' '||PVAL1 FROM t WHERE ID = 101 UNION select ID, P2||' '||PVAL2 FROM t WHERE ID = 101 UNION select ID, P3||' '||PVAL3 FROM t WHERE ID = 101 select ID, P1||' '||PVAL1 FROM t WHERE ID = 102 UNION select ID, P3||' '||PVAL3 FROM t WHERE ID = 102 UNION select ID, P2||' '||PVAL2 FROM t WHERE ID = 102 UNION select ID, P1||' '||PVAL1 FROM t WHERE ID = 103 UNION select ID, P3||' '||PVAL3 FROM t WHERE ID = 103 UNION select ID, P2||' '||PVAL2 FROM t WHERE ID = 103 --- Nirmal Kumar Muthu Kumaran <[EMAIL PROTECTED]> wrote: > Hi gurus, > > My table data looks like as follows: > > [EMAIL PROTECTED]> select * from t; > > ID P1 PVAL1 P2 PVAL2 > P3 PVAL3 > - - > - > > 101 A VALUE A B VALUE B > C VALUE C > 102 X VALUE X Y VALUE Y > Z VALUE Z > 103 P VALUE P Q VALUE Q > R VALUE R > > [EMAIL PROTECTED]> > > Tab Description: > [EMAIL PROTECTED]> desc t; > NameNull?Type > --- > ID NUMBER > PCD1 CHAR(1) > PVAL1 > VARCHAR2(20) > PCD2 CHAR(1) > PVAL2 > VARCHAR2(20) > PCD3 CHAR(1) > PVAL3 > VARCHAR2(20) > > I need output as like: > > ID Pcd PVAL > 101 A VALUE A > 101 B VALUE B > 101 C VALUE C > 102 X VALUE X > 102 Z VALUE Z > 102 Y VALUE Y > 103 P VALUE P > 103 R VALUE R > 103 Q VALUE Q > > Anyone have any idea pls. > > Rgds, > Nirmal. > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Nirmal Kumar Muthu Kumaran > 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). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH 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: For update - Where current of
Title: RE: For update - Where current of Hi jarad, Thanks. In SQLPLUS, we can lock the records using the select ... update of The same thing i can do it pl/sql using cursor ... select... update of and ... where current of . This was i understood before regarding the same. Is i'm rt or not... Can you give more breif on this... i would be more thankful if u redirected me for some sites/docs to refer... Regards, Nirmal -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Sunday, September 30, 2001 7:55 AM To: Multiple recipients of list ORACLE-L Subject: Re: For update - Where current of On Saturday 29 September 2001 07:50, Nirmal Kumar Muthu Kumaran wrote: > Hi gurus > > Can any one give the usage of 'for update' clause, while declaring a > cursor in Pl/sql? > > 'Where current of' can be very useful. You can for instance use it to avoid 'select for update' on a large number of rows. You can use it to commit in a loop while avoiding the dreaded 'fetch across commit' error. Here's an example from some real code. Jared declare cursor cUpdatePersons( login_id_in persons.login_id%type ) is select * from persons where login_id = login_id_in for update; rPersons persons%rowtype; rEmptabActive emptab_tmp%rowtype; cursor cEmpTabInactive is select distinct login_id from emptab_tmp where status = 'I'; cursor cEmpTabActive( login_id_in persons.login_id%type ) is select * from emptab_tmp where login_id = login_id_in and status = 'A' and effective_end_date > sysdate; begin for irec in cEmpTabInactive loop open cEmpTabActive( irec.login_id ); fetch cEmpTabActive into rEmptabActive; if not cEmpTabActive%found then open cUpdatePersons( irec.login_id ); fetch cUpdatePersons into rPersons; if cUpdatePersons%found then update persons set status = 'I' where current of cUpdatePersons; end if; close cUpdatePersons; end if; close cEmpTabActive; end loop; end; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).
Query
Hi gurus, My table data looks like as follows: [EMAIL PROTECTED]> select * from t; ID P1 PVAL1 P2 PVAL2 P3 PVAL3 - - - 101 A VALUE A B VALUE B C VALUE C 102 X VALUE X Y VALUE Y Z VALUE Z 103 P VALUE P Q VALUE Q R VALUE R [EMAIL PROTECTED]> Tab Description: [EMAIL PROTECTED]> desc t; NameNull?Type --- ID NUMBER PCD1 CHAR(1) PVAL1VARCHAR2(20) PCD2 CHAR(1) PVAL2VARCHAR2(20) PCD3 CHAR(1) PVAL3VARCHAR2(20) I need output as like: ID Pcd PVAL 101 A VALUE A 101 B VALUE B 101 C VALUE C 102 X VALUE X 102 Z VALUE Z 102 Y VALUE Y 103 P VALUE P 103 R VALUE R 103 Q VALUE Q Anyone have any idea pls. Rgds, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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: cached tables
Just by executing the command alter table xxx cache ; Table won't come in cache. You have to select rows from the table to get itinto cache. Another point is that kept field is meant for pl/sql packages and functionsand not for objects like tables/indexes etc. Below is full details of objectsand their codes that can be kept on database startup. -- Value Kind of Object to keep -- - -- -- P package/procedure/function -- Q sequence -- R trigger -- T type -- JS java source -- JC java class -- JR java resource -- JD java shared data -- C cursor So just run the command , select * from xxx ; and select * from yyy, and finally check after long time to verify that only xxx is in cache and yyy is flushed out from cache. Of course for verifying you can use, select name, owner from v$db_object_cache where name in ( 'xxx', 'yyy') ; HTH, Rajesh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin K. KaradenizSent: Saturday, September 29, 2001 10:55 PMTo: Multiple recipients of list ORACLE-LSubject: cached tables I execute alter table xxx cache ; But can not see this cached table on the query below. Why ? Do you have any idea.? SELECT name, type, kept FROM v$db_object_cache WHERE kept='YES';
