NT SCheduler !!

Hello Guru, I want to run one batch in Windowns NT using At scheduler. Thw question is : a) There will be a start time end time ...say 7PM 12 PM b) Want to run the batch say in every hour (Have a fixed Interval time ) c)want to repeat step a b everyday I am facing

RE: Materialized View over 2 tables

Title: Materialized View over 2 tables Thats not a problem. That is well-documented feature and you can check it with standard documents. Fast Refreshes are meant only for simple MVs/Snapshots and not for complex ones. You are supposed to do a complete refresh for complex ones.

RE: How can I tell if a procedure/package is running?

Hi Rahul, Ah, I see. You're looking at KGLHDLMD instead of KGLHDPMD. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.secularislam.org/call.htm - For Muslims @ http://www.christianity.net.au/ - For all -Original Message-

Alter different session

Hello Is it possible to alter different session or can I change parameters only of my own session (using 'alter session ...') What priviledges do I need to do it? Is there a procedure to do it? (like dbms_system.set_ev for events) Kind regards Ivo Libal -- Please see the official ORACLE-L

RE: How can I tell if a procedure/package is running?

i guess KGLHDLMD is lock Mode ? and KGLHDPMD = mode pinned ? -- From: Steve Adams[SMTP:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 3:51 PM To: Rahul; Multiple recipients of list ORACLE-L Subject: RE: How can I tell if a procedure/package is running?

RE: How can I tell if a procedure/package is running?

Title: RE: How can I tell if a procedure/package is running? Hi adams What should i get details of X$ tables. How much these tables are important as a DBA.. Rgds, Nirmal, -Original Message- From: Steve Adams [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001

use of varray in Standard Engine

Is the use of varray compatible with 8.1.7 Standard Engine? e.g type batch_identifier_array IS VARRAY(9) of VARCHAR2(20); MY PL/SQL manual(for 8.0.5) says that Enterprise Edition is required to use varray. Surely there is a method of using arrays in PL/SQL even in Standard Engine? John --

RE: NT SCheduler !!

Hi Saroj, As per my knowledge you cannot specify interval in at command . but you can add multiple entries in at command like at \\machinename 8:00 /interactive /every:M,T,W,Th,F,S at \\machinename 9:00 /interactive /every:M,T,W,Th,F,S hope it will solve ur prblm. Kranti

Re: export database with Query option

Thanxs Venkat. I was missing where in the query option. It's done now. Neel -- Original Text -- Try this exp scott/tiger tables=emp query=\where sal=2000 \ Venkat -- On Mon, 29 Oct 2001 22:15:18 nshah wrote: Hi, Can you help me, regarding oracle export database utility

Re: export database with Query option

- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 30, 2001 08:15 Hi, Can you help me, regarding oracle export database utility with Query option. I am trying to export the employee table which has sal 2000. exp scott/tiger

bizarre AQ problem

Hello, I'm having a very strange AQ problem, and I can't for the life of me work out what's going wrong. The platform is Solaris 2.6 and 2.8, Oracle 8.1.7.2, C++ OCI application compiled with SunPro. There is a table with about a dozen columns, one of which is a primary key. The application does

RE: Oracle 7 documentation - Good One

Dear All, I hit upon this site. I thought its worth sharing http://docs.oracle.com/ Venkat -- On Fri, 19 Oct 2001 06:25:21 Deshpande, Kirti wrote: It is hiding at http://technet.oracle.com/doc/server734.htm Regards, - Kirti Deshpande Verizon Information Services

RE: NOT IN with NULL-values

Title: RE: NOT IN with NULL-values Yes I had a null value in am91. rgds amar -Original Message- From: Kuijten, F. (Frank) [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 6:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: NOT IN with NULL-values Amar,

RE: NOT IN with NULL-values

Title: RE: NOT IN with NULL-values Sorry Frank, I tried that without null. I cross checked and found results for not in similar to yours, as explained by other list members. null is not equal to another value, or null itself. rgds amar -Original Message- From: Kuijten, F. (Frank)

RE: How can I tell if a procedure/package is running?

Hi Nirmal, There is some information about the X$ tables available on the Ixora web site. However, knowledge of the X$ tables is not really important for most DBAs. They are only useful in rare, advanced tuning and diagnostic situations. @ Regards, @ Steve Adams @ http://www.ixora.com.au/

RE: Spam - Re: Oracle Training from InterTrain

Be sure to add them to the OT list for some alternative reading!! Dave -Original Message- Sent: Monday, October 29, 2001 7:45 PM To: Multiple recipients of list ORACLE-L In the future, if we get a spam like this, may I suggest we add that person to our mailing list? This way we SPAM

RE: 11.5.5 on Tru64

Title: Cursor Variable question Form what I understand, if you are on 11.5.3+, you will be using a single apache server. Early releases of 11i, used WebDB and Apache. Dave -Original Message-From: Bellows, Bambi [mailto:[EMAIL PROTECTED]]Sent: Monday, October 29, 2001 4:43

Internal error code problem

Hi friends, I am running a package in my application and i got the following error message . ORA-00600: internal error code, arguments: [kcbgtcr_4], [], [], [], [], [], [], [] Can anyone throw up some points on this , basically what would have went wrong. Thanks in advance Shankar

Re:RE: RE: Network Appliance

Alan, A little leery is a lot safe!.. Dick Goulet Reply Separator Author: Aschenbrenner; Alan [EMAIL PROTECTED] Date: 10/29/2001 3:55 PM Dick, I believe that's the way it was setup. But, ever since they installed the patch on the netapp,

Re: Data warehouse on Win2K

We asked for a better SUN machine or CPUs for the current warehouse which uses SUN E6000 167MHZ CPUS. Well management thinks since we already have few OLTP databases running fine on WIN2K why not look at that. --- [EMAIL PROTECTED] wrote: Afraid I'm not going to be much help. I

Re[2]: Spam - Re: Oracle Training from InterTrain

Yeah, but what if it's real spam where they faked their address? Then we have to live with all of the bounced messages. Darn ugly way to get back at them. Dick Goulet Reply Separator Author: Richard Ji [EMAIL PROTECTED] Date: 10/29/2001 5:45 PM

RE: 11.5.5 on Tru64

Bambi, John is right ! You'll get better response to Apps questions on the Apps list. We have a 11.5.5 test instance (upgraded from 11.5.4) running on Compaq TRU64 4.0F. The upgrade was not pretty, but so far we have not found any major issues. Did you have any specific questions about

Hosing of Data Dict by catalog.sql

Greetings fellow DBAs, I have one small Oracle8i (8.1.6) database (noarchivelog mode) installation on a Windows/NT 4 box to which I believe I have done some serious damage. Long story short - I inadvertently kicked off the build script for the database which lives there. The first thing the

Re: Hosing of Data Dict by catalog.sql

I would try to just re-run catalog.sql first. [EMAIL PROTECTED] 10/30/01 09:15AM Greetings fellow DBAs, I have one small Oracle8i (8.1.6) database (noarchivelog mode) installation on a Windows/NT 4 box to which I believe I have done some serious damage. Long story short - I inadvertently

RE: Hosing of Data Dict by catalog.sql

Title: RE: Hosing of Data Dict by catalog.sql I would have thought that you would be OK if you ran the following @?/rdbms/admin/catalog.sql @?/rdbms/admin/catproc.sql @?/rdbms/admin/catparr.sql @?/rdbms/admin/catexp.sql @?/rdbms/admin/dbmspipe.sql @?/rdbms/admin/dbmspool.sql

RE: Hosing of Data Dict by catalog.sql

Title: RE: Hosing of Data Dict by catalog.sql Hi James, Been there, done that... As long as your database names are not hosed (check v$database) and you haven't lost any data you may be OK. Try running catalog.sql in it's entirety. If it doesn't fix your problem, restore from backup.

RE: Internal error code problem

Shankar This is not an error caused directly by your package. It is an internal Oracle error, otherwise known as a BUG. The first argument normally gives a clue as to what is going on, and a further investigation of the stack trace in the trace file shows which area of the code this is in. In

Re: Hosing of Data Dict by catalog.sql

James, I believe there is a fix listed for this on Metalink. Search Metalink for the exact text of the 4045 error. Include the object name text in the search. I think there is an /rdbms/admin/ script that needs to be run and some manual steps to take. If memory serves me right, we had

recovery database!!

Hi gurus, question?? I can recovery any database with only datafiles??? @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática

RE: Server Requirements

Alon - The key question isn't the size of the database, but the amount of transaction activity. I may have a database that is extremely large, but relatively dormant, and a pretty small server can handle it. On the other hand, I might have a rather small database with intense update activity and

RE: Materialized View over 2 tables

Helmut, Rajesh is absolutely correct. If one or more of the base tables are in a remote db then the fast refresh restrictions in the Replication manual apply; if all the base tables are local then the fast refresh restrictions in the Data Warehousing manual apply. A workaround would be to

Re: recovery database!!

Hmmm, sorry but I will have to say depends on the situation. Can you be a little more specific? Otherwise I would recommend the Oracle Backup and Recovery Handbook. Richard [EMAIL PROTECTED] 10/30/01 10:30AM Hi gurus, question?? I can recovery any database with only datafiles??? @lex

Table conflicts

The administrator on our ERP system is concerned that we may be getting table locking problems (where a process has to wait until a row lock is released by another process). We have recently received ORA-00060 errors (the one where Oracle inserts the text The following deadlock is not an ORACLE

Identifying user and locked table row in Oracle 8i

Hi, I am facing a locking problem with Forms 6i and Oracle 8iR3 that did not occure with Oracle 8iR2. To pinpoint the problem, I would need to identify the locking user AND the specific record that causes the problem. Does some of you possibly have a script that I can let our customer run when

RE: recovery database!!

ok i need know is possible recover the database with only the datafile. If only have a datafiles the any database i can recreate a new db and use this datafiles... @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro

Re: Data warehouse on Win2K

Typical damagers at work. Why would you move a functioning DW from an E6000 to a win2k box? Doesn't make a lot of sense. Since your exec's obviously don't think the E6000 is capable, tell them I'll give them $100 plus shipping for it. :) Jared

RE: Root to connect as system

That should not be necessary. If it is, then Oracle is not installed properly. Oracle should not be owned by root. It is typically owned by an account of 'oracle'. You really should reinstall the software. Jared

RE: Data warehouse on Win2K

I'll make that $200 + s/h -Original Message- [EMAIL PROTECTED] Sent: Tuesday, October 30, 2001 12:15 PM To: Multiple recipients of list ORACLE-L Typical damagers at work. Why would you move a functioning DW from an E6000 to a win2k box? Doesn't make a lot of sense. Since your

RE: Oracle 7 documentation - Good One

Thanks for sharing this! Finally, complete documentation for Oracle 7 on. Jared C.S.Venkata

purge log issues

I have a table with too many rows to perform a complete refresh on so I set up a snapshot with fast refreshes and everything worked well. However, my snapshot log keeps growing and never gets cleared out. Is there a way to purge the snapshot log without having to perform a complete refresh of

RE: NT SCheduler !!

Saroj, The only way that I can do this is using NT's GUI Task Scheduler. There is an advanced option there that lets you repeat tasks at every specified interval and the duration. Regards, George -Original Message- Sent: Tuesday, October 30, 2001 12:20 AM To: Multiple recipients of

RE: Listener Hung

I am running pretty much the same setup except my OS is HP11i 64-bit. Oracle is 32-bit. I have not seen any of the issues you are seeing. Do you have anything competing for the same port that the listener is running on? I have 3 listeners on the box and they have been trouble free. Did you do

Re: Root to connect as system

Joe: I have a vague, hazy recollection of that as well. Way back under v6 (when men were men and sheep were nervous :-) ), I think I recall reading that the root user was forbidden to do a connect internal to the database even if a member of the dba group. I remember having to setup an account

Certified Oracle DBA Needed in Little Rock Arkansas area-4

Great company in Central Arkansas (45 minutes outside of Little Rock-the capital) needs an Oracle DBA to join its' I.T. staff. This company is currently running Oracle 7.3 and 8.0 on VMS and 8.1.5 on NT.. migrating to 8.1.7 on UNIX platforms. Since most of their employees live in Little Rock

RE: bizarre AQ problem

Cool! Sounds like a buffer thing. what is AVG_ROW_LEN on table? what is event, p1,p2,p3 for that sid in v$session_wait? what if table is EMPTY ( well, ok...put in faux PKs, at least) and then, there are all the AQ settings to consider -Original Message- Sent: Tuesday, October

{9i New Feature: Logminer } This one is long also

IMPORTANT NOTE: This will only cover the NEW features of logminer, this is NOT an exhaustive study on how logminer works, SO this means you need to already know how logminer works as the beginning aspects are not covered here. NOTE: the majority of this info comes from metalink doc id:

Which unix command

Hi There are messages.0,messages.1,messages.2,messages.3 in /var/adm directory.I want to switch messages.0 into messages.1,messages.1 into messages.2 and messages.2 into messages.3. Which Unix command is used to do this? Thanks -Seema

Snapshot

Hi List, I never used any snapshot, just want to know what's the usage of snapshot and what's the difference between snapshot view, may be it's a dump question. but if any body have some explanation or some useful url really appreciate. Hamid Alavi Office 818 737-0526 Cell818 402-1987

8i or 9i for Data Warehouse

Hi everyone - I have been asked to do the database planning for a fairly large data warehouse. The warehouse is currently in Sybase and is about 160 GB. They are planning to move to Oracle very soon. My questions - does it make more sense to spin it up on 8.1.7 or 9? (This will be a pretty

RE: IP address for a session without audit enable

Title: RE: IP address for a session without audit enable I can do this in 8.1.6: SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') from dual Tony Aponte -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 11:35 AM To: Multiple

RE: Works interactively but not in procedure

Title: RE: Works interactively but not in procedure This is a privilege issue. The stored proc runs with the security of the connected user except for those inherited via roles. Try adding the pragma for current user as follows to see if this is what you want: CREATE OR REPLACE procedure

RE: ORACLE-L Digest -- Volume 2001, Number 303

Makes me wonder if they're full of shit, I think Eric meant to say. ;-) -Original Message- Sent: Tuesday, October 30, 2001 2:20 PM To: Multiple recipients of list ORACLE-L Jared, Yes, but why would someone *not* verify where the list of email addresss came from before sending

RE: Which unix command

The rotation of these logs is handled by the syslog daemon. You can see what is specified to be logged to those files in /etc/syslog.conf. HTH - Paul -Original Message- Sent: Tuesday, October 30, 2001 12:55 PM To: Multiple recipients of list ORACLE-L -- Seema Singh [EMAIL

Connect Problem

I am trying to connect to an Oracle server. I don't have a database on this server. Do I need a database to connect to the server via SQL*Plus? Thanks, Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network

RE: Identifying user and locked table row in Oracle 8i

Tamas - Have you checked out the User Type Locks Chart in OEM? I think that it displays the information you desire. If not, you might look at the scripts catblock.sql and utllockt.sql in $ORACLE_HOME/rdbms/admin. I haven't used them, but have seen them mentioned. If you want a script for your

RE: 8i or 9i for Data Warehouse

hate to be a newbie/weenie, but is 9i even out on Solaris 8? -Original Message- Sent: Tuesday, October 30, 2001 3:05 PM To: Multiple recipients of list ORACLE-L Hi everyone - I have been asked to do the database planning for a fairly large data warehouse. The warehouse is currently

RE: Works interactively but not in procedure

Hello Tony, I tried with 'authid current_user' and giving direct select to the user 'LOAD_MGR' but did not work.. Any other clue ? Thanks for the time. Nikunj From: Aponte, Tony [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: RE: Works interactively but not in

Re: Connect Problem

You need Net8 client on this server. From: Ken Janusz [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Connect Problem Date: Tue, 30 Oct 2001 12:20:21 -0800 I am trying to connect to an Oracle server. I don't have a database on

Re: 8i or 9i for Data Warehouse

Very good white papers/technical articles related to DW enhancements/new features in 9i are available on Oracle Technet. They are pretty good. Please take a look at those and see whether you can use those in your DW project. Hope this helps. Regards

RE: Works interactively but not in procedure

Title: RE: Works interactively but not in procedure Can you verify the you issued GRANT SELECT ON SHIP_LOTS TO LOAD_MGR while connected as the owner of SHIP_LOTS? This should be enough to make it visible to LOAD_MGR via ALL_TAB_COLUMNS in a stored proc. Also, SELECT ANY TABLE would do but I

RE: 8i or 9i for Data Warehouse

Oracle 9i has more data warehouse functionality. ETL with external tables is beneficial depending on your data transformation requirements. If your using the star schema. Bit mapped indexes on the fact tables for each dimension could really increase your performance with either version 8i or

Consistent Gets

Hi. What exactly does Consistent Gets mean? Thanks Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Wiegard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RAM Disks, redo logs, and beer

Anybody out there ever use, or are using, RAM disks? We recently purchased a 2gb RAM disk from Solid Data Systems, originally to put some of our larger MySQL databases on it in hopes of increasing the performance. Since speed wasn't really the problem we're having with MySQL it didn't do any

RE: NT Scheduler !!

Hi, You could use the soon command (in the resource kit) to schedule it to run in 3600 seconds. The batch file could also have logic to check the current time to work out when to schedule it next. You could also use at and have your batch calculate the next time to run at - using either batch

RE: Consistent Gets

Any logical read (which includes SCN verification) Is called as consistent get. Best Regards, K Gopalakrishnan Bangalore, INDIA + (91) 98451 78868 -Original Message- Sent: Tuesday, October 30, 2001 1:46 PM To: Multiple recipients of list ORACLE-L Hi. What exactly does Consistent Gets

RE: Consistent Gets

CONSISTENT GETS is the number of blocks accessed in buffer cache for normal queries (SELECTs without for update clause). Rick -Original Message- Sent: Tuesday, October 30, 2001 4:46 PM To: Multiple recipients of list ORACLE-L Hi. What exactly does Consistent Gets mean? Thanks Jeff

RE: NT Scheduler !!

'soon' command can run at any time interval. it doesn't have to be 3600 sec, could be any number of seconds. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 4:56 PM To: Multiple recipients of list ORACLE-L Hi, You could use the soon command (in the

RE: Identifying user and locked table row in Oracle 8i

Hi Tamas, When a session is waiting for a row-level lock you can see the row required in the V$SESSION columns ROW_WAIT_OBJ#, ROW_WAIT_FILE#, ROW_WAIT_BLOCK# and ROW_WAIT_ROW#. A script like Oracle's utllockt.sql can be used to identify the blocker. @ Regards, @ Steve Adams @

lock problem ???

Hi all, About the locking, could someone show me some script that shows who is locking others and who is being locked? And how to get the related locking or locked queries? Thank you! Janet __ Do You Yahoo!? Make a great connection at Yahoo!

RE: Root to connect as system

Hi, I have managed to make it work. On a HP-UX box I can get root to connect as internal, system and whatever else I please. It can run scripts, shutdown and startup and do whatever u want. I know this is a no-no but I really did not have a choice in the matter. The stupid application only

RE: NT Scheduler !!

Hi, You could use the soon command (in the resource kit) to schedule it to run in 3600 seconds. The batch file could also have logic to check the current time to work out when to schedule it next. You could also use at and have your batch calculate the next time to run at - using either batch

Problem with DBMS_SQL - Long and probably annoying

There is a Procedure that uses DBMS_SQL that is causing some problems. Basically I am having problems debugging it. I got it down to the parse statement but see nothing wrong. I have taken the SQL statement out of this code and ran it manually and it works so I don't understand the error. If

RE: Certified Oracle DBA Needed in Little Rock Arkansas area-4

Bill, I'm a 3 year DBA with SAP Basis, NT Admin, and Unix admin experience. If you come across something in Northern Colorado, please let me know. I'm available immediately. Randy Kirkpatrick (303)772-7467 My resume is at http://resumes.dice.com/randywk. -Original Message- From:

RE: Problem with DBMS_SQL - Long and probably annoying

first thing I'd do is to look at line 200 through 210 from user_source to locate the problem. Also I'd put the sql statement as constructed using dbms_output 9you'll have to do multiple calls as your sql might be 225 characters). Running this SQL in sqlplus usually solves the invalid column

RE: NT Scheduler !!

Hi, You could use the soon command (in the resource kit) to schedule it to run in 3600 seconds. The batch file could also have logic to check the current time to work out when to schedule it next. You could also use at and have your batch calculate the next time to run at - using either batch

RE: IOT - comment about high writes

This message was sent to the list back in August and seemed to recommend that IOTs shouldn't be used for high write tables. Would anyone like to help explain why this might be a bad idea? Thanks, Bruce Reardon -Original Message- Sent: Wednesday, 29 August 2001 7:18 If your grabing all

RE: 8i or 9i for Data Warehouse

I've got it loaded on a Solaris 2.8 machine --- Mohan, Ross [EMAIL PROTECTED] wrote: hate to be a newbie/weenie, but is 9i even out on Solaris 8? -Original Message- Sent: Tuesday, October 30, 2001 3:05 PM To: Multiple recipients of list ORACLE-L Hi everyone - I have been

RE: IP address for a session without audit enable

You can use the following sql*function user_env or sys_context to get the IP address. HTH -- On Tue, 30 Oct 2001 09:40:23 Mark Leith wrote: How about checking the listener.log file? HTH Mark -Original Message- Sent: Tuesday, October 30, 2001 16:35 To: Multiple recipients of list

Synonyms can be VERY bad for performance

For your information and comment. We have just had a situation where the use of synonyms in our Forms application was very bad for performance. In particular, opening a form was taking around 11 seconds, and 9.3 seconds of that was spent in translating the synonyms. A section of the tkprof

stop listener remotely

all, how can one stop the listener remotely, by using lsnrctl tools? what is advantage of setting listener's password on NT?, if only domain admin will log on the system. Regardless password has set or not, domain admin can always stop any service at will any way. Thanks And Regards Chark --

RE: stop listener remotely

I would cut N Paste one of my previous mails in response to this ( too lazy to type again ;-)) Hi All !! Today I came across a typical Hole in Listener Security. If you have lsnrctl utility (or Database installation) at one Box, then you can stop the listener on another Box. Just change the

Script for next_extent of objects = free space available

Hi Gurus, I am looking for a script that shows the list of tables with next extent = the free space available in the tablespace. Does anyone have the script ? I write a script displaying the list of table-spaces with inadequate space for the next extent of the table SELECT

RE: Problem with DBMS_SQL - Long and probably annoying

Kimberly, A bit of a long shot here - Might it be permissions related? eg - does the package owner have select on all the columns that are referenced in the package? I know this isn't an appropriate long term solution, but try granting the package owner select any table directly and then see if

RE: Identifying user and locked table row in Oracle 8i

Steve, Dennis, thanks for the tips, it helped me a lot! Regards, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--