Re: db links...
Hi,
Create {public} database link LINK
connect to remote_db_username identified by remote_db_username_password
using
'connect_string_as_found_in_tnsnames_on_machine_where_you_create_database_link';
There may be some issues with global name settings that may force you to
name the database link exactly the same as the global name of the remote
database.
jack
Saurabh
Sharma To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
ssharma1@fcsl cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
td.com Subject: db links...
Sent by:
[EMAIL PROTECTED]
om
05-07-2001
09:05
Please respond
to ORACLE-L
hi all,
can any body has idea of how to create db links. we have 4-5 servers some
are test and some producn.
while requiring some info from other DBs how do i refer them ythrough
DBlinks.
Saurabh Sharma
[EMAIL PROTECTED]
http://www.geocities.com/saurabh00pc/stride.html
=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst
Young, niet toegestaan. Ernst Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.
Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst Young. Ernst Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.
If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.
In carrying out its engagements, Ernst Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
=
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Re: GETTING FIRST 250 CHARACTERS FROM A LONG DATATYPE
Hi, In SQL*Plus set long 250 Jack Mark Liggayu markliggayu@allweatherwi To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ndows.com cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: [EMAIL PROTECTED] Subject: GETTING FIRST 250 CHARACTERS FROM A LONG DATATYPE 04-07-2001 22:56 Please respond to ORACLE-L HI GURUS, If I have a table that has a field with long data type and I want to get the first 250 characters out of it how can I do it. I tried using SUBSTR(long data type field, 1, 250) but it complained about ORA-00932: inconsistent datatypes. I then tried TO_CHAR(SUBSTR(long data type field, 1, 250)) but still gave me the same result. Tried TO_VARCHAR2 but to no avail. Thanks, Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu 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). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
Re: db links...
Hi saurabh, There are two types of database links. Explict database link the syntax is :- CREATE DATABASE LINK db link name CONNECT USING user_name identified by passwd USING connect_string; Default database link the syntax is :- CREATE DATABASE LINK db link name CONNECT USING current_user USING connect_string; In this case, it will try to connect to the remote database with the user_name / passwd of the local database currently logged in. to access table /view/synonym from a remote db use select * from table_name/view_name@dblink_name; But to make this db link and then to access first make the connect string of the remote database in the local machine in the tnsnames.ora using net 8 easy configuration tool. --- Saurabh Sharma [EMAIL PROTECTED] wrote: hi all, can any body has idea of how to create db links. we have 4-5 servers some are test and some producn. while requiring some info from other DBs how do i refer them ythrough DBlinks. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html Do You Yahoo!? For regular News updates go to http://in.news.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?milind=20ambegaoker?= 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: db links...
Creating db link is pretty easy. This can be done easily by reading the documentation. On the other hand, think carefully to what you want to do. What do you want to access and who will access it. I've seen many clients not knowing who was accessing what because they have grant everything to public. --- Saurabh Sharma [EMAIL PROTECTED] a écrit : hi all, can any body has idea of how to create db links. we have 4-5 servers some are test and some producn. while requiring some info from other DBs how do i refer them ythrough DBlinks. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: how to browsed thru archives of this list
Hi Raja, There are two ways people do this - personally, I keep an archive of all Lyris mail through Look-Out archiving off any mail that is older than 3 days old, every day to a Personal File on my HD. If I have a specific question, I *usually* (not always :) try to import any mail from the archive searching for key words that relate to my question. You can also search the archive online though at : http://www.fatcity.com/ListGuru/login.php You will need to create an account I think.. HTH Mark -Original Message- Luthra Sent: Thursday, July 05, 2001 04:40 To: Multiple recipients of list ORACLE-L Hello all, Could you please tell me where and how I can browze thru archives of this list? I came to know about the archives from Jared's reply to Rob's email rgds, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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).
DB on NT
Hi, I' hav to build up foolowing matrix DB Size .. Operating system NT Sun Solaris AIX ... Has anyone a similar matrix to share? Especially I'm interested in the size for NT. I know there was a saying - put no database larger than 1 GB on a NT machine. Is this still true with 8.1.7 or is it stable with larger databases also? Regards, Antje Antje Sackwitz Pape+Partner Media GmbH Deliusstraße 10 D-24114 Kiel [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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 prob
thanks a lot.. one more thing...how to get the value of return key using sql.. i mean using gui data is entered and the user used enter key for next line so how to get that Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre 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).
can i place online redologs with oracle engine ?
list, i cannot spare a separate drive for the redologs, can i place the online logs with the same drive as the solaris + oracle engine ? (m,y solaris and oralce are also on the same drive) TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul 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).
How can I unsubscribe thislist?
Can anyone tell me how to unsubscribe from this list? Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: db links...
thanks a lot.
Saurabh Sharma
[EMAIL PROTECTED]
http://www.geocities.com/saurabh00pc/stride.html
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 05, 2001 1:20 PM
Hi,
Create {public} database link LINK
connect to remote_db_username identified by remote_db_username_password
using
'connect_string_as_found_in_tnsnames_on_machine_where_you_create_database_l
ink';
There may be some issues with global name settings that may force you to
name the database link exactly the same as the global name of the remote
database.
jack
Saurabh
Sharma To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
ssharma1@fcsl cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
td.com Subject: db links...
Sent by:
[EMAIL PROTECTED]
om
05-07-2001
09:05
Please respond
to ORACLE-L
hi all,
can any body has idea of how to create db links. we have 4-5 servers some
are test and some producn.
while requiring some info from other DBs how do i refer them ythrough
DBlinks.
Saurabh Sharma
[EMAIL PROTECTED]
http://www.geocities.com/saurabh00pc/stride.html
=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst
Young, niet toegestaan. Ernst Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.
Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst Young. Ernst Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.
If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.
In carrying out its engagements, Ernst Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
=
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Saurabh Sharma
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: CERT and Oracle
It was also reported by the SANS institute --29 June 2001 Oracle8i Database Buffer Overflow Vulnerability Security experts found and disclosed a pair of vulnerabilities in the standard and enterprise editions of Oracle8i database. The Transport Network Substrate (TNS) Listener has a buffer overflow vulnerability; a flaw in the SQL Net protocol leaves the system vulnerable to denial-of- service attacks. Patches are available. http://www.computerworld.com/storyba/0,4125,NAV47_STO61802,00.html Christian -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]De la part de Guy Hammond Envoyé : mercredi 4 juillet 2001 12:20 À : Multiple recipients of list ORACLE-L Objet : RE: CERT and Oracle Actually, this came in yesterday: http://www.cert.org/advisories/CA-2001-16.html g -Original Message- Sent: Tuesday, July 03, 2001 4:46 PM To: Multiple recipients of list ORACLE-L Most likely because no-one (at least, I hope not) connects their Oracle server directly to the Internet without a firewall in between, so Oracle servers aren't exposed to hacking attempts. Also, hackers can easily get hold of Linux, and use it to find holes in open-source programs like sendmail and bind (two CERT favorites) but there are fewer copies of Oracle available to non-specialists (altho' this is changing) to experiment with, and no source code in the wild. Oracle doesn't need to run as root. There's not (as far as I know) a way to make Oracle buffer-overflow and give control of the stack to arbitrary code (this is a typical sendmail/bind exploit). There are probably more (and better) reasons, but I think that would explain it. Cheers, g -Original Message- Sent: Tuesday, July 03, 2001 2:51 PM To: Multiple recipients of list ORACLE-L Why is Oracle listed so infrequently in the CERT advisories? Just wondering, since Oracle security patches appear to be available from Oracle... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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: Guy Hammond 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: Christian Bilien 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).
Schema organization
Hi all, I'm a fan of having the processing done by a user different than the owner of the data. Am I alone ? For example, we're on a datawarehouse system where the data owner is DWH. The etl tool repository owner is TOOL_POWERMART and the reporting tool repository owner is TOOL_BOWEBI. The etl processing is done by user DWH_PM_TRTMNT and the reporting processing is done by user DWH_BO_TRTMNT. This way, nobody is connecting as the data's owner. The developpers and Informatica (Powermart) consultant would prefer working directly as DWH. What do you think ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: GETTING FIRST 250 CHARACTERS FROM A LONG DATATYPE
Stephane, You could write a plsql by defiining a variable with 32K (like fetch_log_valuevarchar2(32760)) You could fetch the long data type column value into fetch_long_value variable after opening the cursor. After that you can use substr on this variable. Baskar -Original Message- Sent: 04 July 2001 23:20 To: Multiple recipients of list ORACLE-L Mark Liggayu wrote: HI GURUS, If I have a table that has a field with long data type and I want to get the first 250 characters out of it how can I do it. I tried using SUBSTR(long data type field, 1, 250) but it complained about ORA-00932: inconsistent datatypes. I then tried TO_CHAR(SUBSTR(long data type field, 1, 250)) but still gave me the same result. Tried TO_VARCHAR2 but to no avail. Thanks, Mark You can't apply a function to a LONG (but perhaps the LONG-to-LOB conversions of 8i). If this is possible to you (ie Oracle version supporting it), convert to CLOB or similar. Otherwise, all I can think of is a user-written PL/SQL function (would work with Oracle 7.3 and, of course, above). In PL/SQL, VARCHAR2 can be up to 32K (or around) and you CAN select a LONG into a large enough VARCHAR2. If your LONGs are under 32K, it is easy to write a function LONGSTART which fetches the suitable LONG into a suitably long VARCHAR2, and returns the 250 first characters of this VARCHAR2. Note that I am talking about feasibility, not performance (it may not be THAT bad but I wouldn't do it on millions of rows). -- HTH, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Ramasamy, Baskar 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).
test
test Best Regards Sinardy *** CONFIDENTIALITY CAUTION This message and its attachments (Message) are intended only for the use of the individual or entity to whom it is addressed, is confidential and may also be privileged. If you are not the intended recipient, please do not distribute, use or copy any part of it. Instead, please inform us immediately by return e-mail and delete this Message from your system or destroy it if you received it otherwise than by e-mail. Any opinions or representations contained in this Message shall not bind Banking Computer Services Private Limited (BCS) unless the author is authorized by BCS to communicate such opinion or representation and the authority of the author to so bind BCS is duly verified. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy 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: GETTING FIRST 250 CHARACTERS FROM A LONG DATATYPE
Mark, You could write a plsql by defiining a variable with 32K (like fetch_log_valuevarchar2(32760)) You could fetch the long data type column value into fetch_long_value variable after opening the cursor. After that you can use substr on this variable. Baskar -Original Message- Sent: 04 July 2001 21:56 To: Multiple recipients of list ORACLE-L HI GURUS, If I have a table that has a field with long data type and I want to get the first 250 characters out of it how can I do it. I tried using SUBSTR(long data type field, 1, 250) but it complained about ORA-00932: inconsistent datatypes. I then tried TO_CHAR(SUBSTR(long data type field, 1, 250)) but still gave me the same result. Tried TO_VARCHAR2 but to no avail. Thanks, Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu 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: Ramasamy, Baskar 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: DB on NT
Hi, Regarding the issue of databases larger than 1GB on NT, could someone please explain this to me, as I was not aware of this 'saying'. Thanks in advance, Steven H. -Original Message- Antje Sent: 05 July 2001 10:51 To: Multiple recipients of list ORACLE-L Hi, I' hav to build up foolowing matrix DB Size .. Operating system NT Sun Solaris AIX ... Has anyone a similar matrix to share? Especially I'm interested in the size for NT. I know there was a saying - put no database larger than 1 GB on a NT machine. Is this still true with 8.1.7 or is it stable with larger databases also? Regards, Antje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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).
D2k Reports
Hi, Is it possible to save the Bitmap Reports output in .txt or .pdf or .doc like files, if its so pls tell me how to do it. Thank you so much Regards GSK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Senthil Ganapathi 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: Schema organization
Stephane, I'm sure they would prefer to operate as the schema owner but to me it's sloppy practice. You're right; create the objects as DWH and grant the necessary permissions to the application users. That way only the schema owner has 'admin' rights (create, drop, alter etc.). If they can't come up with an excellent reason (it will things easier for us is NOT an excellent reason) then you should stick to your guns. Regards, Mike |+- || paquette stephane | || stephane_paquette@| || yahoo.com | || | || 07/05/01 11:40 AM | || Please respond to | || ORACLE-L | || | |+- | || | To: Multiple recipients of list ORACLE-L | | [EMAIL PROTECTED] | | cc: (bcc: Mike Hately/ETECH) | | Subject: Schema organization | | Hi all, I'm a fan of having the processing done by a user different than the owner of the data. Am I alone ? For example, we're on a datawarehouse system where the data owner is DWH. The etl tool repository owner is TOOL_POWERMART and the reporting tool repository owner is TOOL_BOWEBI. The etl processing is done by user DWH_PM_TRTMNT and the reporting processing is done by user DWH_BO_TRTMNT. This way, nobody is connecting as the data's owner. The developpers and Informatica (Powermart) consultant would prefer working directly as DWH. What do you think ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: 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: How can I unsubscribe thislist?
Roland You can find this information, right at the end of your email: Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -Original Message- [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 10:30 To: Multiple recipients of list ORACLE-L Can anyone tell me how to unsubscribe from this list? Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: can i place online redologs with oracle engine ?
off course -Original Message- Sent: Thursday, 5 July 2001 5:16 PM To: Multiple recipients of list ORACLE-L list, i cannot spare a separate drive for the redologs, can i place the online logs with the same drive as the solaris + oracle engine ? (m,y solaris and oralce are also on the same drive) TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul 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: Sinardy 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: Schema organization
i try to play by the same rule as you. but if i can't then i put the ddl triggers on the tables owned by the schema owner, which keeps at least the strucutures from being altered. joe paquette stephane wrote: Hi all, I'm a fan of having the processing done by a user different than the owner of the data. Am I alone ? For example, we're on a datawarehouse system where the data owner is DWH. The etl tool repository owner is TOOL_POWERMART and the reporting tool repository owner is TOOL_BOWEBI. The etl processing is done by user DWH_PM_TRTMNT and the reporting processing is done by user DWH_BO_TRTMNT. This way, nobody is connecting as the data's owner. The developpers and Informatica (Powermart) consultant would prefer working directly as DWH. What do you think ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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: DB on NT
Me neither. I've had database 50-70G in size on NT. (Which, in the grand scale of things isn't terribly large, but it's my personal experience and sufficient for this example). Compaq ProLiant servers, Compaq RAID controllers and storage arrays. Very nice equipment, rock solid and very fast. So long as you stick to the OEM'd drivers, you won't go wrong. I am a huge fan of Compaq servers, they must have learnt a great deal about system engineering from their acquisition of DEC. Nothing personal to anyone reading this, but there are a whole bunch of people on this list who have very strong anti-NT sentiments, which aren't always justified, IMHO. YMMV. rantDon't even get me started on Unix, which sucks. Rebooting if you need more file descriptors?! Or shared memory? All operating systems suck. Apart from maybe VMS./rant g -Original Message- Sent: Thursday, July 05, 2001 12:02 PM To: Multiple recipients of list ORACLE-L Hi, Regarding the issue of databases larger than 1GB on NT, could someone please explain this to me, as I was not aware of this 'saying'. Thanks in advance, Steven H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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: D2k Reports
Senthil, In the parameters palette window, you have two options - Destination Type and Mode. Both options allow you to produce the report in other than bitmap format. There is an options CHAR type format which is character-based. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 05, 2001 7:02 AM To: Multiple recipients of list ORACLE-L Hi, Is it possible to save the Bitmap Reports output in .txt or .pdf or .doc like files, if its so pls tell me how to do it. Thank you so much Regards GSK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Senthil Ganapathi 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: Mercadante, Thomas F 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: Online backup script..........
Thanks svend, BFN. -Original Message- Jensen Sent: Thursday, July 05, 2001 12:51 AM To: Multiple recipients of list ORACLE-L Here are two files, a NT cmd and a sql script that do hot backup of archivelog databases. Remember to configure the scripts and ajust to your enviroment jaimin wrote: Hello guru's, I am using one database in nonarchive log mode, I want to change it to archive log mode. Platform Windows nt 4.0 Oracle 7.3.0 database size 10GB. Can any body give me the script which will automatically take online backup of my database? BFN, Jaimin. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: jaimin 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: jaimin 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: DB on NT
Antje I know there was a saying - put no database larger than 1 GB on a NT machine. The above is nonsense. I have a database that is 200G on NT. I know of no limit regarding database size on NT. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 05, 2001 7:02 AM To: Multiple recipients of list ORACLE-L Hi, Regarding the issue of databases larger than 1GB on NT, could someone please explain this to me, as I was not aware of this 'saying'. Thanks in advance, Steven H. -Original Message- Antje Sent: 05 July 2001 10:51 To: Multiple recipients of list ORACLE-L Hi, I' hav to build up foolowing matrix DB Size .. Operating system NT Sun Solaris AIX ... Has anyone a similar matrix to share? Especially I'm interested in the size for NT. I know there was a saying - put no database larger than 1 GB on a NT machine. Is this still true with 8.1.7 or is it stable with larger databases also? Regards, Antje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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: Mercadante, Thomas F 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: DB on NT
Guy, rantDon't even get me started on Unix, which sucks. Rebooting if you need more file descriptors?! Or shared memory? All operating systems suck. Apart from maybe VMS./rant Isn't saying all operating systems suck a bit harsh? :) Personally, I think they all have their challenges, but they can be managed. I agree with you on two points - the anti-NT brigade on this list are a bit phobic, and that the VMS operating system is/was one of the best every designed! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 05, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Me neither. I've had database 50-70G in size on NT. (Which, in the grand scale of things isn't terribly large, but it's my personal experience and sufficient for this example). Compaq ProLiant servers, Compaq RAID controllers and storage arrays. Very nice equipment, rock solid and very fast. So long as you stick to the OEM'd drivers, you won't go wrong. I am a huge fan of Compaq servers, they must have learnt a great deal about system engineering from their acquisition of DEC. Nothing personal to anyone reading this, but there are a whole bunch of people on this list who have very strong anti-NT sentiments, which aren't always justified, IMHO. YMMV. rantDon't even get me started on Unix, which sucks. Rebooting if you need more file descriptors?! Or shared memory? All operating systems suck. Apart from maybe VMS./rant g -Original Message- Sent: Thursday, July 05, 2001 12:02 PM To: Multiple recipients of list ORACLE-L Hi, Regarding the issue of databases larger than 1GB on NT, could someone please explain this to me, as I was not aware of this 'saying'. Thanks in advance, Steven H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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: Mercadante, Thomas F 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: Online backup script..........
(robert) - you ARE the weakest link! goodbye! :) that's what I call immediate justice. -Original Message- Sent: Wednesday, July 04, 2001 7:36 PM To: Multiple recipients of list ORACLE-L Robert, After going through the archives I find that in the past year you have posted 14 times to this list, and once you had something to say about Oracle. The rest were rude replies that were completely unnecessary. I've reached the level of my tolerance with your acrimony. This list is supposed to be useful and occasionally entertaining. You contribute to neither. Goodbye, Jared On Wednesday 04 July 2001 15:55, Hutchins, Robert wrote: Ask me if I care -Original Message- Sent: Wednesday, July 04, 2001 5:35 PM To: Multiple recipients of list ORACLE-L My, my...were you afraid he wouldn't understand the 1st reply? In the vein of 'if you were the last man on earth...' you can delete my mails in the future, because you can be sure I will be deleting yours. Have a good day anyway!! Laura -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, July 04, 2001 4:05 PM To: Multiple recipients of list ORACLE-L Read the F--- manual. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F 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: Online backup script..........
Jared Still wrote: Many folks find the acronym RTFM to be sufficient, as it can also mean 'Read The Fine Manual' Do you mean there is another meaning to RTFM :o) Dave -Original Message- Sent: Wednesday, July 04, 2001 6:01 PM To: Multiple recipients of list ORACLE-L Isn't this a little harsh? I've certainly felt that way at times myself, but articulating it is considered rude. Many folks find the acronym RTFM to be sufficient, as it can also mean 'Read The Fine Manual' Jared On Wednesday 04 July 2001 14:05, Hutchins, Robert wrote: Read the F--- manual. -Original Message- Sent: Wednesday, July 04, 2001 3:10 PM To: Multiple recipients of list ORACLE-L Breakdown and read the admin guide, HINT: look at alter tablespace begin backup. learning is a wonderful thing. joe jaimin wrote: Hello guru's, I am using one database in nonarchive log mode, I want to change it to archive log mode. Platform Windows nt 4.0 Oracle 7.3.0 database size 10GB. Can any body give me the script which will automatically take online backup of my database? BFN, Jaimin. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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: how to browsed thru archives of this list
Mark, 1. What do you mean by Look-Out archiving? Do you mean to say that you save the email as File Save into your hard drive each and every mail, that is the ones you are interested in (if this is the case, well I will like to save all emails basically, you never know what you are reading today may be useful tomorrow) 2. I went to the site that you listed, but it does not give me any option to create a login account for archiving. Please show me the light! TIA Raja On Thu, 05 Jul 2001 01:12:34 Mark Leith wrote: Hi Raja, There are two ways people do this - personally, I keep an archive of all Lyris mail through Look-Out archiving off any mail that is older than 3 days old, every day to a Personal File on my HD. If I have a specific question, I *usually* (not always :) try to import any mail from the archive searching for key words that relate to my question. You can also search the archive online though at : http://www.fatcity.com/ListGuru/login.php You will need to create an account I think.. HTH Mark -Original Message- Luthra Sent: Thursday, July 05, 2001 04:40 To: Multiple recipients of list ORACLE-L Hello all, Could you please tell me where and how I can browze thru archives of this list? I came to know about the archives from Jared's reply to Rob's email rgds, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra 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: DB on NT
Perhaps it is confusion with filesize and then it is a whole different ball game and not only for NT but some older unixes and other OS's as well. and then we can start the arguments for using raw or not using raw for files under unix. Peter At 10:45 PM 5/07/2001, you wrote: Antje I know there was a saying - put no database larger than 1 GB on a NT machine. The above is nonsense. I have a database that is 200G on NT. I know of no limit regarding database size on NT. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 05, 2001 7:02 AM To: Multiple recipients of list ORACLE-L Hi, Regarding the issue of databases larger than 1GB on NT, could someone please explain this to me, as I was not aware of this 'saying'. Thanks in advance, Steven H. -Original Message- Antje Sent: 05 July 2001 10:51 To: Multiple recipients of list ORACLE-L Hi, I' hav to build up foolowing matrix DB Size .. Operating system NT Sun Solaris AIX ... Has anyone a similar matrix to share? Especially I'm interested in the size for NT. I know there was a saying - put no database larger than 1 GB on a NT machine. Is this still true with 8.1.7 or is it stable with larger databases also? Regards, Antje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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: Mercadante, Thomas F 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: Peter McLarty 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: Script to find space bound objects
Title: RE: Script to find space bound objects This is my two pence select a.tablespace_name,a.segment_name,a.segment_type,a.su ,b.sf from (select tablespace_name,segment_name,segment_type,next_extent/(1024*1024) su from dba_segments) a, (select tablespace_name,max(bytes/(1024*1024)) sf from dba_free_space group by tablespace_name) b where a.tablespacE_name=b.tablespace_name and a.su b.sf; Kevin Naik -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 26 June, 2001 16:31 To: Multiple recipients of list ORACLE-L Subject: Script to find space bound objects Hi All, I thought I had a script to check for space bound objects (can not allocate next extent for whatever reason) but seem to have misplaced it. Anybody want to save me the time? TIA Jack = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relating to the official business of Standard Bank Investment Corporation (Stanbic) is proprietary to the company. It is confidential, legally privileged and protected by law. Stanbic does not own and endorse any other content. Views and opinions are those of the sender unless clearly stated as being that of Stanbic. The person addressed in the e-mail is the sole authorised recipient. Please notify the sender immediately if it has unintentionally reached you and do not read, disclose or use the content in any way. Stanbic can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. ___
Re:DBMS_ALERT
I believe you'll need to be more specific. Using an alert is fairly simple, but sometimes does not get the desired results. Dick Goulet Reply Separator Author: Pulikkol Kumar [EMAIL PROTECTED] Date: 7/4/2001 12:35 AM Hi lists Any one can help me aboutdbms_alert(package)/how can i use in data base triggers Pulikkol Nitheesh Kumar Software Engineer Mannai Corporation C O S - PB # 76 Doha - Qatar Phone : 4412-555 extn -363 http//www.mannai.com.qa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pulikkol Kumar 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: 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:Schema organization
Stéphane, Your not alone. I like having one schema that owns all of the objects and a second or more that manipulate the data therein. The reason is that many times the passwords for the other user accounts get hard coded into software making them almost impossible to change. This way if the person who was maintaining the application leaves you can change the password there to do maintenance without breaking everything. Also if you do get a hacker in, it's a lot harder to have to delete everything vs drop a table. Dick Goulet Reply Separator Author: =?iso-8859-1?q?paquette=20stephane?= [EMAIL PROTECTED] Date: 7/5/2001 2:40 AM Hi all, I'm a fan of having the processing done by a user different than the owner of the data. Am I alone ? For example, we're on a datawarehouse system where the data owner is DWH. The etl tool repository owner is TOOL_POWERMART and the reporting tool repository owner is TOOL_BOWEBI. The etl processing is done by user DWH_PM_TRTMNT and the reporting processing is done by user DWH_BO_TRTMNT. This way, nobody is connecting as the data's owner. The developpers and Informatica (Powermart) consultant would prefer working directly as DWH. What do you think ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: 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: Online backup script..........
hahahah, roflmao, thats hilarious, my co-workers are wondering whats so funny. joe [EMAIL PROTECTED] 07/05/01 08:51AM (robert) - you ARE the weakest link! goodbye! :)that's what I call immediate justice.-Original Message-Sent: Wednesday, July 04, 2001 7:36 PMTo: Multiple recipients of list ORACLE-LRobert,After going through the archives I find that in the pastyear you have posted 14 times to this list, and onceyou had something to say about Oracle.The rest were rude replies that were completely unnecessary.I've reached the level of my tolerance with your acrimony.This list is supposed to be useful and occasionally entertaining.You contribute to neither.Goodbye,JaredOn Wednesday 04 July 2001 15:55, Hutchins, Robert wrote: Ask me if I care -Original Message- Sent: Wednesday, July 04, 2001 5:35 PM To: Multiple recipients of list ORACLE-L My, my...were you afraid he wouldn't understand the 1st reply? In the vein of 'if you were the last man on earth...' you can delete my mails in the future, because you can be sure I will be deleting yours. Have a good day anyway!! Laura -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, July 04, 2001 4:05 PM To: Multiple recipients of list ORACLE-L Read the F--- manual.-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re:can i place online redologs with oracle engine ?
Rahul, You can put them just about anywhere you want, but since they tend to be a high IO item you may end up paying a price. Dick Goulet Reply Separator Author: Rahul [EMAIL PROTECTED] Date: 7/5/2001 1:16 AM list, i cannot spare a separate drive for the redologs, can i place the online logs with the same drive as the solaris + oracle engine ? (m,y solaris and oralce are also on the same drive) TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul 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: 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).
RUPD$_
Good Thursday morning! I have a nagging question that I can find only sketchy documentation on. I have been working with Materialized Views and their associated logs and have been trying to figure out what the RUPD$_tablename structures are for. I have watched those tables during incremental processing, during refresh of the MV and have done searches with VERY limited information back from anywhere in Oracle... metalink, technet... Those tables never have any rows, and they are very similar to the MLOG$_tname tables. Does anyone know what the purpose of these tables are... what they do... anything? Thanks April Wells Corporate Systems Amarillo Texas The information contained in this e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited and may be illegal. If you have received this message in error, please notify the sender immediately by return e-mail. Corporate Systems, Inc. has taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells 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).
FYI - Oracle 8i contains buffer overflow in TNS listener
Hi, Please check this Thanks Muthu --- CERT Advisory CA-2001-16 Oracle 8i contains buffer overflow in TNS listener Original release date: July 03, 2001 Last revised: -- Source: CERT/CC A complete revision history is at the end of this file. Systems Affected * Systems running Oracle 8i Overview A vulnerability in Oracle 8i allows remote intruders to assume control of database servers running on victim machines. If the Oracle server is running on a Windows system, an intruder may also be able to gain control of the underlying operating system. I. Description The COVERT labs at PGP Security have discovered a buffer overflow vulnerability in Oracle 8i that allows intruders to execute arbitrary code with the privileges of the TNS listener process. The vulnerability occurs in a section of code that is executed prior to authentication, so an intruder does not require a username or password. For more information, see the COVERT Labs Security Advisory, available at http://www.pgp.com/research/covert/advisories/050.asp II. Impact An intruder who exploits the vulnerability can remotely execute arbitrary code. On UNIX systems, this code runs as the 'oracle' user. If running on Windows systems, the intruder's code will run in the Local System security context. In either case, the attacker can gain control of the database server on the victim machine. On Windows systems, the intruder can also gain administrative control of the operating system. III.Solutions Install a patch from Oracle. More information is available in Appendix A. Appendix A Oracle Oracle has issued an alert for this vulnerability at http://otn.oracle.com/deploy/security/pdf/nai_net8_bof.pdf Oracle has fixed this potential security vulnerability in the Oracle9i database server. Oracle is in the process of backporting the fix to supported Oracle8i database server Releases 8.1.7 and 8.1.6 and Oracle8 Release 8.0.6 on all platforms. The Oracle bug number for the patch is 1489683. Download the patch for your platform from Oracle's Worldwide Support web site, Metalink: http://metalink.oracle.com Please check Metalink periodically for patch availability if the patch for your platform is not yet available. _ Our thanks to COVERT Labs at PGP Security for the information contained in their advisory. _ This document was written by Shawn V. Hernan. If you have feedback concerning this document, please send email to: mailto:[EMAIL PROTECTED]?Subject=[VU#620495]%20Feedback%20CA-2001-16 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muthu Avudaiyappan 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: Online backup script..........
Title: RE: Online backup script.. Woo Hoo! Jared opened up a can on you Robert! c'ya! --Chris [EMAIL PROTECTED] -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 04, 2001 7:36 PM To: Multiple recipients of list ORACLE-L Subject: Re: Online backup script.. Robert, After going through the archives I find that in the past year you have posted 14 times to this list, and once you had something to say about Oracle. The rest were rude replies that were completely unnecessary. I've reached the level of my tolerance with your acrimony. This list is supposed to be useful and occasionally entertaining. You contribute to neither. Goodbye, Jared On Wednesday 04 July 2001 15:55, Hutchins, Robert wrote: Ask me if I care -Original Message- Sent: Wednesday, July 04, 2001 5:35 PM To: Multiple recipients of list ORACLE-L My, my...were you afraid he wouldn't understand the 1st reply? In the vein of 'if you were the last man on earth...' you can delete my mails in the future, because you can be sure I will be deleting yours. Have a good day anyway!! Laura -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, July 04, 2001 4:05 PM To: Multiple recipients of list ORACLE-L Read the F--- manual. -- 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: how to browsed thru archives of this list
1) Sorry about that - I was using a funny name for MS Outlook. Within Outlook, you have an option called archiving, which I have set up as follows: 1) Create a rule that moves all mail received in my Inbox from [EMAIL PROTECTED] to afolder called Lyris automatically when any mail comes in. (This keeps the lyris mail separate from any other business mail, for ease of reading) 2) Right mouse button on the Lyris folder, and choose properties. Click the tabAutoArchive. This will give a number of options for archiving mail in this particular folder. 3) Click the radio button for Clean out items older than and set it to 3 days. 4) Specify the location of where I want to save all of the emails. The file will be a *.pstfile - mine is called archive.pst Using this, you don't have to save each mail individually, all mail is just stored in the one file. If you want to check for subjects etc. from past postings, you then simply run File - Import and Export, and add your search criteria. Outlook will then search for any mail with a particular keyword, sender etc. and import them in to your current folder. 2) Do you see a login dialogue on this page (E-mail address password..)? If so - just above this there is a paragraph with a hyperlink sign up here. Click that go through the rigmarole, and your in. You can use this site to check all archives, top posters, top subjects etc. It's a pretty handy site sometimes.. HTH Mark -Original Message- Luthra Sent: Thursday, July 05, 2001 02:15 To: Multiple recipients of list ORACLE-L Mark, 1. What do you mean by Look-Out archiving? Do you mean to say that you save the email as File Save into your hard drive each and every mail, that is the ones you are interested in (if this is the case, well I will like to save all emails basically, you never know what you are reading today may be useful tomorrow) 2. I went to the site that you listed, but it does not give me any option to create a login account for archiving. Please show me the light! TIA Raja On Thu, 05 Jul 2001 01:12:34 Mark Leith wrote: Hi Raja, There are two ways people do this - personally, I keep an archive of all Lyris mail through Look-Out archiving off any mail that is older than 3 days old, every day to a Personal File on my HD. If I have a specific question, I *usually* (not always :) try to import any mail from the archive searching for key words that relate to my question. You can also search the archive online though at : http://www.fatcity.com/ListGuru/login.php You will need to create an account I think.. HTH Mark -Original Message- Luthra Sent: Thursday, July 05, 2001 04:40 To: Multiple recipients of list ORACLE-L Hello all, Could you please tell me where and how I can browze thru archives of this list? I came to know about the archives from Jared's reply to Rob's email rgds, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra 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
816/817 and JDBC Driver
Hi, following question on NT. I need to install 817 JDBC-Driver as I neet JDBC2 compliance. I just have a Oracle 8.1.6 database and installed SybaseToOracleWorkbench817. I copied JDBC-Driver in 8.1.7 home and was wondering if it is sufficient to have the 8.1.7 Home and OCI of 816 is used or do I need a 8.1.7 client? Regards, Antje Antje Sackwitz Pape+Partner Media GmbH Deliusstraße 10 D-24114 Kiel [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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: Schema organization
A couple of other reasons for this approach: When you create a DAD in Oracle Application Server, you can choose to store the password in the config file. On version 3.02 it is in unencrypted form and is optional. On 4.x it's encrypted and mandatory (unless you cheat and remove the password entry once you create the DAD). This permits you to change the password on the schema owner without having to change your DAD, especially important if your destination database is not owned by you! We normally define a schema and a secondary account like data and data_pub. We give data_pub all of the data manipulation rights to the data schema. Very safe. If you let others create database links to your database it is nice to avoid giving them the password to your schema. Since you can see the password unencrypted on their end after the database link is created this is especially dangerous. I would love to see this become standard practice. Once something goes into production there should not be that much DDL affecting the original schema anyway. We generally create all of the packages in the original schema and grant execute to the public schema. Hope this helps. --Michael -Original Message- Sent: Thursday, July 05, 2001 10:06 AM To: Multiple recipients of list ORACLE-L Stéphane, Your not alone. I like having one schema that owns all of the objects and a second or more that manipulate the data therein. The reason is that many times the passwords for the other user accounts get hard coded into software making them almost impossible to change. This way if the person who was maintaining the application leaves you can change the password there to do maintenance without breaking everything. Also if you do get a hacker in, it's a lot harder to have to delete everything vs drop a table. Dick Goulet Reply Separator Author: =?iso-8859-1?q?paquette=20stephane?= [EMAIL PROTECTED] Date: 7/5/2001 2:40 AM Hi all, I'm a fan of having the processing done by a user different than the owner of the data. Am I alone ? For example, we're on a datawarehouse system where the data owner is DWH. The etl tool repository owner is TOOL_POWERMART and the reporting tool repository owner is TOOL_BOWEBI. The etl processing is done by user DWH_PM_TRTMNT and the reporting processing is done by user DWH_BO_TRTMNT. This way, nobody is connecting as the data's owner. The developpers and Informatica (Powermart) consultant would prefer working directly as DWH. What do you think ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: 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: Jenkins, Michael 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).
UNIX vs. 2000... check out what the Gartner Group thinks about M$ latest offering and how they compare
I don't want to start another discussion on this topic, I just thought that this was a good article. It appears that Unix is still king for VLDB or mission critical apps... Frank - DPRO-89898 Mary Hubley, Mary Ann Richardson Gartner Group Technology Overview 24 January 2001 Server Operating Systems-Unix Versus Windows 2000: Perspective Summary Has Unix finally met its match in Windows 2000 Datacenter Server? Despite its gains in the midrange and departmental market, Windows-based platforms have never been able to supplant Unix when it came to building systems for enterprise applications such as large data warehouses, large-scale science and engineering simulations, online transaction processing (OLTP), and the myriad Web e-commerce and B-to- B applications that demand 24x7 availability. The Datacenter Edition of Windows 2000 aims to change all that. Note Microsoft announced the availability of Windows 2000 Datacenter in September 2000. Table of Contents Technology Basics Technology Analysis Business Use Standards Technology Leaders Insight List Of Tables Table 1: Microsoft Windows 2000 Datacenter Server Enterprise Features Server Operating Systems-Unix Versus Windows 2000: Perspective Technology Basics Will Windows 2000 Datacenter Server finally propel the Wintel platform into the enterprise? While Unix is here to stay, users who have been waiting for Windows to have the capability to run their enterprise computing environments can start to find it in the Datacenter Server Edition of Windows 2000. Datacenter has been designed to do away with many of the drawbacks of its predecessor, Windows NT, that made the Wintel platform unsuitable for 24x7 environments. For example, Microsoft estimates that over 40 percent of Windows NT applications errors are due to incompatible third-party device drivers. To avoid these and other such errors, users will not be able to purchase Datacenter and install it on their own hardware. Datacenter will only be available through hardware vendors that have tested their products under Microsoft's Windows Datacenter Program (WDP) and have been certified to license and support Datacenter Server. Microsoft has created the Windows Hardware Quality Labs (HQL) so that hardware and software vendors can ensure that their products work with Datacenter and other versions of Windows 2000. Hardware products that pass the corresponding Hardware Compatibility Test (HCT) are placed on the Datacenter Hardware Compatibility List (HCL), which lists the hardware that is guaranteed to work with Datacenter. And, of course, hardware that isn't on the HCL can't be sold in a Datacenter system. Any hardware vendor that sells Datacenter on its systems must ensure that all hardware drivers, kernel level software, virus software, disk and tape management software, backup software, etc., are certified for Datacenter. These vendors will also be required to maintain their Datacenter-compatible systems for the life of the current version of Datacenter plus 18 months. Datacenter vendors will provide all maintenance services for their systems including full installation of the OS and all drivers, an evaluation of Datacenter in the customer's environment, and on-site service with company employees or subcontracted through a third party. To ensure reliability for large-scale enterprise applications, Datacenter systems must guarantee a minimum uptime of 99.9 percent; higher uptimes will be required with clustered systems. In addition to how it will be sold, Datacenter includes a number of competitive features and enhancements for the enterprise-level market. Table 1: Microsoft Windows 2000 Datacenter Server Enterprise Features Horizontal vs. Vertical Scalability Previously, Windows platform users could only scale horizontally. With horizontal scalability, capacity is increased by adding more servers through the use of Windows Network Load Balancing (NLB) and Server Clustering. But while horizontal scaling avoids a situation that entails a single point of failure, having so many boxes to deal with makes it harder to manage and control. This is especially true for large-scale OLTP environments. Vertical scalability makes it much easier. Vertical scalability lets users scale up by adding more hardware resources, such as RAM, hard drives, and microprocessors, to a single system- thus, users have the increased power but only one system to manage. Before Windows Datacenter, users had but one choice- Unix- if they wanted their systems to scale vertically. Unix went beyond the 4GB of RAM and 8-multipprocessor support limitations of Windows. Now that Datacenter supports up to 32 processors and 64GB of RAM in a single system, vertical scalability has become a viable option within a Windows environment. However, this is still well below the 64-processor support available from high-end Unix machines, so users will still need horizontal
Re: Which RBS have active transactions?
Terrian, Tom wrote:
Does anyone know of a way to determine which RBS extents have active
transactions?
Specifically:
select a.segment_name, a.bytes, a.extents, c.xacts
from dba_segments a, dba_rollback_segs b, v$rollstat c
where a.segment_type = 'ROLLBACK'
and a.segment_name = b.segment_name
and b.segment_id = c.usn;
SEGMENT_NAMEBYTES EXTENTS XACTS
-- --
--
RB011474560090 2
RB027364608 45
2
RB033276800 20
2
SYSTEM 5079040 62 0
RB01 has 2 active transactions and 90 exents. Can I tell which of the exents
have the active transactions?
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
I do not think so. V$TRANSACTION will give you information about the
extent where it all started and how much rollback has been used (I think
- out of memory), but you will not be able to tell exactly which extents
(but the first one) are involved. I think that the detail is hard-coded
somewhere in the RBS header ('slot'), I don't think that it's accessible
even in some obscure X$.
--
Regards,
Stephane Faroult
Oriole Corporation
--
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
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: Schema organization
paquette stephane wrote: Hi all, I'm a fan of having the processing done by a user different than the owner of the data. Am I alone ? For example, we're on a datawarehouse system where the data owner is DWH. The etl tool repository owner is TOOL_POWERMART and the reporting tool repository owner is TOOL_BOWEBI. The etl processing is done by user DWH_PM_TRTMNT and the reporting processing is done by user DWH_BO_TRTMNT. This way, nobody is connecting as the data's owner. The developpers and Informatica (Powermart) consultant would prefer working directly as DWH. What do you think ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] I fully agree with you. DML and DDL are too businesses better kept separated. -- Regards, Stephane Faroult Oriole Corporation -- http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: how to browsed thru archives of this list
On Thursday 05 July 2001 07:41, Mark Leith wrote: folder called Lyris automatically when any mail comes in. (This keeps the lyris mailseparate from any other business mail, for ease of reading) Mark, You seem to be under the impression that we are still using Lyris mail software. I think we haven't been on that for two years now, or whatever the date was that we moved to fatcity.com. The list software is home grown by Bruce Bergman, and I have far less trouble with it than with lyris, in fact, none. 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: RUPD$_ (long)
April, How's Amarillo lately? ;-) The only useful thing I found was on metalink forum (I'm sure you've seen it) pasted below. Looks like a special log for UPDATABLE SNAPSHOTS, which would make sense in the context of 2 way replication. Scott Shafer San Antonio, TX --begin-- Hi, could somebody explain to me what's the funcionality of the RUPD$ tables and when they are created ? The chapter covering the creation of snapshot logs also states the MLOG$ tables only. Familiar with ORACLE version 8.0.5, i know the MLOG$ snapshot log tables only. I went through the 8.1.7 documentation, but i did not find any explanation, just a short remark about looking for 'temporay updatable snapshots' by checking the existance of these RUDP$ tables. Additionaly i did not find any comment on these 'temporay updatable snapshots'. Kind reagards Robert Puskas ~~~ From: Oracle, Ken Robinson 17-Apr-01 17:33 Subject: Re : RUPD$ tables There is very little available on this. It is part of the internals of replication and is only used for certain rare types of heterogenous replication. Regards, Ken Robinson Oracle Server EE Analyst ~~ From: Robert Puskas 18-Apr-01 13:50 Subject: Re : RUPD$ tables Hi, is it possible to get a more detailed information on this? Are these tables created per default during snapshot log creation or does the creation of these tables depend on some settings, which can be disbled or ... What happens if they are deleted for example, does it then influnece the behaviour/functionality of fast refreshes? The current environment is a ORACLE 8.1.7 database server used as master of updatable and read only snapshots for several ORACLE Lite clients, both running Windows NT. Kind regards Robert Puskas ~~~ From: Oracle, Ken Robinson 20-Apr-01 22:45 Subject: Re : Re : RUPD$ tables There is very little data on this available and I'm not getting much information back from our Replication group either. The only information I got back so far from another analyst is I know it gets created with the snapshot log beginning with Oracle8i whether it is for updatable snapshots or read only snapshots. It's some kind of 'temporary' table but I don't really know what it's used for during refresh? I'm trying to get more details. Regards, Ken Robinson Oracle Server EE Analyst ~~~ From: NextGen BP 02-May-01 14:26 Subject: Re : RUPD$ tables If I create the following snapshot specifying with primary key then a RUPD$_newtable table appears at the remote site over the database link where the master table resides. If I drop the materialised view and recreate the snapshot then the same happens only without a RUPD$_newtable table being created at the remote site over the database link where the master table resides. This would appear to be related to creating updateable snapshots. This table presumably records changes made at the snapshot site. create snapshot newtable pctfree 0 pctused 99 tablespace users storage (initial 1M next 1M pctincrease 0) using index tablespace users storage (initial 128K next 128K pctincrease 0) refresh fast start with sysdate next sysdate + 1/1440 with primary key using local rollback segment RBK1_1 FOR UPDATE as SELECT column list, FROM master_user.new_table@database_link; From: NextGen BP 02-May-01 14:38 Subject: Re : RUPD$ tables re : my above note from NEXTGEN is wrong. I refered to with primary key instead of FOR UPDATE FOR UPDATE registers the snapshot as updateable of the master for posting changes back to the Master site. sorry about the typo Des Fox BP NEXTGEN London ~ From: Oracle, Ken Robinson 04-May-01 17:50 Subject: Re : Re : RUPD$ tables Interesting. This topic seems to come up every now and then and I'll refer others back to your findings. Regards, Ken Robinson Oracle Server EE Analyst -end--- April Wells wrote: Good Thursday morning! I have a nagging question that I can find only sketchy documentation on. I have been working with Materialized Views and their associated logs and have been trying to figure out what the RUPD$_tablename structures are for. I have watched those tables during incremental processing, during refresh of the MV and have done searches with VERY limited information back from anywhere in Oracle... metalink, technet... Those tables never have any rows, and they are very similar to the MLOG$_tname tables. Does anyone know what the purpose of these tables are... what they do... anything? Thanks April Wells Corporate Systems Amarillo Texas _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the
RE: how to browsed thru archives of this list
Nope, under no such disillusions :) It's just that I have been on the list since way back when, and have always called it the Lyris List. I suppose I could call it ORACLE-L, but why change what I already have set up? :) I was just describing *my* set-up. I suppose you could call the folders Geoff if you really want too, don't take my word as God :) Mark -Original Message- Sent: Thursday, July 05, 2001 03:29 To: [EMAIL PROTECTED]; Mark Leith On Thursday 05 July 2001 07:41, Mark Leith wrote: folder called Lyris automatically when any mail comes in. (This keeps the lyris mailseparate from any other business mail, for ease of reading) Mark, You seem to be under the impression that we are still using Lyris mail software. I think we haven't been on that for two years now, or whatever the date was that we moved to fatcity.com. The list software is home grown by Bruce Bergman, and I have far less trouble with it than with lyris, in fact, none. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: Which RBS have active transactions?
Thanks, I was able to write a script that gets me most of what I want:
select a.segment_name, b.start_uext ACTIVE EXENT NUMBER,
b.used_ublk USED RBS BLOCKS
from dba_rollback_segs a, v$transaction b
where a.segment_id = b.xidusn
order by a.segment_name, b.start_uext;
SEGMENT_NAME ACTIVE EXENT NUMBER USED RBS BLOCKS
-- --- ---
RB0174 1
RB0182 1
RB0229 1
RB0237 1
RB03 5 1
RB0321 1
Thanks,
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
-Original Message-
Sent: Thursday, July 05, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L
Terrian, Tom wrote:
Does anyone know of a way to determine which RBS extents have active
transactions?
Specifically:
select a.segment_name, a.bytes, a.extents, c.xacts
from dba_segments a, dba_rollback_segs b, v$rollstat c
where a.segment_type = 'ROLLBACK'
and a.segment_name = b.segment_name
and b.segment_id = c.usn;
SEGMENT_NAMEBYTES EXTENTS XACTS
-- --
--
RB011474560090 2
RB027364608 45
2
RB033276800 20
2
SYSTEM 5079040 62 0
RB01 has 2 active transactions and 90 exents. Can I tell which of the exents
have the active transactions?
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
I do not think so. V$TRANSACTION will give you information about the
extent where it all started and how much rollback has been used (I think
- out of memory), but you will not be able to tell exactly which extents
(but the first one) are involved. I think that the detail is hard-coded
somewhere in the RBS header ('slot'), I don't think that it's accessible
even in some obscure X$.
--
Regards,
Stephane Faroult
Oriole Corporation
--
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
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: Terrian, Tom
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: Wildly OT. Made me laugh.
*excellent* !!!
thanks!
-Original Message-From: Robertson Lee - lerobe
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 04, 2001 7:31
AMTo: Multiple recipients of list ORACLE-LSubject:
Wildly OT. Made me laugh.
For
the UNIX people out there
Unix csh/sh commands:
% cat "food in cans"cat: can't open food in
cans
% nice man womanNo manual entry for
woman.
% rm Godrm: God nonexistent
% ar t Godar: God does not exist
% ar r Godar: creating God
% "How would you rate Quayle's
incompetence?Unmatched ".
% [Where is Jimmy Hoffa?Missing ].
% ^How did the sex change operation go?^
Modifier failed.
% If I had a ( for every $ the Congress spent, what
would I have?Too many ('s.
% make loveMake: Don't know how to make love.
Stop.
% sleep with mebad character
% got a light?No match.
% man: why did you get a divorce?man:: Too many
arguments.
% !:say, what is saccharine?Bad
substitute.
% %blow%blow: No such job.
/* not csh but sh */$
PATH=pretending!/usr/ucb/which senseno sense in pretending!
$ drink bottle: cannot openopener: not found
The information contained in this
communication isconfidential, is intended only for the use of the
recipientnamed above, and may be legally privileged. If the reader of
this message is not the intended recipient, you arehereby notified that
any dissemination, distribution orcopying 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
computersystem.
RE: DB on NT
ALso, what does 1GB actually mean? That much data, if you dumped it all out into a CSV file? A 1GB tablespace to hold all the data (and how is that tablespace organized)? 1GB being the sum of the sizes of all the datafiles? So, even if there were such a saying, it would be meaningless. What I like to do, and perhaps this is just me, is to have all the datafiles within a tablespace the same size. So, if I calculated that I needed a 2G tablespace, I might create 4 500M datafiles, and when I needed more I would add more 500M datafiles. I just think this makes things easier to manage, from a physical storage perspective. And contrary to the letter (rather than the spirit) of OFA, I name datafiles: /mount point/sid_tablespace_number.dbf Anyone else do something like this? guy -Original Message- Sent: Thursday, July 05, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Perhaps it is confusion with filesize and then it is a whole different ball game and not only for NT but some older unixes and other OS's as well. and then we can start the arguments for using raw or not using raw for files under unix. Peter At 10:45 PM 5/07/2001, you wrote: Antje I know there was a saying - put no database larger than 1 GB on a NT machine. The above is nonsense. I have a database that is 200G on NT. I know of no limit regarding database size on NT. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 05, 2001 7:02 AM To: Multiple recipients of list ORACLE-L Hi, Regarding the issue of databases larger than 1GB on NT, could someone please explain this to me, as I was not aware of this 'saying'. Thanks in advance, Steven H. -Original Message- Antje Sent: 05 July 2001 10:51 To: Multiple recipients of list ORACLE-L Hi, I' hav to build up foolowing matrix DB Size .. Operating system NT Sun Solaris AIX ... Has anyone a similar matrix to share? Especially I'm interested in the size for NT. I know there was a saying - put no database larger than 1 GB on a NT machine. Is this still true with 8.1.7 or is it stable with larger databases also? Regards, Antje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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: Mercadante, Thomas F 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: Peter McLarty 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: Guy Hammond 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).
Where is the lock?
On of our applications is reporting a problem trying to access on a record in a table. The application is reporting that a transaction is reserved for update. The app in question hung whilst working on the record a few days ago. I'm not convinced that this is an Oracle problem, i.e. a row lock of some sort, as I've had a peek at DB level via v$lock and v_$locked_object, v$access but can't seem to find any locks on the table in question. If it is an Oracle lock of some type how can I identify it?. The database gets shutdown every night for COLD backups but the app prog in question is reporting problem for number of days now. Is it possible that some session might still be haunting around?. Would appreciate any advice/help on this one folks?. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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: Schema organization
So what your DDL triggers are doing. And if they do not allow DDL to work how you can execute DDL - disabling these triggers? Alex Hillman -Original Message- Sent: Thursday, July 05, 2001 8:00 AM To: Multiple recipients of list ORACLE-L i try to play by the same rule as you. but if i can't then i put the ddl triggers on the tables owned by the schema owner, which keeps at least the strucutures from being altered. joe paquette stephane wrote: Hi all, I'm a fan of having the processing done by a user different than the owner of the data. Am I alone ? For example, we're on a datawarehouse system where the data owner is DWH. The etl tool repository owner is TOOL_POWERMART and the reporting tool repository owner is TOOL_BOWEBI. The etl processing is done by user DWH_PM_TRTMNT and the reporting processing is done by user DWH_BO_TRTMNT. This way, nobody is connecting as the data's owner. The developpers and Informatica (Powermart) consultant would prefer working directly as DWH. What do you think ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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: Hillman, Alex 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: ALTER SYNONYM?
Well, here's what I'm trying to do. I've got a pile of tables that are
read-only tables that are downloaded periodically (approximately daily)
from another system. They get slurped into our database via sqlloader.
A previous incarnation of this process had the setup run sqlloader on the
data table directly. The side-effect was that while it was being loaded,
the data in the table would disappear while the data was being loaded.
So the solution (obtained here, actually) was to have two tables FOO_A and
FOO_B, and have a synonym FOO that pointed to either FOO_A or FOO_B.
While FOO_A is live, then FOO_B gets loaded, and then the synonym
switches, so the new 'table' FOO appears instantly.
Needing to drop the synonym and recreate it is a two-step process... so
there is always the possibility someone will do a SELECT against FOO in
the instant between the operations. I'm trying to avoid that gap if
possible.
I'd like to stay away from a view, since these tables are heavily used for
reading, and are heavily indexed based on their usage... and a view would
certainly complicate that.
-Rick
On Mon, 2 Jul 2001, Jim Conboy wrote:
Can you use a view instead?
SVRMGR create table temp1 (temp1 varchar2(1));
Statement processed.
SVRMGR create table temp2 (temp1 varchar2(1));
Statement processed.
SVRMGR insert into temp1 values ('a');
1 row processed.
SVRMGR insert into temp1 values ('a');
1 row processed.
SVRMGR insert into temp1 values ('a');
1 row processed.
SVRMGR insert into temp1 values ('a');
1 row processed.
SVRMGR insert into temp2 values ('b');
1 row processed.
SVRMGR insert into temp2 values ('b');
1 row processed.
SVRMGR insert into temp2 values ('b');
1 row processed.
SVRMGR create or replace view temp as select * from temp1;
Statement processed.
SVRMGR select * from temp;
T
-
a
a
a
a
4 rows selected.
SVRMGR create or replace view temp as select * from temp2;
Statement processed.
SVRMGR select * from temp;
T
-
b
b
b
3 rows selected.
SVRMGR
Maybe some unwanted overhead with the view, but it might help out.
Jim
[EMAIL PROTECTED] 06/30/01 04:56PM
Is there a way to do what would be an ALTER SYNONYM?
I've got a synonym created that rotates between pointing to two different
tables. Sometimes it points to TABLE_A, sometimes to TABLE_B. (This is
so that behind the scenes, I can truncate and reload TABLE_A, and then
swap, etc. so the table never disappears.)
However, when I want to switch the SYNONYM from pointing to TABLE_A to
pointing to TABLE_B, the only way is to:
drop synonym table_syn;
create synonym table_syn for table_b;
Is there a way to make that instantaneous for the database? If someone
does a select at the exact instant between those two commands, it'll error
out, because the table won't exist.
-Rick
+--+
| Rick Osterberg [EMAIL PROTECTED]|
| Database Applications Specialist FAS Computer Services |
+--+
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rick Osterberg
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).
+--+
| Rick Osterberg [EMAIL PROTECTED]|
| Database Applications Specialist FAS Computer Services |
+--+
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rick Osterberg
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: urgent..! how to combining 2 querries...
-Original Message- Sent: Wednesday, July 04, 2001 2:53 PM To: '[EMAIL PROTECTED]' I think you need this comp sum of nfrags totsiz avasiz on report break on report col tsname format a16 justify c heading 'Tablespace' col nfrags format 999,990 justify c heading 'Free|Frags' col mxfrag format 999,999,990 justify c heading 'Largest|Frag (KB)' col totsiz format 999,999,990 justify c heading 'Total|(KB)' col avasiz format 999,999,990 justify c heading 'Available|(KB)' col pctusd format 990 justify c heading 'Pct|Used' select total.tablespace_name tsname, count(free.bytes) nfrags, nvl(max(free.bytes)/1024,0) mxfrag, total.bytes/1024 totsiz, nvl(sum(free.bytes)/1024,0) avasiz, (1-nvl(sum(free.bytes),0)/total.bytes)*100 pctusd from dba_data_files total, dba_free_space free where total.tablespace_name = free.tablespace_name(+) group by total.tablespace_name, total.bytes / PS: Don't remember the source of this script . HTH, Rajesh -Original Message- Sharma Sent: Wednesday, July 04, 2001 11:46 AM To: Multiple recipients of list ORACLE-L ya i checked this too.. it's not working. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 7:00 PM sorry. I checked it and turned out that this is wrong solution Hi! Try this. select a.tablespace_name,sum(a.bytes),sum(b.bytes) from dba_data_files a, dba_free_space b where b.tablespace_name=a.tablespace_name group by a.tablespace_name Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saurabh Sharma 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: Rajesh Dayal 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: RUPD$_ (long)
Amarillo is still beautiful.. although the natives don't seem to share my enthusiasm. Yeah, I found this... I was just hoping for... more. I can find considerable stuff on mlog$_ tables, but I'm still digging on this one. I love the 'documenation' on some of these 'features'. Thanks April Wells Corporate Systems Amarillo Texas -Original Message- Sent: Thursday, July 05, 2001 10:37 AM To: Multiple recipients of list ORACLE-L April, How's Amarillo lately? ;-) The only useful thing I found was on metalink forum (I'm sure you've seen it) pasted below. Looks like a special log for UPDATABLE SNAPSHOTS, which would make sense in the context of 2 way replication. Scott Shafer San Antonio, TX --begin-- Hi, could somebody explain to me what's the funcionality of the RUPD$ tables and when they are created ? The chapter covering the creation of snapshot logs also states the MLOG$ tables only. Familiar with ORACLE version 8.0.5, i know the MLOG$ snapshot log tables only. I went through the 8.1.7 documentation, but i did not find any explanation, just a short remark about looking for 'temporay updatable snapshots' by checking the existance of these RUDP$ tables. Additionaly i did not find any comment on these 'temporay updatable snapshots'. Kind reagards Robert Puskas ~~~ From: Oracle, Ken Robinson 17-Apr-01 17:33 Subject: Re : RUPD$ tables There is very little available on this. It is part of the internals of replication and is only used for certain rare types of heterogenous replication. Regards, Ken Robinson Oracle Server EE Analyst ~~ From: Robert Puskas 18-Apr-01 13:50 Subject: Re : RUPD$ tables Hi, is it possible to get a more detailed information on this? Are these tables created per default during snapshot log creation or does the creation of these tables depend on some settings, which can be disbled or ... What happens if they are deleted for example, does it then influnece the behaviour/functionality of fast refreshes? The current environment is a ORACLE 8.1.7 database server used as master of updatable and read only snapshots for several ORACLE Lite clients, both running Windows NT. Kind regards Robert Puskas ~~~ From: Oracle, Ken Robinson 20-Apr-01 22:45 Subject: Re : Re : RUPD$ tables There is very little data on this available and I'm not getting much information back from our Replication group either. The only information I got back so far from another analyst is I know it gets created with the snapshot log beginning with Oracle8i whether it is for updatable snapshots or read only snapshots. It's some kind of 'temporary' table but I don't really know what it's used for during refresh? I'm trying to get more details. Regards, Ken Robinson Oracle Server EE Analyst ~~~ From: NextGen BP 02-May-01 14:26 Subject: Re : RUPD$ tables If I create the following snapshot specifying with primary key then a RUPD$_newtable table appears at the remote site over the database link where the master table resides. If I drop the materialised view and recreate the snapshot then the same happens only without a RUPD$_newtable table being created at the remote site over the database link where the master table resides. This would appear to be related to creating updateable snapshots. This table presumably records changes made at the snapshot site. create snapshot newtable pctfree 0 pctused 99 tablespace users storage (initial 1M next 1M pctincrease 0) using index tablespace users storage (initial 128K next 128K pctincrease 0) refresh fast start with sysdate next sysdate + 1/1440 with primary key using local rollback segment RBK1_1 FOR UPDATE as SELECT column list, FROM master_user.new_table@database_link; From: NextGen BP 02-May-01 14:38 Subject: Re : RUPD$ tables re : my above note from NEXTGEN is wrong. I refered to with primary key instead of FOR UPDATE FOR UPDATE registers the snapshot as updateable of the master for posting changes back to the Master site. sorry about the typo Des Fox BP NEXTGEN London ~ From: Oracle, Ken Robinson 04-May-01 17:50 Subject: Re : Re : RUPD$ tables Interesting. This topic seems to come up every now and then and I'll refer others back to your findings. Regards, Ken Robinson Oracle Server EE Analyst -end--- April Wells wrote: Good Thursday morning! I have a nagging question that I can find only sketchy documentation on. I have been working with Materialized Views and their associated logs and have been trying to figure out what the RUPD$_tablename structures are for. I have watched those tables during incremental processing, during refresh of the MV and have done searches with VERY limited
RE: DB on NT
I tend to leave out the sid in a datafile name, saves me from having to rename it, if i'm doing the transportable tablespace ordeal. joe [EMAIL PROTECTED] 07/05/01 12:03PM ALso, what does "1GB" actually mean? That much data, if you dumped itall out into a CSV file? A 1GB tablespace to hold all the data (and howis that tablespace organized)? 1GB being the sum of the sizes of all thedatafiles? So, even if there were such a saying, it would bemeaningless.What I like to do, and perhaps this is just me, is to have all thedatafiles within a tablespace the same size. So, if I calculated that Ineeded a 2G tablespace, I might create 4 500M datafiles, and when Ineeded more I would add more 500M datafiles. I just think this makesthings easier to manage, from a physical storage perspective. Andcontrary to the letter (rather than the spirit) of OFA, I namedatafiles:/mount point/sid_tablespace_number.dbfAnyone else do something like this?guy-Original Message-Sent: Thursday, July 05, 2001 2:56 PMTo: Multiple recipients of list ORACLE-LPerhaps it is confusion with filesize and then it is a whole differentball game and not only for NT but some older unixes and other OS's as well.and then we can start the arguments for using raw or not using raw for filesunder unix.PeterAt 10:45 PM 5/07/2001, you wrote:Antje"I know there was a saying - put no database larger than 1 GB on a NTmachine."The above is nonsense. I have a database that is 200G on NT. I knowof nolimit regarding database size on NT.Tom MercadanteOracle Certified Professional-Original Message-Sent: Thursday, July 05, 2001 7:02 AMTo: Multiple recipients of list ORACLE-LHi,Regarding the issue of databases larger than 1GB on NT, could someonepleaseexplain this to me, as I was not aware of this 'saying'.Thanks in advance,Steven H.-Original Message-AntjeSent: 05 July 2001 10:51To: Multiple recipients of list ORACLE-LHi,I' hav to build up foolowing matrix DB Size ..Operating systemNTSun SolarisAIX...Has anyone a similar matrix to share?Especially I'm interested in the size for NT.I know there was a saying - put no database larger than 1 GB on a NTmachine.Is this still true with 8.1.7 or is it stable with larger databasesalso?Regards,Antje--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Steven Hovington INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Mercadante, Thomas F INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Peter McLarty INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Guy Hammond INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Schema organization
yeppers, if you want to prevent ddl on tables when you are required to give out the schema owner password, you put those triggers on all of the objects. This assumes the user logging does NOT have alter any trigger. The triggers are owned by a separate userid and look like this(besides you can alter the trigger to let specific userids do the alter without having to disable them). create or replace trigger create_control_triggerbefore create on SCHEMA_NAME.schema begin raise_application_error(-20001,'NO CREATE DDL ALLOWED');end;/ create or replace trigger drop_control_triggerbefore drop on SCHEMA_NAME.schema begin raise_application_error(-20001,'NO DROP DDL ALLOWED');end;/create or replace trigger alter_control_triggerbefore alter on SCHEMA_NAME.schema begin raise_application_error(-20001,'NO ALTER DDL ALLOWED');end;/ Joe [EMAIL PROTECTED] 07/05/01 12:03PM So what your DDL triggers are doing. And if they do not allow DDL to workhow you can execute DDL - disabling these triggers?Alex Hillman-Original Message-Sent: Thursday, July 05, 2001 8:00 AMTo: Multiple recipients of list ORACLE-Li try to play by the same rule as you.but if i can't then i put the "ddl" triggers on the tables owned by theschema owner, which keeps at least the strucutures from being altered.joepaquette stephane wrote: Hi all, I'm a fan of having the processing done by a user different than the owner of the data. Am I alone ? For example, we're on a datawarehouse system where the data owner is DWH. The etl tool repository owner is TOOL_POWERMART and the reporting tool repository owner is TOOL_BOWEBI. The etl processing is done by user DWH_PM_TRTMNT and the reporting processing is done by user DWH_BO_TRTMNT. This way, nobody is connecting as the data's owner. The developpers and Informatica (Powermart) consultant would prefer working directly as DWH. What do you think ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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)-- Joe Testa Performing Remote DBA Services, need some backup DBA support?For Sale: Oracle-dba.com domain, its not going cheap but feel free toask :)-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Joe Testa INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Hillman, Alex INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Tracing Events - Anybody have a list of the Events?
Morning Folks - Hope those of you in the US had a safe and happy 4th - for those of you who didn't celebrate this particular holiday, hope your day was also safe and happy ( every day should be safe and happy!). I'm trying to set up some tracing for various events/levels. Not using OEM. In the past (and currently), I've just used: event=10046 trace name context forever,level 4 This of course provides the requisite information, but really can tell you much more than you want (or need) to know. The trace levels given on Metalink are: 1 - Enable standard SQL_TRACE functionality (Default) 4 - As Level 1 PLUS trace bind values 8 - As Level 1 PLUS trace waits However they state in multiple messages that: Events should be set only under the direction of Oracle Support and/or Development. Some events produce additional diagnostic information, others are intrusive into database operations, while others can effect data in the database. Syntax varies between events as does the meaning of the level. Oracle Support/Development will identify the proper syntax and level (if applicable) you should use. In my handy copy of Steve Adam's Oracle 8i internals, he gives three different trace events (one of which is a level 13 - what the heck is that?), but they're all memory related. Does anyone have a list of the events/levels they would care to share? Regards, David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)
Mac OS X client for Oracle coming?
This is from www.gmsv.com http://www.gmsv.com from yesterday. Oracle has embarked on an effort to develop client software that will connect Oracle database applications to workstations running Apple's new Mac OS X operating system http://www.zdnet.com/eweek/stories/general/0,11011,2781381,00.html . Noting that a production version of the software isn't likely to be ready until the end of the year, Bob Shimp, senior director of Oracle 9i database marketing, said the software still needs work. The Mac client will provide programmatic connectivity to Oracle databases but will not provide any client tools (executables) such as SQL*Plus, Shimp told EWeek. As such, it is not a full client like that on [Microsoft] Windows. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: 11 disks to build a DB, suggestions
Diego, I think log02 is not a redundant log01, I'm pretty sure it's the second redo log group, without which it will be pretty difficult to run the database :-). Maybe Rahul shouldn't delete it. Yosi -Original Message- From: Diego Cutrone [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 5:06 PM To: Multiple recipients of list ORACLE-L Subject: RE: 11 disks to build a DB, suggestions Hi Rahul, Here's what I think. I would eliminate log02 , because redo log files are already mirrored (D1 is mirrored right?) Another recomendation is to use RAW for the redo logs. By eliminating log02, and according to your load (600,000 rows using sql*loader) every night, I think you are going to improve performance a lot. If you can't use RAW for the REDO, at least try to use aync I/O or direct I/O on these filesystems. I would create only one control file mirrored by hardware too. Also if your internal disks are faster than the external ones, I would place redo logs over the faster disks. And I'd leave D1 dedicated to redo logs in order to eliminate seek times. please someone correct me if I'm wrong hope it helps greetings Diego - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 7:25 AM List, i have been given 11 Hdisks (36GB each) to build a database (816) the DB involves heavy loads (600,000 rows using sql*loader) every night. three drives are internal and the rest are external. main table involved is SALES , which i have partitioned by year 2000, 2001 and a scratch partitioned to hold any other years sales data (which i will split later) the DB will be running in NOARCHIVELOG, to provide some guard against failure i plan to mirror (1:1) 4 drives, which leaves me with 7 drives to use. D1 to D4 are mirrored. D5,D6,D7 are NOT mirrored D1 - log01 + SALES DATA FOR 2000 (keeping this partition with the log because 2000 sales data wil not be queried often) D2 - DATA1 + DATA2 + SALES DATA FOR 2001 D3 - SALES SCRATCH + log02 ( this scratch partition will be used when rows for year 2002 starts coming in) D4 - DATA3 + DATA4 + SYSTEM D5 - RBS01 + USER_TEMP + INDEX01 D6 - RBS-2 + INDEX02 + TEMP_TABLES D7 - solaris system + oracle engine. would really appreciate if someone could review this config , and suggest improvements. Regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul 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: 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: Tracing Events - Anybody have a list of the Events?
Look near the end (~70% through) of the $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events. This is about all I could find. Anyone else? Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: Morning Folks - Hope those of you in the US had a safe and happy 4th - for those of you who didn't celebrate this particular holiday, hope your day was also safe and happy ( every day should be safe and happy!). I'm trying to set up some tracing for various events/levels. Not using OEM. In the past (and currently), I've just used: event=10046 trace name context forever,level 4 This of course provides the requisite information, but really can tell you much more than you want (or need) to know. The trace levels given on Metalink are: 1 - Enable standard SQL_TRACE functionality (Default) 4 - As Level 1 PLUS trace bind values 8 - As Level 1 PLUS trace waits However they state in multiple messages that: Events should be set only under the direction of Oracle Support and/or Development. Some events produce additional diagnostic information, others are intrusive into database operations, while others can effect data in the database. Syntax varies between events as does the meaning of the level. Oracle Support/Development will identify the proper syntax and level (if applicable) you should use. In my handy copy of Steve Adam's Oracle 8i internals, he gives three different trace events (one of which is a level 13 - what the heck is that?), but they're all memory related. Does anyone have a list of the events/levels they would care to share? Regards, David A. Barbour Oracle DBA, OCP AISD 512-414-1002 _ 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: Scott Shafer 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: Online backup script..........
Now THAT is both useful AND entertaining! -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 04, 2001 7:36 PM To: Multiple recipients of list ORACLE-L Subject: Re: Online backup script.. Robert, After going through the archives I find that in the past year you have posted 14 times to this list, and once you had something to say about Oracle. The rest were rude replies that were completely unnecessary. I've reached the level of my tolerance with your acrimony. This list is supposed to be useful and occasionally entertaining. You contribute to neither. Goodbye, Jared On Wednesday 04 July 2001 15:55, Hutchins, Robert wrote: Ask me if I care -Original Message- Sent: Wednesday, July 04, 2001 5:35 PM To: Multiple recipients of list ORACLE-L My, my...were you afraid he wouldn't understand the 1st reply? In the vein of 'if you were the last man on earth...' you can delete my mails in the future, because you can be sure I will be deleting yours. Have a good day anyway!! Laura -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, July 04, 2001 4:05 PM To: Multiple recipients of list ORACLE-L Read the F--- manual. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tracing Events - Anybody have a list of the Events?
All the events are there in $ORACLE_HOME/rdbms/mesg/oraus.msg The ones you're interested in are the ones above 1. Regards, Waleed -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 12:11 PM To: Multiple recipients of list ORACLE-L Morning Folks - Hope those of you in the US had a safe and happy 4th - for those of you who didn't celebrate this particular holiday, hope your day was also safe and happy ( every day should be safe and happy!). I'm trying to set up some tracing for various events/levels. Not using OEM. In the past (and currently), I've just used: event=10046 trace name context forever,level 4 This of course provides the requisite information, but really can tell you much more than you want (or need) to know. The trace levels given on Metalink are: 1 - Enable standard SQL_TRACE functionality (Default) 4 - As Level 1 PLUS trace bind values 8 - As Level 1 PLUS trace waits However they state in multiple messages that: Events should be set only under the direction of Oracle Support and/or Development. Some events produce additional diagnostic information, others are intrusive into database operations, while others can effect data in the database. Syntax varies between events as does the meaning of the level. Oracle Support/Development will identify the proper syntax and level (if applicable) you should use. In my handy copy of Steve Adam's Oracle 8i internals, he gives three different trace events (one of which is a level 13 - what the heck is that?), but they're all memory related. Does anyone have a list of the events/levels they would care to share? Regards, David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed 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
RE: Online backup script..........
Amen and Bravo, Jared. -Original Message- Sent: Thursday, July 05, 2001 12:46 PM To: Multiple recipients of list ORACLE-L Now THAT is both useful AND entertaining! -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 04, 2001 7:36 PM To: Multiple recipients of list ORACLE-L Subject: Re: Online backup script.. Robert, After going through the archives I find that in the past year you have posted 14 times to this list, and once you had something to say about Oracle. The rest were rude replies that were completely unnecessary. I've reached the level of my tolerance with your acrimony. This list is supposed to be useful and occasionally entertaining. You contribute to neither. Goodbye, Jared On Wednesday 04 July 2001 15:55, Hutchins, Robert wrote: Ask me if I care -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: ALTER SYNONYM?
Hi Rick,
How about creating a private synonym for FOO_A and a public synonym for
FOO_B. When you drop the private synonym, the public synonym takes effect
immediately, and when FOO_A is ready for usage again, you can create a new
private synonym. That way there's always a table available.
Just a thought ...
HTH, Remco
-Oorspronkelijk bericht-
Van: Rick Osterberg [mailto:[EMAIL PROTECTED]]
Verzonden: donderdag 5 juli 2001 18:06
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: ALTER SYNONYM?
Well, here's what I'm trying to do. I've got a pile of tables that are
read-only tables that are downloaded periodically (approximately daily)
from another system. They get slurped into our database via sqlloader.
A previous incarnation of this process had the setup run sqlloader on the
data table directly. The side-effect was that while it was being loaded,
the data in the table would disappear while the data was being loaded.
So the solution (obtained here, actually) was to have two tables FOO_A and
FOO_B, and have a synonym FOO that pointed to either FOO_A or FOO_B.
While FOO_A is live, then FOO_B gets loaded, and then the synonym
switches, so the new 'table' FOO appears instantly.
Needing to drop the synonym and recreate it is a two-step process... so
there is always the possibility someone will do a SELECT against FOO in
the instant between the operations. I'm trying to avoid that gap if
possible.
I'd like to stay away from a view, since these tables are heavily used for
reading, and are heavily indexed based on their usage... and a view would
certainly complicate that.
-Rick
On Mon, 2 Jul 2001, Jim Conboy wrote:
Can you use a view instead?
SVRMGR create table temp1 (temp1 varchar2(1));
Statement processed.
SVRMGR create table temp2 (temp1 varchar2(1));
Statement processed.
SVRMGR insert into temp1 values ('a');
1 row processed.
SVRMGR insert into temp1 values ('a');
1 row processed.
SVRMGR insert into temp1 values ('a');
1 row processed.
SVRMGR insert into temp1 values ('a');
1 row processed.
SVRMGR insert into temp2 values ('b');
1 row processed.
SVRMGR insert into temp2 values ('b');
1 row processed.
SVRMGR insert into temp2 values ('b');
1 row processed.
SVRMGR create or replace view temp as select * from temp1;
Statement processed.
SVRMGR select * from temp;
T
-
a
a
a
a
4 rows selected.
SVRMGR create or replace view temp as select * from temp2;
Statement processed.
SVRMGR select * from temp;
T
-
b
b
b
3 rows selected.
SVRMGR
Maybe some unwanted overhead with the view, but it might help out.
Jim
[EMAIL PROTECTED] 06/30/01 04:56PM
Is there a way to do what would be an ALTER SYNONYM?
I've got a synonym created that rotates between pointing to two different
tables. Sometimes it points to TABLE_A, sometimes to TABLE_B. (This is
so that behind the scenes, I can truncate and reload TABLE_A, and then
swap, etc. so the table never disappears.)
However, when I want to switch the SYNONYM from pointing to TABLE_A to
pointing to TABLE_B, the only way is to:
drop synonym table_syn;
create synonym table_syn for table_b;
Is there a way to make that instantaneous for the database? If someone
does a select at the exact instant between those two commands, it'll error
out, because the table won't exist.
-Rick
+--+
| Rick Osterberg [EMAIL PROTECTED]
|
| Database Applications Specialist FAS Computer Services
|
+--+
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rick Osterberg
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).
+--+
| Rick Osterberg [EMAIL PROTECTED]|
| Database Applications Specialist FAS Computer Services |
+--+
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rick Osterberg
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
Change Manager problem
Has anyone seen this? Change Manager (OEM 2.2.) on my machine takes a snapshot of Oracle 7.3. databases all right, but when I try to compare this baseline against an existing 8.1.7. database (or a baseline of same), Change Manager does not detect the tablespaces, views, tables, triggers from the new database. When I query the new database using SQL*Plus, that database assures me that these objects do exist. This is not a huge database, the export file was only about 800M. I am going to log another TAR re. this. I have three TARs open re. iAS 1.0.2.2., now I am going to re-submit the same question I asked Oracle Support roughly a month ago. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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).
OT: Ari and his company have been noted in InfoWorld...
Ari and his company have been noted in InfoWorld... EPHRAIM SCHWARTZ Wireless World InfoWorld.com Thursday, July 5, 2001 REDUCING THE COST OF DBAS Posted at June 29, 2001 01:01 PM PST Pacific I'LL LEAVE IT to my readers to quantify the amount of time and money their companies would save if their DBAs (database administrators) could remotely, and wirelessly, make changes to their databases. Imagine the efficiencies in not having to call a DBA back to the office to add table space to a database, look at what indexes exist and modify table structures, give a new password to a user who has forgotten it, or remove from the database a user who is running a command that is holding up the system. You can accomplish these and many other corrective measures using the application PocketDBA, available from the company of the same name. I spoke with Ari Kaplan, CEO and co-founder of PocketDBA, in Chicago. His background includes 10 years at Oracle, where he oversaw the implementation of some of the largest Oracle database deployments in the world, such as Hallmark's Web site and Merck's entire order-entry and inventory system. Kaplan believes his company's wireless DBA package is more robust than Oracle's own desktop Enterprise Manager. PocketDBA, which can currently be implemented on a Palm OS device and will soon be available for Pocket PCs, will appear for Microsoft's SQL Server and IBM's DB2 next year. Go to http://www.pocketdba.com for a demo. Fed up with ActiveSync Remember two weeks ago when I said that I did not want work-arounds to my problem in which ActiveSync did not recognize the USB ports on three separate computers (see Wireless World, June 18)? Here's a typical example of the e-mails I've received that prove my point. I had a similar but intermittent problem with my iPaq using ActiveSync on a Toshiba laptop, one reader wrote. I installed the Compaq ROM BIOS update last month and haven't seen the problem since. The update is Version 1.77, and you can download it from http://www.compaq.com/support/files/handhelds/us/download/9820.html. Also ActiveSync 3.1 (Build 9587) has some fixes for USB support. Build 9587 is available at http://www.microsoft.com/mobile/pocketpc/downloads/activesync.asp.; So what about the folks who can't complain in a public forum? Does anyone bother to tell them what build to use or where to download the correct BIOS version? Now I really want my money back. How about you? More on accidents and wireless alerts Despite the claim from automakers that batteries are rarely disabled in a collision, which they admit would disable the emergency wireless alert, I received numerous e-mails to the contrary. Read their views online. A few excerpts will suffice. The sign pole went through the grill and neatly sliced off a lower corner of my 5-day-old battery. Driving a '95 Porsche 911 Coupe, ... [the other] car hit me at a 90-degree angle. The impact cracked the battery case and cut off all electrical power to the car instantly. A pickup made a left turn right in front of us. ...The battery [in our Saturn] was crushed. In a low-speed collision, one of the battery cables fell into the path of the radiator fan. ... It was sheared in half. Driving a Volvo station wagon, ... [the] impact crushed the front of the car. I remember being surprised how flat the battery was. Nuff said. Write to me at [EMAIL PROTECTED] Ephraim Schwartz is an editor at large in InfoWorld's news department. Get this column free via e-mail each week. Sign up at http://www.iwsubscribe.com/newsletters. - - - - - - - - - - - - - - - - - - - - - - - - - - - - MORE WIRELESS WORLD For a complete archive of his InfoWorld columns visit http://www2.infoworld.com/cgi/component/columnarchive.wbs?column=wireless INFOWORLD OPINIONS Weekly commentary from the most trusted voices in IT at: http://www.infoworld.com/community/t_opinions.html - - - - - - - - - - - - - - - - - - - - - - - - - - - - QUOTE OF THE DAY: UCITA (the Uniform Computer Information Transaction Act) has been stopped in its tracks, and there are signs that the damage it has already caused might yet be undone --Ed Foster, crusading Gripe Line columnist, sees cause for hope. http://iwsun4.infoworld.com/articles/op/xml/01/07/02/010702opfoster.xml?0705 thwi - - - - - - - - - - - - - - - - - - - - - - - - - - - - SUBSCRIBE To subscribe to any of InfoWorld's e-mail newsletters, tell your friends and colleagues to go to: http://www.iwsubscribe.com/newsletters/ To subscribe to InfoWorld.com, or InfoWorld Print, or both, go to http://www.iwsubscribe.com UNSUBSCRIBE If you want to unsubscribe from InfoWorld's Newsletters, go to http://iwsubscribe.com/newsletters/unsubscribe/ CHANGE E-MAIL If you want to change the e-mail address where you are receiving InfoWorld
Re: Tracing Events - Anybody have a list of the Events?
Very cool, Thank You. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Scott Shafer sknd100@yahoTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] o.com cc: Sent by: Subject: Re: Tracing Events - Anybody have a list of the Events? root@fatcity. com 07/05/2001 11:51 AM Please respond to ORACLE-L Look near the end (~70% through) of the $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events. This is about all I could find. Anyone else? Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: Morning Folks - Hope those of you in the US had a safe and happy 4th - for those of you who didn't celebrate this particular holiday, hope your day was also safe and happy ( every day should be safe and happy!). I'm trying to set up some tracing for various events/levels. Not using OEM. In the past (and currently), I've just used: event=10046 trace name context forever,level 4 This of course provides the requisite information, but really can tell you much more than you want (or need) to know. The trace levels given on Metalink are: 1 - Enable standard SQL_TRACE functionality (Default) 4 - As Level 1 PLUS trace bind values 8 - As Level 1 PLUS trace waits However they state in multiple messages that: Events should be set only under the direction of Oracle Support and/or Development. Some events produce additional diagnostic information, others are intrusive into database operations, while others can effect data in the database. Syntax varies between events as does the meaning of the level. Oracle Support/Development will identify the proper syntax and level (if applicable) you should use. In my handy copy of Steve Adam's Oracle 8i internals, he gives three different trace events (one of which is a level 13 - what the heck is
Re: OT: Ari and his company have been noted in InfoWorld...
If only it were this simple: ..quantify the amount of time and money their companies would save if their DBAs.could remotely... remove from the database a user who is running a command that is holding up the system. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Grabowy, Chris To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cgrabowy@fcgcc: .comSubject: OT: Ari and his company have been noted in InfoWorld... Sent by: root@fatcity. com 07/05/2001 01:01 PM Please respond to ORACLE-L Ari and his company have been noted in InfoWorld... EPHRAIM SCHWARTZ Wireless World InfoWorld.com Thursday, July 5, 2001 REDUCING THE COST OF DBAS Posted at June 29, 2001 01:01 PM PST Pacific I'LL LEAVE IT to my readers to quantify the amount of time and money their companies would save if their DBAs (database administrators) could remotely, and wirelessly, make changes to their databases. Imagine the efficiencies in not having to call a DBA back to the office to add table space to a database, look at what indexes exist and modify table structures, give a new password to a user who has forgotten it, or remove from the database a user who is running a command that is holding up the system. You can accomplish these and many other corrective measures using the application PocketDBA, available from the company of the same name. I spoke with Ari Kaplan, CEO and co-founder of PocketDBA, in Chicago. His background includes 10 years at Oracle, where he oversaw the implementation of some of the largest Oracle database deployments in the world, such as Hallmark's Web site and Merck's entire order-entry and inventory system. Kaplan believes his company's wireless DBA package is more robust than Oracle's own desktop Enterprise Manager. PocketDBA, which can currently be implemented on a Palm OS device and will soon be available for Pocket PCs, will appear for Microsoft's SQL Server and IBM's DB2 next year. Go to http://www.pocketdba.com for a demo. Fed up with ActiveSync Remember two weeks ago when I said that I did not want work-arounds to my problem in which ActiveSync did not recognize the USB ports on three separate computers (see Wireless World, June 18)? Here's a typical example of the e-mails I've received that prove my point. I had a similar but intermittent problem with my iPaq using ActiveSync on a Toshiba laptop, one reader wrote. I installed the Compaq ROM BIOS update last month and haven't seen the problem since. The update is Version 1.77, and you can download it from http://www.compaq.com/support/files/handhelds/us/download/9820.html. Also ActiveSync 3.1 (Build 9587) has some fixes for USB support. Build 9587 is available at http://www.microsoft.com/mobile/pocketpc/downloads/activesync.asp.; So what about the folks who can't complain in a public forum? Does anyone bother to tell them what build to use or where to download the correct BIOS version? Now I really want my money back. How about you? More on accidents and wireless alerts Despite the claim from automakers that batteries are rarely disabled in a collision, which they admit would disable the emergency wireless alert, I received numerous e-mails to the
RE: ALTER SYNONYM?
Rick,
If your current process works for you, that's great!
My only thought was that, since you are already sqlloading the data, why not
right a PL/SQL procedure that would process the transactions into the
existing table.
For example, read a record from the sqlloader table, look for a matching
record in the FOO table. If found, either delete then insert the record, or
simply update the data. If not found, insert a new record.
This way, the existing table never disappears. Users keep on querying data
as if nothing is happening. Everybody is happy. You didn't mention how
many records you were talking about here, and that might impact whether this
is a good idea or not (if you are talking multi-millions of records, then
this is a bad idea! :) )
hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, July 05, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
Hi Rick,
How about creating a private synonym for FOO_A and a public synonym for
FOO_B. When you drop the private synonym, the public synonym takes effect
immediately, and when FOO_A is ready for usage again, you can create a new
private synonym. That way there's always a table available.
Just a thought ...
HTH, Remco
-Oorspronkelijk bericht-
Van: Rick Osterberg [mailto:[EMAIL PROTECTED]]
Verzonden: donderdag 5 juli 2001 18:06
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: ALTER SYNONYM?
Well, here's what I'm trying to do. I've got a pile of tables that are
read-only tables that are downloaded periodically (approximately daily)
from another system. They get slurped into our database via sqlloader.
A previous incarnation of this process had the setup run sqlloader on the
data table directly. The side-effect was that while it was being loaded,
the data in the table would disappear while the data was being loaded.
So the solution (obtained here, actually) was to have two tables FOO_A and
FOO_B, and have a synonym FOO that pointed to either FOO_A or FOO_B.
While FOO_A is live, then FOO_B gets loaded, and then the synonym
switches, so the new 'table' FOO appears instantly.
Needing to drop the synonym and recreate it is a two-step process... so
there is always the possibility someone will do a SELECT against FOO in
the instant between the operations. I'm trying to avoid that gap if
possible.
I'd like to stay away from a view, since these tables are heavily used for
reading, and are heavily indexed based on their usage... and a view would
certainly complicate that.
-Rick
On Mon, 2 Jul 2001, Jim Conboy wrote:
Can you use a view instead?
SVRMGR create table temp1 (temp1 varchar2(1));
Statement processed.
SVRMGR create table temp2 (temp1 varchar2(1));
Statement processed.
SVRMGR insert into temp1 values ('a');
1 row processed.
SVRMGR insert into temp1 values ('a');
1 row processed.
SVRMGR insert into temp1 values ('a');
1 row processed.
SVRMGR insert into temp1 values ('a');
1 row processed.
SVRMGR insert into temp2 values ('b');
1 row processed.
SVRMGR insert into temp2 values ('b');
1 row processed.
SVRMGR insert into temp2 values ('b');
1 row processed.
SVRMGR create or replace view temp as select * from temp1;
Statement processed.
SVRMGR select * from temp;
T
-
a
a
a
a
4 rows selected.
SVRMGR create or replace view temp as select * from temp2;
Statement processed.
SVRMGR select * from temp;
T
-
b
b
b
3 rows selected.
SVRMGR
Maybe some unwanted overhead with the view, but it might help out.
Jim
[EMAIL PROTECTED] 06/30/01 04:56PM
Is there a way to do what would be an ALTER SYNONYM?
I've got a synonym created that rotates between pointing to two different
tables. Sometimes it points to TABLE_A, sometimes to TABLE_B. (This is
so that behind the scenes, I can truncate and reload TABLE_A, and then
swap, etc. so the table never disappears.)
However, when I want to switch the SYNONYM from pointing to TABLE_A to
pointing to TABLE_B, the only way is to:
drop synonym table_syn;
create synonym table_syn for table_b;
Is there a way to make that instantaneous for the database? If someone
does a select at the exact instant between those two commands, it'll error
out, because the table won't exist.
-Rick
+--+
| Rick Osterberg [EMAIL PROTECTED]
|
| Database Applications Specialist FAS Computer Services
|
+--+
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rick Osterberg
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]
RE: Tracing Events - Anybody have a list of the Events?
Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 2:07 PM To: Multiple recipients of list ORACLE-L Subject: Re: Tracing Events - Anybody have a list of the Events? Very cool, Thank You. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Scott Shafer sknd100@yahoTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] o.com cc: Sent by: Subject: Re: Tracing Events - Anybody have a list of the Events? root@fatcity. com 07/05/2001 11:51 AM Please respond to ORACLE-L Look near the end (~70% through) of the $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events. This is about all I could find. Anyone else? Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: Morning Folks - Hope those of you in the US had a safe and happy 4th - for those of you who didn't celebrate this particular holiday, hope your day was also safe and happy ( every day should be safe and happy!). I'm trying to set up some tracing for various events/levels. Not using OEM. In the past (and currently), I've just used: event=10046 trace name context forever,level 4 This of course provides the requisite information, but really can tell you much more than you want (or need) to know. The trace levels given on Metalink are: 1 - Enable standard SQL_TRACE functionality (Default) 4 - As Level 1 PLUS trace bind values 8 - As Level 1 PLUS trace waits However they state in multiple messages that: Events should be set only under the direction of Oracle Support and/or Development. Some events produce additional diagnostic information, others are intrusive into database operations, while others can effect data in the database. Syntax varies between events as does the meaning of the level. Oracle Support/Development will identify the proper syntax and level (if applicable) you
How to precreate tables for migration?
So, We're taking the leap from 8.0.6 to 8.1.7. For various reasons, we will be using the export/import method of migration. Since I'll have the DB all to myself for the weekend, I want to also partition most of our larger tables (1M-7M rows each -- it's not a huge DB) in the migration. My plan to precreate the tables was to: 1) Export DB. 2) Create new 8.1.7 DB. 3) Create tablespaces. 4) Create partitioned tables. 5) Import DB. (I've left out many migration steps not pertinent to this question) Obviously, step 4 can't go before step 5, as step 5 creates the schemas. So, my questions: Has anyone precreated tables before a full import on a clean DB? Did you just manually precreate the schemas? How does the import deal with this (e.g. the DESTROY arg for imp)? Or would it be OK to skip step 4 and delete/rebuild the tables to be partitioned after the import had rebuilt them? I would prefer not to do the latter, seeing as this will be the first time in three years that the TSs will be nice and contiguous. :) Also, for brevity, we won't be going LMT for most of our TSs. Need too much time to plan for that... :( TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- 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: Tracing Events - Anybody have a list of the Events?
msG -Original Message- Sent: Thursday, July 05, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 2:07 PM To: Multiple recipients of list ORACLE-L Subject: Re: Tracing Events - Anybody have a list of the Events? Very cool, Thank You. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Scott Shafer sknd100@yahoTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] o.com cc: Sent by: Subject: Re: Tracing Events - Anybody have a list of the Events? root@fatcity. com 07/05/2001 11:51 AM Please respond to ORACLE-L Look near the end (~70% through) of the $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events. This is about all I could find. Anyone else? Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: Morning Folks - Hope those of you in the US had a safe and happy 4th - for those of you who didn't celebrate this particular holiday, hope your day was also safe and happy ( every day should be safe and happy!). I'm trying to set up some tracing for various events/levels. Not using OEM. In the past (and currently), I've just used: event=10046 trace name context forever,level 4 This of course provides the requisite information, but really can tell you much more than you want (or need) to know. The trace levels given on Metalink are: 1 - Enable standard SQL_TRACE functionality (Default) 4 - As Level 1 PLUS trace bind values 8 - As Level 1 PLUS trace waits However they state in multiple messages that: Events should be set only under the direction of Oracle Support and/or Development. Some events produce additional diagnostic information, others are intrusive into database operations, while others can effect data in the database. Syntax varies between events as does the meaning of the level. Oracle Support/Development will identify the proper syntax and
Re[2]: OT: Ari and his company have been noted in InfoWorld.
Where I am the amount is zero as we all have remote access from home already. What one can quantify is the amount of extra $ it costs for a VPN dial-up line vs. the wireless connectivity this monster requires. Now that comes to something (what I am not privy to), so good-bye PocketDBA. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/5/2001 10:21 AM If only it were this simple: ..quantify the amount of time and money their companies would save if their DBAs.could remotely... remove from the database a user who is running a command that is holding up the system. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Grabowy, Chris To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cgrabowy@fcgcc: .comSubject: OT: Ari and his company have been noted in InfoWorld... Sent by: root@fatcity. com 07/05/2001 01:01 PM Please respond to ORACLE-L Ari and his company have been noted in InfoWorld... EPHRAIM SCHWARTZ Wireless World InfoWorld.com Thursday, July 5, 2001 REDUCING THE COST OF DBAS Posted at June 29, 2001 01:01 PM PST Pacific I'LL LEAVE IT to my readers to quantify the amount of time and money their companies would save if their DBAs (database administrators) could remotely, and wirelessly, make changes to their databases. Imagine the efficiencies in not having to call a DBA back to the office to add table space to a database, look at what indexes exist and modify table structures, give a new password to a user who has forgotten it, or remove from the database a user who is running a command that is holding up the system. You can accomplish these and many other corrective measures using the application PocketDBA, available from the company of the same name. I spoke with Ari Kaplan, CEO and co-founder of PocketDBA, in Chicago. His background includes 10 years at Oracle, where he oversaw the implementation of some of the largest Oracle database deployments in the world, such as Hallmark's Web site and Merck's entire order-entry and inventory system. Kaplan believes his company's wireless DBA package is more robust than Oracle's own desktop Enterprise Manager. PocketDBA, which can currently be implemented on a Palm OS device and will soon be available for Pocket PCs, will appear for Microsoft's SQL Server and IBM's DB2 next year. Go to http://www.pocketdba.com for a demo. Fed up with ActiveSync Remember two weeks ago when I said that I did not want work-arounds to my problem in which ActiveSync did not recognize the USB ports on three separate computers (see Wireless World, June 18)? Here's a typical example of the e-mails I've received that prove my point. I had a similar but intermittent problem with my iPaq using ActiveSync on a Toshiba laptop, one reader wrote. I installed the Compaq ROM BIOS update last month and haven't seen the problem since. The update is Version 1.77, and you can download it from http://www.compaq.com/support/files/handhelds/us/download/9820.html. Also ActiveSync 3.1 (Build 9587) has some fixes for USB support. Build 9587 is available at http://www.microsoft.com/mobile/pocketpc/downloads/activesync.asp.; So what about the folks who
InterMedia Gurus
Any one you guys/dolls out there who are really using InterMedia, this one is for you Have you come across a good, single user scanner/OCR combo for putting hardcopy into a db under InterMedia? I have a bunch of dox i'd like to put on a CD or DVD, but want very high quality OCR and don't want to spend the next twelve thousand sidereal cycles scanning and correcting OCR input. So...what do you like? TIA, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: How to precreate tables for migration?
As I impose order on our servers, (moving from project-managed to dba-managed db's) I perform this sort of task for individual schemas. The short form is the same as yours except: 3.5) create schemas where tables or tablespace assignments will change. 4.5) create tables that are to have storage parameters different from the source. ... and ... 5) import using IGNORE=Y parameter Imp fills the tables as they exist, or creates them using the info in the export file where they do not exist. After all, if you're migrating all the tables you pre-created should be clean at the beginning, so you won't get duplicate rows and DESTROY is hardly necessary. One caveat -- IIRC you don't need to create all the tables, but you must create all the tablespaces in order to use this method. Or this could be a local effect as my new servers have different data file paths. It is useful to compose the creation in scripts, and compose a script to destroy the structures, in case your new storage parameters are flawed somehow and the import ends badly. That way you can iterate more easily. In my shop we move off the old server and into a test server first, then when the iterations are done I can replicate the refined procedure for production. In a few cases the project managers failed to move the db to production when they went live, so we move to different schemas on the same server first, then drop one and move the data (and client connections) to production. Jesse, Rich wrote: So, We're taking the leap from 8.0.6 to 8.1.7. For various reasons, we will be using the export/import method of migration. Since I'll have the DB all to myself for the weekend, I want to also partition most of our larger tables (1M-7M rows each -- it's not a huge DB) in the migration. My plan to precreate the tables was to: 1) Export DB. 2) Create new 8.1.7 DB. 3) Create tablespaces. 4) Create partitioned tables. 5) Import DB. (I've left out many migration steps not pertinent to this question) Obviously, step 4 can't go before step 5, as step 5 creates the schemas. So, my questions: Has anyone precreated tables before a full import on a clean DB? Did you just manually precreate the schemas? How does the import deal with this (e.g. the DESTROY arg for imp)? Or would it be OK to skip step 4 and delete/rebuild the tables to be partitioned after the import had rebuilt them? I would prefer not to do the latter, seeing as this will be the first time in three years that the TSs will be nice and contiguous. :) Also, for brevity, we won't be going LMT for most of our TSs. Need too much time to plan for that... :( TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- 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). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
RE: Tracing Events - Anybody have a list of the Events?
Only in UNIX -Original Message- Sent: Thursday, July 05, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 2:07 PM To: Multiple recipients of list ORACLE-L Subject: Re: Tracing Events - Anybody have a list of the Events? Very cool, Thank You. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Scott Shafer sknd100@yahoTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] o.com cc: Sent by: Subject: Re: Tracing Events - Anybody have a list of the Events? root@fatcity. com 07/05/2001 11:51 AM Please respond to ORACLE-L Look near the end (~70% through) of the $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events. This is about all I could find. Anyone else? Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: Morning Folks - Hope those of you in the US had a safe and happy 4th - for those of you who didn't celebrate this particular holiday, hope your day was also safe and happy ( every day should be safe and happy!). I'm trying to set up some tracing for various events/levels. Not using OEM. In the past (and currently), I've just used: event=10046 trace name context forever,level 4 This of course provides the requisite information, but really can tell you much more than you want (or need) to know. The trace levels given on Metalink are: 1 - Enable standard SQL_TRACE functionality (Default) 4 - As Level 1 PLUS trace bind values 8 - As Level 1 PLUS trace waits However they state in multiple messages that: Events should be set only under the direction of Oracle Support and/or Development. Some events produce additional diagnostic information, others are intrusive into database operations, while others can effect data in the database. Syntax varies between events as does the meaning of the level. Oracle Support/Development will identify the proper
Re: How to precreate tables for migration?
for precreatng the users, pull the create users statements out of the .dmp file. joe [EMAIL PROTECTED] 07/05/01 02:35PM So,We're taking the leap from 8.0.6 to 8.1.7. For various reasons, we will beusing the export/import method of migration.Since I'll have the DB all to myself for the weekend, I want to alsopartition most of our larger tables (1M-7M rows each -- it's not a huge DB)in the migration. My plan to precreate the tables was to: 1) Export DB. 2) Create new 8.1.7 DB. 3) Create tablespaces. 4) Create partitioned tables. 5) Import DB. (I've left out many migration steps not pertinent to this question)Obviously, step 4 can't go before step 5, as step 5 creates the schemas.So, my questions: Has anyone precreated tables before a full import on aclean DB? Did you just manually precreate the schemas? How does the importdeal with this (e.g. the DESTROY arg for imp)? Or would it be OK to skipstep 4 and delete/rebuild the tables to be partitioned after the import hadrebuilt them? I would prefer not to do the latter, seeing as this will bethe first time in three years that the TSs will be nice and contiguous. :)Also, for brevity, we won't be going LMT for most of our TSs. Need too muchtime to plan for that... :(TIA!Rich Jesse System/Database Administrator[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Tracing Events - Anybody have a list of the Events?
Try oraus.msg (if it exists). Sorry I don't have an NT install (woohoo! ;-) to check on... Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 2:07 PM To: Multiple recipients of list ORACLE-L Subject: Re: Tracing Events - Anybody have a list of the Events? Very cool, Thank You. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Look near the end (~70% through) of the $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events. This is about all I could find. Anyone else? Scott Shafer San Antonio, TX _ 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: Scott Shafer 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).
OT: Just chatter about Wireless costs and PocketDBA
While i don't shared DG's feelings about the size and resource consumption of the PocketDBA, I do share his feelings about the cost of the wireless access. Around here, Ricochet for the Palm PDA runs about 50$ a month or so. What bullsh*t! When I get wireless for an additional 10$ a month, I'll jump at it. Until then, if my company thinks RF'ing in with my PDA is any different than coming in with T1+ speed broadband, i am sure they'll let me know -Original Message- Sent: Thursday, July 05, 2001 2:57 PM To: Multiple recipients of list ORACLE-L Where I am the amount is zero as we all have remote access from home already. What one can quantify is the amount of extra $ it costs for a VPN dial-up line vs. the wireless connectivity this monster requires. Now that comes to something (what I am not privy to), so good-bye PocketDBA. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/5/2001 10:21 AM If only it were this simple: ..quantify the amount of time and money their companies would save if their DBAs.could remotely... remove from the database a user who is running a command that is holding up the system. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Grabowy, Chris To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cgrabowy@fcgcc: .comSubject: OT: Ari and his company have been noted in InfoWorld... Sent by: root@fatcity. com 07/05/2001 01:01 PM Please respond to ORACLE-L Ari and his company have been noted in InfoWorld... EPHRAIM SCHWARTZ Wireless World InfoWorld.com Thursday, July 5, 2001 REDUCING THE COST OF DBAS Posted at June 29, 2001 01:01 PM PST Pacific I'LL LEAVE IT to my readers to quantify the amount of time and money their companies would save if their DBAs (database administrators) could remotely, and wirelessly, make changes to their databases. Imagine the efficiencies in not having to call a DBA back to the office to add table space to a database, look at what indexes exist and modify table structures, give a new password to a user who has forgotten it, or remove from the database a user who is running a command that is holding up the system. You can accomplish these and many other corrective measures using the application PocketDBA, available from the company of the same name. I spoke with Ari Kaplan, CEO and co-founder of PocketDBA, in Chicago. His background includes 10 years at Oracle, where he oversaw the implementation of some of the largest Oracle database deployments in the world, such as Hallmark's Web site and Merck's entire order-entry and inventory system. Kaplan believes his company's wireless DBA package is more robust than Oracle's own desktop Enterprise Manager. PocketDBA, which can currently be implemented on a Palm OS device and will soon be available for Pocket PCs, will appear for Microsoft's SQL Server and IBM's DB2 next year. Go to http://www.pocketdba.com for a demo. Fed up with ActiveSync Remember two weeks ago when I said that I did not want work-arounds to my problem in which ActiveSync did not recognize the USB ports on three separate computers (see Wireless World, June 18)? Here's a typical example of the e-mails I've received that prove my point. I had a similar but intermittent problem with my iPaq using ActiveSync on a Toshiba laptop, one reader wrote. I installed the Compaq ROM BIOS update last month and haven't seen the problem since. The update is Version 1.77, and you can download it from http://www.compaq.com/support/files/handhelds/us/download/9820.html. Also ActiveSync 3.1 (Build 9587) has some fixes for USB support. Build 9587 is available at http://www.microsoft.com/mobile/pocketpc/downloads/activesync.asp.; So what about the folks who can't complain in a public forum? Does anyone bother to tell them what build to use or where to download the correct BIOS version? Now I really want my money back. How about you? More on accidents and wireless alerts Despite the claim from automakers that batteries are rarely disabled in a collision, which
RE: Re[2]: OT: Ari and his company have been noted in InfoWorld.
Well, we have remote access from home too, but it might be convenient to be able to do this stuff while I'm running from a grizzly in the Absarokas. That way I wouldn't have to hang around the house all weekend waiting for a call that might never come. Of course it's a moot point for us since (1) we're never on call here, and (2) there probably won't be wireless coverage in the Absarokas for another 200 years or so. --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Thursday, July 05, 2001 12:57 PM To: Multiple recipients of list ORACLE-L Where I am the amount is zero as we all have remote access from home already. What one can quantify is the amount of extra $ it costs for a VPN dial-up line vs. the wireless connectivity this monster requires. Now that comes to something (what I am not privy to), so good-bye PocketDBA. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/5/2001 10:21 AM If only it were this simple: ..quantify the amount of time and money their companies would save if their DBAs.could remotely... remove from the database a user who is running a command that is holding up the system. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt 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: Tracing Events - Anybody have a list of the Events?
Yeah, thanx all. It seems us poor NT users can't see the events list. We only rate an MSB file, not an MSG file. -Original Message- From: Scott Shafer [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 3:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Tracing Events - Anybody have a list of the Events? Try oraus.msg (if it exists). Sorry I don't have an NT install (woohoo! ;-) to check on... Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 2:07 PM To: Multiple recipients of list ORACLE-L Subject: Re: Tracing Events - Anybody have a list of the Events? Very cool, Thank You. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Look near the end (~70% through) of the $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events. This is about all I could find. Anyone else? Scott Shafer San Antonio, TX _ 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: Scott Shafer 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: 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[4]: OT: Ari and his company have been noted in InfoWorld.
Thursday, July 05, 2001, 3:40:31 PM, Walt Weaver wrote: WW Well, we have remote access from home too, but it might be convenient to be WW able to do this stuff while I'm running from a grizzly in the Absarokas. I hope I never have the opportunity to run from a grizzly. I once bumped (not literally) into a black bear while hiking. Mr. Bear just ignored me, though I was pretty spooked by the encounter. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick 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).
* Oracle DBA Needed in Phoenix..
If you're interested in a great opportunity, then consider this position in Phoenix, AZ with a leading company that needs an Oracle DBA to join its' I.T. staff. We would like to submit someone who is a renter and who is interested in Phoenix but has not applied to Phoenix companies and is not working with other recruiters for Phoenix companies. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. * Requirements: - A degree in C.S. or equivalent - 3+ yrs Oracle DBA experience is needed - Strong Unix - Application development experience; Unix scripting; C or Perl languages are desirable - Must have good communication skills -U.S. citizenship or permanent residency required This position is with a company that offers : * Quality Work Environment * Base salary up to 75K-firm +excellent benefits * Financial Stability * Some Relocation Assistance NO sub contracting positions available. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume to: Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. * Please use job code: One/Phoenix/DBA/Carlos We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law OraStaff, Inc-The Proven Connection To Oracle Opportunity -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Re[2]: OT: Ari and his company have been noted in InfoWorld.
We did something similar to this 4 years ago using the 2 way pagers, email, home grown algorithm similar to secure key(give me a number and I'll check to see if it's the correct sequence), and a heck of a lot of PERL programming. So IF WE HAD COVERAGE on the 2-way pager(RIM pager using bellsouth's paging network)-it didn't require a lot of $$$. Shoot Walt-it may have had coverage in Absarokas ;-) Greg -Original Message- Sent: Thursday, July 05, 2001 3:41 PM To: Multiple recipients of list ORACLE-L InfoWorld. Well, we have remote access from home too, but it might be convenient to be able to do this stuff while I'm running from a grizzly in the Absarokas. That way I wouldn't have to hang around the house all weekend waiting for a call that might never come. Of course it's a moot point for us since (1) we're never on call here, and (2) there probably won't be wireless coverage in the Absarokas for another 200 years or so. --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Thursday, July 05, 2001 12:57 PM To: Multiple recipients of list ORACLE-L Where I am the amount is zero as we all have remote access from home already. What one can quantify is the amount of extra $ it costs for a VPN dial-up line vs. the wireless connectivity this monster requires. Now that comes to something (what I am not privy to), so good-bye PocketDBA. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/5/2001 10:21 AM If only it were this simple: ..quantify the amount of time and money their companies would save if their DBAs.could remotely... remove from the database a user who is running a command that is holding up the system. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt 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: Loughmiller, Greg 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).
SQL ERROR--Nebulous definition
I have some simple procedures in a DEV instance that run just fine (e.g. enable_constraints, drop_table, insert_data). When I import them into the PROD instance, they won't compile stating that PROCEDURE ROSTERDBA.DROP_TABLE On line: 7 PLS-00201: identifier 'SYS.DBMS_SQL' must be declared. I am not sure what this is telling me--any ideas? I am exporting as one user then importing as another--but all activity does occur within its own schema. thanks, lc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa Clary 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: How to precreate tables for migration?
Hey Don! GREAT info! I'm wiping out my test DB right now to try it out. I already have the scripts to create the TSs (I've learned a little in three years), so that's no biggie. I'll letcha know what happens. THANKS! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, July 05, 2001 14:11 To: Multiple recipients of list ORACLE-L As I impose order on our servers, (moving from project-managed to dba-managed db's) I perform this sort of task for individual schemas. The short form is the same as yours except: 3.5) create schemas where tables or tablespace assignments will change. 4.5) create tables that are to have storage parameters different from the source. ... and ... 5) import using IGNORE=Y parameter Imp fills the tables as they exist, or creates them using the info in the export file where they do not exist. After all, if you're migrating all the tables you pre-created should be clean at the beginning, so you won't get duplicate rows and DESTROY is hardly necessary. One caveat -- IIRC you don't need to create all the tables, but you must create all the tablespaces in order to use this method. Or this could be a local effect as my new servers have different data file paths. It is useful to compose the creation in scripts, and compose a script to destroy the structures, in case your new storage parameters are flawed somehow and the import ends badly. That way you can iterate more easily. In my shop we move off the old server and into a test server first, then when the iterations are done I can replicate the refined procedure for production. In a few cases the project managers failed to move the db to production when they went live, so we move to different schemas on the same server first, then drop one and move the data (and client connections) to production. -- 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: ALTER SYNONYM?
Rick Osterberg wrote:
Well, here's what I'm trying to do. I've got a pile of tables that are
read-only tables that are downloaded periodically (approximately daily)
from another system. They get slurped into our database via sqlloader.
A previous incarnation of this process had the setup run sqlloader on the
data table directly. The side-effect was that while it was being loaded,
the data in the table would disappear while the data was being loaded.
So the solution (obtained here, actually) was to have two tables FOO_A and
FOO_B, and have a synonym FOO that pointed to either FOO_A or FOO_B.
While FOO_A is live, then FOO_B gets loaded, and then the synonym
switches, so the new 'table' FOO appears instantly.
Needing to drop the synonym and recreate it is a two-step process... so
there is always the possibility someone will do a SELECT against FOO in
the instant between the operations. I'm trying to avoid that gap if
possible.
I'd like to stay away from a view, since these tables are heavily used for
reading, and are heavily indexed based on their usage... and a view would
certainly complicate that.
-Rick
On Mon, 2 Jul 2001, Jim Conboy wrote:
Can you use a view instead?
SVRMGR create table temp1 (temp1 varchar2(1));
Statement processed.
SVRMGR create table temp2 (temp1 varchar2(1));
Statement processed.
SVRMGR insert into temp1 values ('a');
1 row processed.
SVRMGR insert into temp1 values ('a');
1 row processed.
SVRMGR insert into temp1 values ('a');
1 row processed.
SVRMGR insert into temp1 values ('a');
1 row processed.
SVRMGR insert into temp2 values ('b');
1 row processed.
SVRMGR insert into temp2 values ('b');
1 row processed.
SVRMGR insert into temp2 values ('b');
1 row processed.
SVRMGR create or replace view temp as select * from temp1;
Statement processed.
SVRMGR select * from temp;
T
-
a
a
a
a
4 rows selected.
SVRMGR create or replace view temp as select * from temp2;
Statement processed.
SVRMGR select * from temp;
T
-
b
b
b
3 rows selected.
SVRMGR
Maybe some unwanted overhead with the view, but it might help out.
Jim
[EMAIL PROTECTED] 06/30/01 04:56PM
Is there a way to do what would be an ALTER SYNONYM?
I've got a synonym created that rotates between pointing to two different
tables. Sometimes it points to TABLE_A, sometimes to TABLE_B. (This is
so that behind the scenes, I can truncate and reload TABLE_A, and then
swap, etc. so the table never disappears.)
However, when I want to switch the SYNONYM from pointing to TABLE_A to
pointing to TABLE_B, the only way is to:
drop synonym table_syn;
create synonym table_syn for table_b;
Is there a way to make that instantaneous for the database? If someone
does a select at the exact instant between those two commands, it'll error
out, because the table won't exist.
-Rick
Rick,
It may be a stupid idea but have you considered the possibilities
opened by partitioned tables? Exchanging partitions and the like? It is
not impossible that you could load and then swap in a single DDL
statement - which is what you are after. Not sure it works (too lazy to
read the doc) but worth a look IMHO.
--
Regards,
Stephane Faroult
Oriole Corporation
Voice: +44 (0) 7050-696-269
Fax:+44 (0) 7050-696-449
Performance Tools Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
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:OT: Just chatter about Wireless costs and PocketDBA
Ross, What I was talking about is the added expense of wireless connectivity for a PDA. Personally I don't own a PDA and have no desire to do so. Dick Goulet Reply Separator Author: Mohan; Ross [EMAIL PROTECTED] Date: 7/5/2001 11:19 AM While i don't shared DG's feelings about the size and resource consumption of the PocketDBA, I do share his feelings about the cost of the wireless access. Around here, Ricochet for the Palm PDA runs about 50$ a month or so. What bullsh*t! When I get wireless for an additional 10$ a month, I'll jump at it. Until then, if my company thinks RF'ing in with my PDA is any different than coming in with T1+ speed broadband, i am sure they'll let me know -Original Message- Sent: Thursday, July 05, 2001 2:57 PM To: Multiple recipients of list ORACLE-L Where I am the amount is zero as we all have remote access from home already. What one can quantify is the amount of extra $ it costs for a VPN dial-up line vs. the wireless connectivity this monster requires. Now that comes to something (what I am not privy to), so good-bye PocketDBA. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/5/2001 10:21 AM If only it were this simple: ..quantify the amount of time and money their companies would save if their DBAs.could remotely... remove from the database a user who is running a command that is holding up the system. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Grabowy, Chris To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cgrabowy@fcgcc: .comSubject: OT: Ari and his company have been noted in InfoWorld... Sent by: root@fatcity. com 07/05/2001 01:01 PM Please respond to ORACLE-L Ari and his company have been noted in InfoWorld... EPHRAIM SCHWARTZ Wireless World InfoWorld.com Thursday, July 5, 2001 REDUCING THE COST OF DBAS Posted at June 29, 2001 01:01 PM PST Pacific I'LL LEAVE IT to my readers to quantify the amount of time and money their companies would save if their DBAs (database administrators) could remotely, and wirelessly, make changes to their databases. Imagine the efficiencies in not having to call a DBA back to the office to add table space to a database, look at what indexes exist and modify table structures, give a new password to a user who has forgotten it, or remove from the database a user who is running a command that is holding up the system. You can accomplish these and many other corrective measures using the application PocketDBA, available from the company of the same name. I spoke with Ari Kaplan, CEO and co-founder of PocketDBA, in Chicago. His background includes 10 years at Oracle, where he oversaw the implementation of some of the largest Oracle database deployments in the world, such as Hallmark's Web site and Merck's entire order-entry and inventory system. Kaplan believes his company's wireless DBA package is more robust than Oracle's own desktop Enterprise Manager. PocketDBA, which can currently be implemented on a Palm OS device and will soon be available for Pocket PCs, will appear for Microsoft's SQL Server and IBM's DB2 next year. Go to http://www.pocketdba.com for a demo. Fed up with ActiveSync Remember two weeks ago when I said that I did not want work-arounds to my problem in which ActiveSync did not recognize the USB ports on three separate computers (see Wireless World, June 18)? Here's a typical example of the e-mails I've received that prove my point. I had a similar but intermittent problem with my iPaq using ActiveSync on a Toshiba laptop, one reader wrote. I installed the Compaq ROM BIOS update last month and haven't seen the problem since. The update is Version 1.77, and you can download it from http://www.compaq.com/support/files/handhelds/us/download/9820.html. Also ActiveSync 3.1 (Build 9587) has some fixes for USB support. Build 9587 is available at http://www.microsoft.com/mobile/pocketpc/downloads/activesync.asp.; So what about the folks who can't complain in a
Sorry---I figured it out.....FW: SQL ERROR--Nebulous definition
Sorry for wasting the bandwidth lc -Original Message- Sent: Thursday, July 05, 2001 4:00 PM To: ORACLE-L@fatcity. com Cc: Lisa R Clary I have some simple procedures in a DEV instance that run just fine (e.g. enable_constraints, drop_table, insert_data). When I import them into the PROD instance, they won't compile stating that PROCEDURE ROSTERDBA.DROP_TABLE On line: 7 PLS-00201: identifier 'SYS.DBMS_SQL' must be declared. I am not sure what this is telling me--any ideas? I am exporting as one user then importing as another--but all activity does occur within its own schema. thanks, lc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa Clary 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).
Strange explain plan
Hi all. I'm having problems with the following query: select a1.MBR_TYP_CDE MBR_TYP_CDE, (COUNT ( DISTINCT a1.NOVS_NTWRK_MBR_KYD )) from MDSS_STAR.NOVUS_NETWRK_MBR_D a1 group by a1.MBR_TYP_CDE It fails with ora-06000 (parameter 15851). I have noticed that if I created the new table NOVUS_NETWRK_MBR_D_tmp as select * from NOVUS_NETWRK_MBR_D the query runs with no issues. I have compared the explain plans for the two queries and here what i saw. This is the plan for the query that runs OK 0-0-9721 1.9721 SELECT STATEMENTSQL1 Cost = 9721 1-0-1 2.1 SORT GROUP BY 2-1-1 3.1 TABLE ACCESS FULL NOVUS_NETWRK_MBR_D_TMP This is the plan for the query that fails. 0-0-5898 1.5898 SELECT STATEMENTSQL1 Cost = 5898 1-0-1 2.1 SORT GROUP BY 2-1-1 3.1 SORT GROUP BY 3-2-14.1 SORT GROUP BY 4-3-1 5.1 TABLE ACCESS FULL NOVUS_NETWRK_MBR_D I can't understand why would oracle do three sorts on that query. May be this is somehow related to my ora-0600. If someone has any ideas as to what can be going on here I would really appreciate it. We are running oracle 817 in ops on 4.3.3 IBM SP/2 thanks in advance Gene = __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich 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: OT: Ari and his company have been noted in InfoWorld.
I for one think Ari and his company need to be commended. In the future you and I will be capable of admin'ing and monitoring multiple databases via handhelds. Larger consulting companies will likely have teams of DBA's that are responsible for large pools of databases. New databases will be added to the monitoring pools within minutes. Ari is breaking the ground for the future. When faced with any technology and attempting to figure out where it is going to go think Matrix or Star Trek. Sure these types of things are a long way off but it is the way things will go. Database administrators will eventually go the way of train conductors. The DBA for the year 2010 will not at all resemble the DBA of 2001. - Ethan Post - http://www.geocities.com/epost1 -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Re[2]: OT: Ari and his company have been noted in InfoWorld.
and 3) if you are working on that stuff while running from a grizzly you are either planning on getting killed or a REALLY fast runner able to concentrate on many things at once in the face of death From: Weaver, Walt [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Re[2]: OT: Ari and his company have been noted in InfoWorld. Date: Thu, 05 Jul 2001 11:40:32 -0800 Well, we have remote access from home too, but it might be convenient to be able to do this stuff while I'm running from a grizzly in the Absarokas. That way I wouldn't have to hang around the house all weekend waiting for a call that might never come. Of course it's a moot point for us since (1) we're never on call here, and (2) there probably won't be wireless coverage in the Absarokas for another 200 years or so. --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Thursday, July 05, 2001 12:57 PM To: Multiple recipients of list ORACLE-L Where I am the amount is zero as we all have remote access from home already. What one can quantify is the amount of extra $ it costs for a VPN dial-up line vs. the wireless connectivity this monster requires. Now that comes to something (what I am not privy to), so good-bye PocketDBA. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/5/2001 10:21 AM If only it were this simple: ..quantify the amount of time and money their companies would save if their DBAs.could remotely... remove from the database a user who is running a command that is holding up the system. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt 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: SQL ERROR--Nebulous definition
Title: RE: SQL ERROR--Nebulous definition It's saying that execute permissions on sys.dbms_sql must be granted to ROSTERDBA Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original Message- From: Lisa Clary [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 5:00 PM To: Multiple recipients of list ORACLE-L Subject: SQL ERROR--Nebulous definition I have some simple procedures in a DEV instance that run just fine (e.g. enable_constraints, drop_table, insert_data). When I import them into the PROD instance, they won't compile stating that PROCEDURE ROSTERDBA.DROP_TABLE On line: 7 PLS-00201: identifier 'SYS.DBMS_SQL' must be declared. I am not sure what this is telling me--any ideas? I am exporting as one user then importing as another--but all activity does occur within its own schema. thanks, lc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa Clary 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: * Oracle DBA Needed in Phoenix..
Thursday, July 05, 2001, 4:15:20 PM, you wrote: O We would like to submit someone who is a renter and who is interested O in Phoenix but has not applied to Phoenix companies and is not working with O other recruiters for Phoenix companies. Now why in the world would any of this matter? Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick 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).
can/do indexes chain?
I've been asked to create an index which combines two fields, date location. For reasons I don't really want to explain, we need/desire this index to be in the order of date, location. The minor gotcha is that while location will be populated at the time the record is created, the date field is not updated until a later point in time. This date is a document print date. So this date field will be going from a NULL value to a non-null value. I recognize that this can result in record chaining in the data table. In thinking about this, I realized this could have a similar affect within the index. However, I've never read anything about index chaining. Do/can indexes chain? Should I be concerned about this? -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 .NET? Not yet!San Diego, CA 92131 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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: OT: Just chatter about Wireless costs and PocketDBA
But you can play games on them. I actually used to think the same way until the company agreed to by me one. Since I use Outlook so much they are actually quite nice to have. Now, instead of carrying a day timer I carry a Palm. Makes life easier for me. Now I am going to go get the software to hook it up to my GPS. -Original Message- Sent: Thursday, July 05, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Ross, What I was talking about is the added expense of wireless connectivity for a PDA. Personally I don't own a PDA and have no desire to do so. Dick Goulet Reply Separator Author: Mohan; Ross [EMAIL PROTECTED] Date: 7/5/2001 11:19 AM While i don't shared DG's feelings about the size and resource consumption of the PocketDBA, I do share his feelings about the cost of the wireless access. Around here, Ricochet for the Palm PDA runs about 50$ a month or so. What bullsh*t! When I get wireless for an additional 10$ a month, I'll jump at it. Until then, if my company thinks RF'ing in with my PDA is any different than coming in with T1+ speed broadband, i am sure they'll let me know -Original Message- Sent: Thursday, July 05, 2001 2:57 PM To: Multiple recipients of list ORACLE-L Where I am the amount is zero as we all have remote access from home already. What one can quantify is the amount of extra $ it costs for a VPN dial-up line vs. the wireless connectivity this monster requires. Now that comes to something (what I am not privy to), so good-bye PocketDBA. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/5/2001 10:21 AM If only it were this simple: ..quantify the amount of time and money their companies would save if their DBAs.could remotely... remove from the database a user who is running a command that is holding up the system. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Grabowy, Chris To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cgrabowy@fcgcc: .comSubject: OT: Ari and his company have been noted in InfoWorld... Sent by: root@fatcity. com 07/05/2001 01:01 PM Please respond to ORACLE-L Ari and his company have been noted in InfoWorld... EPHRAIM SCHWARTZ Wireless World InfoWorld.com Thursday, July 5, 2001 REDUCING THE COST OF DBAS Posted at June 29, 2001 01:01 PM PST Pacific I'LL LEAVE IT to my readers to quantify the amount of time and money their companies would save if their DBAs (database administrators) could remotely, and wirelessly, make changes to their databases. Imagine the efficiencies in not having to call a DBA back to the office to add table space to a database, look at what indexes exist and modify table structures, give a new password to a user who has forgotten it, or remove from the database a user who is running a command that is holding up the system. You can accomplish these and many other corrective measures using the application PocketDBA, available from the company of the same name. I spoke with Ari Kaplan, CEO and co-founder of PocketDBA, in Chicago. His background includes 10 years at Oracle, where he oversaw the implementation of some of the largest Oracle database deployments in the world, such as Hallmark's Web site and Merck's entire order-entry and inventory system. Kaplan believes his company's wireless DBA package is more robust than Oracle's own desktop Enterprise Manager. PocketDBA, which can currently be implemented on a Palm OS device and will soon be available for Pocket PCs, will appear for Microsoft's SQL Server and IBM's DB2 next year. Go to http://www.pocketdba.com for a demo. Fed up with ActiveSync Remember two weeks ago when I said that I did not want work-arounds to my problem in which ActiveSync did not recognize the USB ports on three separate computers (see Wireless World, June 18)? Here's a typical example of the e-mails I've received that prove my point. I had a similar but intermittent problem with my iPaq using ActiveSync on a Toshiba laptop, one
RE: * Oracle DBA Needed in Phoenix..
Ditto. This 'renter' thing sounds like some sort of thinly veiled discrimination. -Original Message- Sent: Thursday, July 05, 2001 2:41 PM To: Multiple recipients of list ORACLE-L Thursday, July 05, 2001, 4:15:20 PM, you wrote: O We would like to submit someone who is a renter and who is interested O in Phoenix but has not applied to Phoenix companies and is not working with O other recruiters for Phoenix companies. Now why in the world would any of this matter? Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick 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: John 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: * Oracle DBA Needed in Phoenix..
On 07/05/2001 3:41:08 PM, Jonathan Gennick is quoted as saying: . . . .|Thursday, July 05, 2001, 4:15:20 PM, you wrote: . . . .|O We would like to submit someone who is a renter and who is interested . . . .|O in Phoenix but has not applied to Phoenix companies and is not working with . . . .|O other recruiters for Phoenix companies. . . . .| . . . .|Now why in the world would any of this matter? They are trying to get more people into Phoenix, and they have invested in apartment buildings. But seriously that is kinda weird. . . . .| www.nul.cjb.net www.FreeBSD.org _ 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: Peter 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: OT: Ari and his company have been noted in InfoWorld.
I wonder if a similar thought was echoed in 1991? Maybe all of the DBAs that were former DB2, etc DBAs could offer some war stories here. It's funny that databases have become more cumbersome to manage, not easier IMHO. DBAs have to understand more technologies that are outside the RDBMS box than ever before. Every time we get a new version it gets a little more complicated to manage. I suppose we should just put everything in autoextend mode, oversize the SGA and other memory structures and we would be able to manage 1000's of databases. Not likely now, or ever for that matter. All of the quick fixes leave out one particular fact: All databases are unique and have their share of unique problems. Thank goodness for that! I can't wait to take a vacation and recover a standby database while adrift on the ocean. It gives Cast Away a whole new meaning! :)) --Michael -Original Message- Sent: Thursday, July 05, 2001 5:25 PM To: Multiple recipients of list ORACLE-L I for one think Ari and his company need to be commended. In the future you and I will be capable of admin'ing and monitoring multiple databases via handhelds. Larger consulting companies will likely have teams of DBA's that are responsible for large pools of databases. New databases will be added to the monitoring pools within minutes. Ari is breaking the ground for the future. When faced with any technology and attempting to figure out where it is going to go think Matrix or Star Trek. Sure these types of things are a long way off but it is the way things will go. Database administrators will eventually go the way of train conductors. The DBA for the year 2010 will not at all resemble the DBA of 2001. - Ethan Post - http://www.geocities.com/epost1 -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Jenkins, Michael 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).
