RE: OEM Repos install error.

Thanks for the input Clint, and Vadim, I think it will probably be worth getting 2.2 as it is also the current version to test against. A note: The file that was not found in the error below (vdkcr210.sql) was actually called just vdkcr.sql, without the version info.. You know I'm suprised that

Re: Oracle start/stop scripts on AIX

Should work do it all the time as well Good luck Jack "Ruth Gramolini"

Ver Urgent

Hello All, I want to create one more database in a UNIX machine. Previously one instance is already there. Please tell what are the factors will be keep while creating one more instance in same server. Both the instance `s ORACLE_HOME is same. But different ORACLE_SID. I tried to create New

RE: OEM Repos install error.

Hi Mark. Yea, 2.2 is worth the wait, but if you are an Oracle client already and have maintenance on the database, you should get the software free (if you have enterprise edition). Good luck, if you need any info on OEM, I am going to be setting up a bit of info on it on my web as I have had

Re: sql query

sysdate - 1 is sysdate minus one day sysdate - 1/24 is sysdate minus 1 hour sysdate - 1/24/60 is sysdate minus 1 minute = sysdate -1/(24*60) sysdate - 1/24/60/60 is sysdate minus 1 second = sysdate - 1/(24*60*60) = sysdate - 1/(24*3600)

RE: sql query

Hi , 3600 is for 60min x 60 sec. Cheers :) Rama Raju -Original Message- Basavaraja Sent: Tuesday, April 03, 2001 9:30 AM To: Multiple recipients of list ORACLE-L I found a query to get the time 5 seconds less than the current time as select to_char(sysdate-5/(24*3600),'dd-mon-

WAIT info in event10046 raw traces

Hello, When is WAIT information written to event10046 raw trace file, after each WAIT or another mechanism such as cummulative writes after a specified count ? If it's after each WAIT,for example, we will be able to say, each IO related wait event in trace file is counterpart of one IO system

Re: Qualifying columns to improve performance?

Why not try the two (one with qualifiers and one without) and trace each - on a freshly started database... See how much additional recursive sql occurs (if any) hth connor --- Arn Klammer [EMAIL PROTECTED] wrote: At a course some years ago, we were told that in join statements, we should

Manage of 9IAS

Title: Manage of 9IAS Hi gurus, I installed 9IAS on a Unix server. I installed all Oracle products with the Unix user ORACLE and its primary group OINSTALL. My installation is done, but I want to manage my IAS with another user called IAS and primary group DBA. My problem is : Everything

RE: Legato Networker Module

We are thinking to use legato Networker module for 24x7 availability. Any body had any experience (good/bad) or can give any tips Thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) INET: [EMAIL PROTECTED] Fat City Network

Constraints with Synonyms?

Hi, I have a need to create a synonym in a schema (A) for a table that is another schema (B). This is no problem. However, the table in question is a "parent" table and I cannot create the "references" constraint from the "child" to the "parent" when the "parent" is a synonym. When I

Re: Ver Urgent

What You HAVE to do is: Create new initNEW_SID.ora file with all the proper new locations set (Be VERY CAREFUL WHEN YOU COPY AND RENAME EXISTING ONE) create a symlink in the $ORACLE_HOME/dbs directory pointing to this file (Or put the initfile there) set your environment variables to point to

Re: Manage of 9IAS

I've used a different user:group (oraweb:oraweb) for OAS/iAS software. [EMAIL PROTECTED] 04/03/01 07:10AM Hi gurus, I installed 9IAS on a Unix server. I installed all Oracle products with the Unix user ORACLE and its primary group OINSTALL. My installation is done, but I want to manage

Redo log size MAX = ?

Hi, My database = noarchive mode (compulsory for our application) In case of instance failure can oracle perform recovery from redo log ? if can what will be tne maximum size of the redo log recommended. Because I need set that size for whole day transaction currently 512K (3 redo logs) switched

RE: WAIT info in event10046 raw traces

Hi Danisment, It is after each wait. Whether each wait corresponds to a single system call depends on whether the file is multiplexed, and whether Oracle passes large multiblock reads to the operating system in a single call on that platform. @ Regards, @ Steve Adams @

RE: Sql question

Surjit, You could set up your PL/SQL procedure to order your query on a unique column such as PK, then return just 20 rows of data plus the last PK value to the application. The application could then supply this PK value in its next request such that your procedure now returns 20 more rows

Re: FOREIGN KEY to a remote table. Is it possible?

Nope, if you want to enforce RI thru a link, you'll need to implement it via triggers, email me offline, i'll give you the concept, i had to do it about 5 years ago. Joe From: "Andor Gyula" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL

OCI

All, Using Oracle 8.0.5.0.0 Compaq Tru64 v4.f One of the duhvelopers here wants to use OCI. I am sure it is installed as part of the server installation but where do all the relevant files live for him to use. I can only find oci files in $ORACLE_HOME/rdbms/demo. Is this normal. ??

Rollback seg for an entire session, not just per transaction? Implicit commits in PL/SQL?

A colleague wants to do a large load using multiple PL/SQL programs; she typically (has the DBA) turns off all rollback segments except for SYSTEM and one large rollback segment. Some questions: Will the rollback segment called SYSTEM in the SYSTEM tablespace never be used for user session

RE: OCI

Yes it is. In 8.1.7 it's moved to the more appropriate $ORACLE_HOME/rdbms/public. You work for AXCIOM? The same AXCIOM that has a huge database of personal data for sale? -Original Message- Sent: Tuesday, April 03, 2001 10:45 AM To: Multiple recipients of list ORACLE-L All, Using

Recovery Manager vs. SQL Back Track

Title: Recovery Manager vs. SQL Back Track Hi everyone - Currently we are doing backups manually, periodic cold backups, and hot backups in between - we are running in archivelog mode. We are running 8.1.5 and 8.1.6 (soon to be 8.1.7) on Sun Solaris. Today there are only a few small

RE: Linux ver and Oracle

At 01:52 PM 4/2/01 -0800, you wrote: I've found RH6.2 and Oracle 8.1.7.0.1 to be pretty compatible. Don't know about the other Linux distributions. That's interesting. I have an 8.1.6 and 8.1.7 installation cd, and RH6.2 . Tried installing 8.1.7, and it died with the "800%cpu" thing. 8.1.6

RE: sql*loader default value

Thanx to Witold and Prakash for suggesting NULLIF and DEFAULTIF. Unfortunately, it looks like both of those do basically the opposite of what I'm trying to accomplish. Essentially, I want to prevent sql*loader from ever inserting NULL in a column (which may not be numeric), substituting

RE: Sql question

Surjit, The syntax is: Select * From MyTable Where RowNum 21 Andmore of your predicates ; Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original

RE: SQLServer vs. Oracle Papers Needed

here's some information i found; any of you helpful gurus, please correct my misconceptions or mistakes as necessary... === snipped from various other e-mails === -Original Message- one highly regarded training organization is learningtree.com, they offer both sql and oracle training;

RE: Oracle on Linux questions

I have had good luck with Red Hat Linux 6.2 and Oracle 8.1.6.1 for Linux. You don't need to do any upgrades to Linux before installing Oracle, you don't have to download your own Java virtual machine, and you don't have to install any Oracle patches to make it work (as I had to with Oracle

RE: Linux ver and Oracle

I used the Oracle 8.1.7 with OPS linux version. Were your version just 8.1.7 or 8.1.7 with OPS? Richard -Original Message- Taylor Sent: Tuesday, April 03, 2001 11:26 AM To: Multiple recipients of list ORACLE-L At 01:52 PM 4/2/01 -0800, you wrote: I've found RH6.2 and Oracle 8.1.7.0.1

RE: OCI

Actually, it probably isn't part of the server installation, but if you have the oci.h in $ORACLE_HOME/rdbms/demo then you probably have everything you need. Now, if he wants to use it from a Win32 desktop, then in the client install the files would be in $ORACLE_HOME/OCI8 or something like

RE: Qualifying columns to improve performance?

Hi Arn, There may be good reasons for explicitly qualifying all column references, but performance is not one of them, at least under Oracle 8i. I've just done some tests and there is absolutely no difference in the number of dictionary cache gets required during the parse, and no measurable

Re: FOREIGN KEY to a remote table. Is it possible?

At 05:40 AM 4/3/01 -0800, you wrote: Is is possible to create a FOREIGN KEY constraint that references to a remote table through DATABASE LINK? From the Oracle 8i SQL Reference, Volume 2 (PN A76988-01), page 7-240, about halfway down the page: "The child and parent tables must be on the same

function to get GMT time

Hi ! Is there a way to get GMT time within PL/SQL independent from the local time(zone), I'm looking for a function similar to SYSDATE, but it should return GMT instead of the local time. TIA Andreas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haunschmidt

Re: sql query

That's converting hours to seconds. 60x60. Shakeel --- Ravindra Basavaraja [EMAIL PROTECTED] wrote: I found a query to get the time 5 seconds less than the current time as select to_char(sysdate-5/(24*3600),'dd-mon- hh24:mi:ss') from dual; I am really not sure as to why 24*3600 is

RE: Metalink Response ....FYI

Hi All, I'd say that there must be something badly wrong with the application if it cannot cope with 1,500 concurrent users. I know of sites supporting more than 20 times that number of active users on a single server with consistent sub-second response times. @ Regards, @ Steve Adams @

AT scheduler

Can anyone tell me how to schedule a batch job to run every 5 minutes using the "AT" scheduler? Thanks! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Sql question

On subsequent select select * from mytable where rownum 40 minus select * from mytable where rownum 20. This will bring rows between 20 and 40. On the next select, replace 40 with 60 and 20 with 40 -Original Message- Sent: 03 April 2001 15:26 To: Multiple recipients of

RE: Exp/Imp Fromuser/Touser Security

Using an "OPS$" user would be much preferred to that. If that user is given DBA privilege, it can export/import the full database. Sys password in a file? Did you schedule a public execution? -Original Message- Sent: Tuesday, April 03, 2001 10:00 AM To: Multiple recipients of list

RE: Rollback seg for an entire session, not just per transaction?

Dana 1. System rollback segment will be used for user session transactions. 2. The only way I think of assinging a rollback segment is by using SET TRANSACTION COMMAND. 3. There wont be any implict commits in a PL/SQL procedure and on exit of the PL/SQL will also not commit the data. You need

RE: Redo log size MAX = ?

That would be one of those RTFM questions, don't you think? -Original Message- Sent: Tuesday, April 03, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Why can't you use archiving? It doesn't effect the applications running on the database in anyway (except space to store the

RE: sql*loader default value

Gregory, On doing some research, found that a number column can be populated with a 0 using the direct load path, if the input value is null by having the following line in the control file: field1 integer external defaultif (field1 = 'NULL') But the same thing doesn't work for char columns.

RE: sql query

60 seconds * 60 minutes =3600 secnods per hour. 3600 * 24 hours = 86400 seconds per day. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Ravindra Basavaraja [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 11:00 PM To: Multiple recipients of list ORACLE-L

Re: Qualifying columns to improve performance?

Hi, you should better reuse your parsed statements oli [EMAIL PROTECTED] wrote At a course some years ago, we were told that in join statements, we should qualify ALL our column names with the appropriate table name, not just those that may be ambiguous. The reason was that the parser

Multi Threaded Server

Hi All, We have about 400-500 connections to our database and are now considering going to MTS. Can anybody share their experience? pitfalls? things to take care of? performance issues? Any help appreciated. Our main objective is to lower the amount of RAM consumed by the Oracle sessions.

RE: function to get GMT time

Hi Andreas, You can do this with the NEW_TIME date funntion: SQL alter session set NLS_DATE_FORMAT = 'DD-MM-YYY HH24:MI:SS'; Session altered. SQL select sysdate "GMT" from dual; GMT -- 03-04-001 17:05:25 SQL select new_time(sysdate, 'GMT', 'AST') "AST" from dual; AST

OID installation

From the Oracle 8.1.7 Solaris installation guide: "If Oracle Universal Installer detects an existing Oracle8i database in this location, it does not install another one. However, for optimal results, Oracle Corporation recommends that you install Oracle Internet Directory on a system that does

RE: Redo log size MAX = ?

Is this true? I thought that if the transactions needed for recovery are in the online redo logs, and the online logs are available, then the RECOVER DATABASE statement will read from the online logs. Just did it this morning on a noarchivelog database, Oracle 7.3.3. If however, the data

RE: Metalink Response ....FYI

Title: RE: Metalink Response FYI rant 1500 users? And ORACLE FREAKING CORPORATION is having trouble meeting the demand? Geez Louise, this is *exactly* the type of thing companies get roasted alive for. I am supposed to believe these guys when they say We'll scale all the way to

Re: Recovery Manager vs. SQL Back Track

I have used rman exclusively since I became an Oracle DBA because it was there and I needed a backup strategy. It has gotten better with later releases. We are now on 8.0.6. It used Oracle internals so that is an advantage. It comes free with Oracle so that is another advantage. I can send

Re: Metalink Response ....FYI

Ranting on... They say there is unexpected demand. They created it by refusing to talk to anyone without their opening an iTar so how can they say it was unexpected. Maybe they are counting on everyone giving up on Metalink thereby reducing demand .. End of ranting... Ruth - Original

Re: OCI

Yes, the doku of OCI should be in the platform-specific part. oli [EMAIL PROTECTED] wrote All, Using Oracle 8.0.5.0.0 Compaq Tru64 v4.f One of the duhvelopers here wants to use OCI. I am sure it is installed as part of the server installation but where do all the relevant files live

Re: OID installation

the skript builds for everything an extra tsp. Be warned. oli TABLESPACE_NAME |INITIAL_EXTENT|NEXT_EXTENT|MIN_EXTENTS|MAX_EXTENTS|PCT_INCREASE|MIN_EXTLEN|STATUS |CONTENTS |LOGGING |EXTENT_MAN|ALLOCATIO|PLU

OFFTOPIC RE: OCI

Title: OFFTOPIC RE: OCI O, I want to buy some! Gimme yer click stream, data boy! ||-Original Message- ||From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] ||Sent: Tuesday, April 03, 2001 11:26 AM ||To: Multiple recipients of list ORACLE-L ||Subject: RE: OCI || || ||Yes it is. In

SQL Question

Hello all, Can someone tell me whether or not there is a way do this in SQL? I want to select some data given a certain date range,i.e where some_date between start_date and end_date. Is there a way to group the output by week? In other words, something like: SELECT column_a, column_b,

Slightly OT: Capturing a failed status of an ftp process

I think I've seen an answer to this, but I never needed it before. If anyone can help, I would greatly appreciate it. We are trying to ftp files from one server to another. (Archive logs for Oracle). We want to be able to capture the status when the ftp fails, so that we can notify the DBAs

RE: sql*loader default value

Sorry I misunderstood your request. Try something like this: THE_VAL POSITION(111:120) DECIMAL EXTERNAL "NVL(:THE_VAL, 33)" It works for me - inserts 33 into numeric column when the datafile contains spaces or nothing (if it is the last field) HTH Witold On 3 Apr 2001, at 7:20,

RE: Linux ver and Oracle

8.1.7 R3 Enterprise Edition. No OPS At 08:20 AM 4/3/01 -0800, you wrote: I used the Oracle 8.1.7 with OPS linux version. Were your version just 8.1.7 or 8.1.7 with OPS? Richard -Original Message- Taylor Sent: Tuesday, April 03, 2001 11:26 AM To: Multiple recipients of list ORACLE-L

Re: Recovery Manager vs. SQL Back Track

Send it through the list. I would like to see it also. Thanks. [EMAIL PROTECTED] 04/03/01 11:56AM I have used rman exclusively since I became an Oracle DBA because it was there and I needed a backup strategy. It has gotten better with later releases. We are now on 8.0.6. It used Oracle

RE: Linux ver and Oracle

Richard, What was your experience (good/bad) with Oracle Parallel Server on linux? What kind of hardware did you use? Which linux os version? TIA, Gerardo -Original Message- Sent: Tuesday, April 03, 2001 9:21 AM To: Multiple recipients of list ORACLE-L I used the Oracle 8.1.7 with

Re: function to get GMT time

No, there's not. There are too many variations in timezones and daylight saving/summer time offsets. The only way to be certain with timezone adjustments is to run your computer in GMT and then build your own functions to adjust to local time. If you need to have multiple local times, be sure

HP environment - standby db?

Anybody out there using 2 HP servers attached to a single StoreEdge (AutoRaid) and setting up Oracle for a hot-standby db? Or are you running OPS instead of the hot-standby? Management thinking is to attach a N4000 and a L2000 servers to a 12H StoreEdge. I understand that a "HP Service

Re:RE: Rollback seg for an entire session, not just per tran

Raj, OH, I hate to contradict people, but several months ago we had a couple of very long running jobs that accidentally filled all of the rollback segment space with the exception of SYSTEM. The processes all crashed with an Oracle error that said the SYSTEM rollback segment was strictly

RE: function to get GMT time

Hi Andreas, Please try this. select sysdate, new_time(sysdate,'EST','GMT') from dual; Thanks, Gurdarshan -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Hi ! Is there a way to get GMT time

RE: OCI

Lee, Our implementation of OCI makes use of the .h files in $ORACLE_HOME/rdbms/public and also the shared library libclntsh.so in $ORACLE_HOME/lib. These have to exist as part of the client installation. If I'm not mistaken, I had to select the programmer option from the list of installable

RE: RE: Rollback seg for an entire session, not just per tran

Oops.. That was typo :-) -Original Message- Sent: 03 April 2001 17:01 To: Raj Gopalan; Multiple recipients of list ORACLE-L Raj, OH, I hate to contradict people, but several months ago we had a couple of very long running jobs that accidentally filled all of the rollback segment

Re: function to get GMT time

This gives GMT. Thanks! Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 1:15 PM Hi Andreas, Please try this. select sysdate, new_time(sysdate,'EST','GMT') from dual; Thanks, Gurdarshan

RE: function to get GMT time

You can always build qan external function to do so. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Hi ! Is there a way to get GMT time within PL/SQL independent from the local time(zone), I'm looking for a

RE: Slightly OT: Capturing a failed status of an ftp process

Try using expect to script the ftp session. http://expect.nist.gov/ -Original Message- Sent: Tuesday, April 03, 2001 1:31 PM To: Multiple recipients of list ORACLE-L I think I've seen an answer to this, but I never needed it before. If anyone can help, I would greatly appreciate

RE: Metalink Response ....FYI

But if everyone gives up on Metastink, then they'll be very interested in 9i because it eliminates the need for a dba or a developer or an iTAR. Listen to me now or hear me later. Dan -Original Message- Sent: Tuesday, April 03, 2001 12:16 PM To: Multiple recipients of list ORACLE-L

Re: Slightly OT: Capturing a failed status of an ftp process

Terry, If I remember correctly the ftp supplies a return code. You could capture the return code and have a second script act accordingly on the return code. I think code 220 is successfull. ROR mm [EMAIL PROTECTED] 04/03/01 01:30PM I think I've seen an answer to this, but I never needed it

RE: Script to reverse engineer all objects in a schema to DDL?

There are other programs such as SQL Navigator, DB Artisan, EZSQL are available but requires you to purchase a copy. SQL Programmer from Sylvain-Faust, another commercial product, will do this as well; at least on a per-object basis. It's a terrific tool all around:

RE: Slightly OT: Capturing a failed status of an ftp process

Why don't you use rcp or rdist instead? -Original Message- Sent: Tuesday, April 03, 2001 1:31 PM To: Multiple recipients of list ORACLE-L I think I've seen an answer to this, but I never needed it before. If anyone can help, I would greatly appreciate it. We are trying to ftp files

RE: AT scheduler

echo "0,5,10,15,20,25,30,35,40,45,50,55 * * * * /usr/local/bin/myjob" /tmp/crontab crontab /tmp/crontab -Original Message- Sent: Tuesday, April 03, 2001 12:30 PM To: Multiple recipients of list ORACLE-L Can anyone tell me how to schedule a batch job to run every 5 minutes using the

Re:Multi Threaded Server

Jack, I use MTS of any instance were the company intranet gets involved for similar reasons. There are two problems that I've run into with MTS over the years. The first is running out of shared pool space. With MTS the query and resulting data get stored in the shared pool, so at least

Re: function to get GMT time

This gives you the current sysdate from your server and calls it GMT. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 1:21 PM Hi Andreas, You can do this with the NEW_TIME date funntion: SQL alter session set

RE: sql query

Though I had some fair idea of what it was, but now things are very clear after all the replies. Thanks for all the reply. Ravindra -Original Message- [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 3:21 AM To: Multiple recipients of list ORACLE-L sysdate - 1 is sysdate minus one

FOOT-AND-MOUTH

For all of you MicroSoft supporters out there! Sorry Jared! Dick Goulet Forward Header_ FOOT-AND-MOUTH BELIEVED TO BE FIRST VIRUS UNABLE TO SPREAD THROUGH MICROSOFT OUTLOOK Researchers Shocked to Finally Find Virus That Email App Doesn't Like

RE: RE: Rollback seg for an entire session, not just per tran

I hate to disagree with people, but SYSTEM rollback segment is actually not used at all if there are other rollback segments available. Those "dictionary transactions" are a myth, the same as that oracle is trying to "cache extents". Simply not true. -Original Message- Sent: Tuesday,

Re: Recovery Manager vs. SQL Back Track

We currently use SQL BackTrack on both Solaris boxes where our interface to tape software is netware. To put it mildly, netware sucks. When we were going to disk SQL BackTrack worked like a charm. On our other system - AIX - our interface is ADSM. It too has worked like a charm. If you can

RE: FOOT-AND-MOUTH

Title: RE: FOOT-AND-MOUTH Yea, it sure spreads more viruses than ORACLE's EMAIL SOLUTION. ahem, well...what i meant to say was. Criminy, Oracle can't even run a 1500 user support site for it's paying freaking customers. Oracle support is as well-thought out as asking Ed Hazelton to

RE: Recovery Manager vs. SQL Back Track

Title: RE: Recovery Manager vs. SQL Back Track I have worked with manual scripting, EBU, RMAN, and SQLBackTrack. If you can afford it, use SQLBackTrack. It's idiot proof for both backup and restore if you set it up right. (trust me). If you have other questions email me direct. Brian P.

Generating Forms through API or Designer

Hi Listers, I have the following questions: 1. I would like to generate Developer Forms fmb files through my C++ application. Is it difficult? Did any of you do similar things? I know Forms have an API for this, but I don't know how complex is it. I have pretty simple Forms. Should I try or

Re: SQL Question

You can do something like select to_char(date_column,'YYWW'), count(*), sum(other_column) from table where date_column between date1 and date 2 group by to_char(date_column,'YYWW') where WW returns the week of the year ( 1 to 53) keeping in mind, of course, that you must include in the group by

(Fwd) [Kent Graziano] ODTUG Meets with Oracle!

--- Forwarded message follows --- Date sent: Mon, 02 Apr 2001 15:01:46 -0800 S e n d r e p l y t o : O D T U G - D E V 2 K - L @ f a t c i t y . c o m F r o m : Oracle Development Tools User Group Dear List Users: I am pleased to report to you that

Re: HP environment - standby db?

At a previous employer, I've used HP MC ServiceGuard w/ EMC and it worked great. Don't know about Storedge, but can compliment EMC on their storage solution as the best in the business. Of course thats my opinion. Also, used the standby box as a staging db for prototyping new applications.

RE: AT scheduler

My Computer/Scheduled Task might fit your needs better, since it has got a Windows GUI. It's easier to handle than the AT command. The GUI in some places is illogial, but still it might be usefull for you. Tamas Szecsy -Original Message- Sent: 2001.04.03. 8:22 PM To: Multiple

Re: function to get GMT time

I know, it works! RBG - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 2:57 PM Ruth: Just reverse the logic...this converts Eastern Daylight Time to GMT: SELECT new_time(sysdate, 'EDT', 'GMT') FROM dual; SQL SELECT

RE: Slightly OT: Capturing a failed status of an ftp process

Terry, I worked on what I think is a similar process. We are running SAP and need to be able to ftp files on and off of our unix SAP servers. Someone in the past wrote an SAP ABAP program that does all of the set up then calls a unix shell script to perform the ftp. If the ftp command

RE: Help - How to declare a cursor inside a FOR ... LOOP ?

You can't. It appears that you want to select all the detailed text extries related to a specific problem. You could define a cursor that selects all the detailed entries, or you could read all the detailed entries into a pl/sql table and then search through them. If you use the cursor,

RE: Metalink Response ....FYI

Title: RE: Metalink Response FYI Sadly, I do not. I am not a TV watcher these days ==-Original Message- ==From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] ==Sent: Tuesday, April 03, 2001 3:17 PM ==To: Multiple recipients of list ORACLE-L ==Subject: RE: Metalink Response

RE: Redo log size MAX = ?

So, based on the responses I've seen, this statement can be declared to be false. [EMAIL PROTECTED] 04/03/01 11:05AM hi forget about recovery from online redo logs It doesn't exist in Oracle Regards Tapiwa -Original Message- Sent: Tuesday, April 03, 2001 3:01 PM To: Multiple

RE: Help - How to declare a cursor inside a FOR ... LOOP ?

Wendy: Actually, you don't need to declare the cursor inside the for loop, you just need to open it inside the loop and pass a parameter to the cursor. DECLARE V_AKTIV_NRaktiv.AKTIV_NR%TYPE; V_PROBLEMaktiv.PROBLEM%TYPE; V_ENDDAT aktiv.ENDDAT%TYPE; V_ENDUHR aktiv.ENDUHR%TYPE;

RE: Metalink Response ....FYI

Title: RE: Metalink Response FYI Randy Baker left, yes...and another fellow...forced out, virtually. Then, the cost cutting began. People attrited or let go...cheaper monitors and equipment...reduced training budgets. We Saved a Billion Dollars Last Year by not doing their job.

Re: function to get GMT time

Just keep in mind, as I mentioned earlier, DST is not accounted for. So you will first need to convert from EDT to EST and then use this function. Otherwise your GMT will be one hour off. Of course, if you run your machine on EST and do not switch to EDT, you will be fine. Oh, I've assuming

RE: Script to reverse engineer all objects in a schema to DDL?

Hi Chris, You could use Richard Sutherland's exciting Perl work, with his new DDL::Oracle Perl module, and it's associated scripts, which you can find here: = http://www.perl.com/CPAN-local/modules/by-authors/id/R/RV/RVSUTHERL/ Richard and I have also started embedding this automatically too

RE: AT scheduler

Even more, if you are running crontab on NT, I strongly suggest to take a look at www.SuSe.com or alike. -Original Message- Sent: Tuesday, April 03, 2001 2:22 PM To: Multiple recipients of list ORACLE-L If you are running on NT, I strongly recommend you obtain crontab for Windows. AT

RE: Help - How to declare a cursor inside a FOR ... LOOP ?

i speak from ignorance, isn't there implicit and explicit cursor declarations and usage? can't you encapsulate that section you have identified in a loop and it will implicitly opens a cursor? then all you have to do is manipulate as needed to generate desired results...

Re: Slightly OT: Capturing a failed status of an ftp process

I tried this, but the exit from the ftp is successful, so the return code ends up being successful also. Terry Gene Sais wrote: i find the easiest thing to do is put the ftp code in a function within the shell script. call the function from the shell script and check the return code ($?)

SQL Command to view stored procedure

Title: SQL Command to view stored procedure What is the SQL command, v$ table or SQL*Plus command to see the contents of a stored procedure? I looked at DBA_SOURCE but it stored the code in separate rows based on the owner and procedure name. Is there any way to see the source code for OEM

Re: Metalink Response ....FYI

Ross, You sound bitter...just remember it is only your job, not your life. Let them founder, you will still have a job. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 4:10 PM Randy Baker left, yes...and another

RE: Help - How to declare a cursor inside a FOR ... LOOP ?

You're probably right, I think I got stuck on the whole DECLARE BEGIN EXCEPTION END thing. -Original Message-From: Streeter, Lerone A LBX [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 03, 2001 4:36 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Help - How to

RE: Slightly OT: Capturing a failed status of an ftp process

Isn't it possible to check size of the source and remote file(s) after ftp. If they are the same - it is a high probability that transfer was OK. Alex Hillman -Original Message- From: Shari Dishop [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 3:52 PM

  1   2   >