Oracle client install 8.1.7

We are moving from 8.0.5 to 8.1.7 For 8.0.5 there was a Oracle client disk for NT Workstation. Is there one for 8.1.7 or do I install the client onto NT using the server install disk Universal installer? If so do I need a Java Run Time to run the installer on NT Workstation? John -- Please

AW: function to get GMT time

Thanks to all who responded. Sure, I meant Coordinated Universal Time (UTC). After all, there seems no simple way to get UTC in PL/SQL, i.e. without a switch-over table for daylight saving time, although at least UNIX-like operating systems use UTC internally and POSIX conformant systems

SQL+ AUTOTRACE OUTPUT

Hello, I have a table with 39 rows (3 blocks of 4Ko). When I delete 4 rows from this table, the output of the SQL+ AUTOTRACE is the following : Statistics -- 8 recursive calls 7 db block gets 8 consistent

RE. OCI

Thanks for all the responses guys Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any

Unable to open the database,Urgent!!!

Hi, In a Unix Machine I want to create two instance on a single server.Its memory size is 1GB. I am trying to up one instance it is opening well .While Creating other instance I am getting this error. ORA-07279: spcre: semget error, unable to get first semaphore set. SVR4 Error: 28: No space

TZ in AIX

List, our server has suddenly ahead 1 hour... it happened last year also something to do with the timezone... TZ variable.. is there a timezonewe could set which remains constant (does not go ahead 1 hour) thruout the year ? regards -- Please see the official ORACLE-L FAQ:

Unable to Alloc Memory

CASE When Passing 6600 Transactions spread across 250 Concurrent users on SUN APP Server as part of Benchmarking Exercise Hardware - Sun APP Server 4 CPU , 4 GB RAM , 3.5 GB Swap Software - Solaris 2.6 on Oracle 7.3.4.5 Application - Pro*c Application with Embedded SQLs in a Banking

new DBA/DBO basic training

Dear all ! I'm leaving my current job soon , but before i leave i need to teach one of the developers here some very-very basic DBA / DBO stuff. This guy is going to support our existing databases . I'm just wondering what should i teach him . The training must be short and very

Re: Max # of Open Files for UTL_FILE in 7.3.4.3

Waleed, That is an answer. Opening and closing the files might be an option. Unfortunately, I have to work within the environment I was given. The application from which I'm extracting the data is poorly designed. Space and memory are a problem, and the table containing the master records is

RE: AT scheduler

Are you saying that Microsoft products don't come with useful documentation? Documentation that can help you diagnose problems when things go wrong??? gasp Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original

Re: Unable to open the database,Urgent!!!

Saroj, It appears you do not have enough semaphores available to bring up both instances. What flavor of UNIX are you operating on? David A. Barbour Oracle DBA "Dash, Saroj (CAP,CEF)" wrote: Hi, In a Unix Machine I want to create two instance on a single server.Its memory size is 1GB.

Re: new DBA/DBO basic training

Teach him to write a resume... [EMAIL PROTECTED] 04/04/01 07:50AM Dear all ! I'm leaving my current job soon , but before i leave i need to teach one of the developers here some very-very basic DBA / DBO stuff. This guy is going to support our existing databases . I'm just wondering what

Re: Unable to open the database,Urgent!!!

I don't think you're having memory problems; check for the number of available semaphores; sounds like that should increase; [EMAIL PROTECTED] 04/04/01 07:00AM Hi, In a Unix Machine I want to create two instance on a single server.Its memory size is 1GB. I am trying to up one instance it

Re: Unable to open the database,Urgent!!!

Hi There is a whole lot of semaphores that can and need to be set on most flavours of UNIX (like shmmax etc..) I do not know exactly what should be set but your platform specific doc's should give you a pretty good idea. Basically they will set the boundaries within oracle can operate and if

RE: Unable to open the database,Urgent!!!

Have a look at the following web page for your database sizing. http://members.spree.com/business/cnaude/Unix_system_parameters_for_Oracle.h tm If it does not go through, tyr the following link and then go to Unix parameters link. http://members.spree.com/business/cnaude/welcome_page.htm Good

Re: new DBA/DBO basic training

Hi! Give this list address and other links such as technet where to find info. Gints Plivna "andrey"

RE: Metalink Response ....FYI

Speaking of cost-cutting, anyone have any idea when Oracle will bottom out on the stock market? I am wondering whether now would be a good time to invest... I think we are getting close to that now, but I say that every day lately and the stock seems to be dropping further every few days. Pat.

RE: Unable to open the database,Urgent!!!

you have to set the semaphores to run both the databases ..temporarily you reduce the number of process in both the instanes and start both the databases. deepen oracle dba -Original Message- Barbour Sent: Wednesday, April 04, 2001 5:41 PM To: Multiple recipients of list ORACLE-L

RE: new DBA/DBO basic training

How about how to back up the database? Also recovery? A quick overview on users, and authorities/permissions. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of andreySent: Wednesday, April 04, 2001 12:50To: Multiple recipients of list

RE: Unable to open the database,Urgent!!!

FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 31st March 2001. Saroj, You need to change your kernel

Re: new DBA/DBO basic training

[EMAIL PROTECTED] wrote: Hi! Give this list address and other links such as technet where to find info. Gints Plivna and give him a copy of _Oracle DBA 101_, and yes i have done that with my JR. DBA and it's helped. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL

I'll just go and kill myself - was Metalink Response ....FYI

Patrice, DO YOU REALLY THINK I'D BE PLUGGING AWAY AT A Database if I could accurately predict the markets ... I'd be on the beach, with a one young beauty to bring me cocktails on my left, and another on my right to rub in the suntan lotion (Don't tell my wife about this fantasy ...) In my

Memory used per session

Hi All, I'm on AIX and want to check how much memory each Oracle session uses. Can anybody let me know how to achieve this? Jack = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor

Unix memory used

Hello list, We have a Sun e3500 with 4x300 MH processors, 1 GB Ram and OS 2.6. The server runs 4 small instances ( 7.3.4.5), two PeopleSoft apps and one more help desk app. As the below shows, or SGA's are very small (same for all 4 databases): SVRMGR show sga

Check the constraints

Hallo Anyoine know about any program that can check all the constraints after the database is designed? Roland Skldblom -- 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

Offtopic: Oracle Server Class Diagram

Hi! In case You have free time or like object oriented modelling, class diagrams and oracle You may explore such a link: http://www.itsystems.lv/gints/files/oracle/oracle_s.htm All suggestions and errors are welcome! Gints Plivna -- Please see the official ORACLE-L FAQ:

No Subject

Hi, On system such as NT,Win200, AIX, and Linux, you have no control over memory and semaphore parameters as they are automatically set for you. Sample Changes on UNIX System Shared Memory and Semaphore Parameters HP-UX Release 10.0 DYNIX /ATT UNIX sys V SUN 4 SHMMAX 0X400

RE: Linux ver and Oracle

I have installed 8.1.5, 8.1.6, and 8.1.7 w OPS. Perhaps you can try to install use the 8.1.7 w. OPS. Richard -Original Message- Taylor Sent: Tuesday, April 03, 2001 12:57 PM To: Multiple recipients of list ORACLE-L 8.1.7 R3 Enterprise Edition. No OPS At 08:20 AM 4/3/01 -0800, you

Re: Sql question

Thanks Raj and others. That definitely leads me to the right direction. Surjit Raj Gopalan wrote: 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

Re: SQL Server basic sources of info?

- Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, March 30, 2001 19:36 * Any equivalent Fatcity/LazyDBA list servers for SQL Server? try these: http://www.swynk.com/discuss_sql7

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

OK. Here goes. This is the relevant portion of the ftp script. The SAP ABAP program executes a system call to execute this script. It passes in things like the userid, remote host name, remote and local file names, password, get or put command, etc. This is the piece of the script that we

RE: Unix memory used

Just from looking at what you've described, you don't use the memory you have on the machine. But I'm on the outside looking in. If your databases are memory bound, my recommendation is to look into tuning your database memory first, and expanding each SGA. I'm also assuming that this is only a

RE: TZ in AIX

Rahul, You can set the time so it won't recognize Daylight Savings Time, if that's what the problem is. The sysadmin needs to do the following: smitty choose System Environments choose Change / Show Date and Time choose Change Time Zone Using System Defined Values You'll get a pop-up window

Metalink Again

Is anyone else having problems with Metalink today? Todd Carlson Oracle 8i Certified DBA Bunge Corporation -- 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,

Indexes causing a slowdown

OS HP10.20 Oracle 7.3.3 (ya I know) Every now and then we get the situation were application grows to a standstill as far as loading data. These should all be straight forward inserts. Rebuilding the indexes causes the problem to go away. These indexes are all based on primary key values like

RE: Check the constraints

Roland, Oracle Designer can reverse engineer an Oracle database and capture all constraint (and other) info. You can then run various reports and/or display the data model in diagrams to allow you to validate the accuracy and completeness of the constraints. It can do much, much more as well.

Re: Unix memory used

Hi Mike, There are lots of papers/documents on the web describing how Solaris uses memory and tools to monitor usage. One place to start is: http://www.unixinsider.com/unixinsideronline/swol-03-1998/swol-03-perf.html The list of references from there should also help. Hope this helps. Dave

RE: new DBA/DBO basic training

I read the caption at the bottom, and I dutifully deleted the message from my machine. Ooops! Now I am going to receive a copy of my reply! My, this will never end... Pat. -Original Message- From: lerobe - Lee Robertson [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001

RE: Check the constraints

Title: RE: Check the constraints Hi, The SQL impact from Toad maybe can help. rgds, -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Subject: Check the constraints Hallo

'PMON did not start after 120 seconds'

I'm having a hard time starting up my database and the only log I know is the ALERT_database.LOG but I get no details of what to do. Is there any other log? ORA-000445 does not tell me where the TRACE file is if any. TIA Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: Metalink Again

Sure am!! Can't search - AGAIN. For months now, the search and advanced buttons have not worked (I click on the button, the screen gets busy and 2-15 minutes later it refreshes - no change in the screen - ARG!). My solution has been to go into Forums and use the advanced search link there, but

can I set a default index tablespace??

Is it possible to set a default index tablespace, rather than specify it in the create table statement? Database is 8.1.7 John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

Import views, packages, procedures, etc?

Hi: I am using exp/imp to do nightly refresh of a schema (which has about 400 tables) from one instance ("A") to another instance ("B"). Here is the exp.parfile: BUFFER = 64000 COMPRESS = Y CONSISTENT = N CONSTRAINTS = Y DIRECT = N FILE = /oracle/exports/oracle.dmp.pipe GRANTS = Y INDEXES = Y

RE: Veritas

Hi Steve, I completely agree with using standard file sizes. (Even when using UFS?) So would someone like to suggest standard file sizes? Last time I went raw I used sizes of 128MB, 1GB, and 8GB (adding 64K or 128K for overhead) and it worked just fine. Regarding raw vs. QuickIO... By using

RE: Generating Forms through API or Designer

As to #1: If you have C experience and enough Forms experience to understand all the interdependencies between objects, and it is a simple form, then go for it. The online help has a specs on all the function calls. There is some need to reed between the lines, but it is not too bad. The

RE: How can I tell if an index is a function-based index/

Cherie, Yes funcidx_status will be ENABLED and there'll be a row in User_Ind_Expressions for each function-based index. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED]

RE: Metalink Response ....FYI

No, it's that my RRSP (pension plan in Canada) has been dropping steadily in value the past months, and I am getting antsy. I thought that a bit a diversifying (investing in the U.S. as well as Canada) might not be a bad thing, esp. if solid companies are currently undervalued. I can wait

RE: Metalink Again

Suprisingly, I just logged on and it took only a second. Amazing!! They must have gotten that other Tandy computer running again. -Original Message- [EMAIL PROTECTED] Sent: Wednesday, April 04, 2001 11:35 AM To: Multiple recipients of list ORACLE-L Is anyone else having problems

OT: Prognostications and Timing the Market... was I'll just go and kill myself...

Well I somehow managed to sell off all my stock at the end of '99 before the NAZ meltdown. Not necessarily because of investment savvy but because of virtuous paranoia. Maybe I missed some profits by getting out before the full expansion of the "Internet bubble" but neither have I lost any money

RE: (Fwd) RE: MS-DOS commands - list of ??? / Re: WINNT-L Digest

Here's some resources in no specific order: http://gearbox.maem.umr.edu/~batch/batchtoc.htm ftp://garbo.uwasa.fi/pc/ts/ http://garbo.uwasa.fi/pc/batchutil.html http://www.uwasa.fi/~ts/http/http2.html http://home7.inet.tele.dk/batfiles/ http://users.cybercity.dk/~bse26236/batutil/batutil.htm

RE: OEM Repos install error.

Thanks for the help with this guys, I have now upgraded to 2.2 in a seperate Oracle_Home, and all is working sweet as a nut. Cheers Mark -Original Message- Naude Sent: Tuesday, April 03, 2001 11:21 To: Multiple recipients of list ORACLE-L Hi Mark. Yea, 2.2 is worth the wait, but if

RE: Unix memory used

Michael, Yes, that's what I want to do. In fact, I've pin pointed some areas, such as redolog buffers that can user larger memory segments. However I do not want to do this at the expense of the servers total memory use. That's why I'm wondering about the overall memory use (all databases and

Re:can I set a default index tablespace??

John, Unless you specify the index's tablespace it ends up in the users default tablespace. The only other way I can think of to do what you ask is to create table, change the users default tablespace then build the indexes. Dick Goulet Reply

RE: SQL Command to view stored procedure

Easiest bet is to use any one of the gui tools available, such as Toad, or Procedure Builder, etc... hth, Yosi -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 5:07 PM To: Multiple recipients of list ORACLE-L Subject: Re: SQL Command to

Re: Linux ver and Oracle

I'll be installing Suse 7.1 with Oracle this week. I'll let ya'll know how it goes. Jared On Mon, 2 Apr 2001, Ron Rogers wrote: List, I am playing with the idea of loading my PC with Linux and Oracle for test purposes( We have to migrate from Novell in the near future). What have you

Re: Indexes causing a slowdown

Yep. As you're loading, Oracle keeps trying to re-balance the tree. Oracle 8i handles this better. I have a client who avoided this problem by reversing the order of the digits of the sequence generated key, so, for example, if your next key is 123456789, you would reverse that and use

RE: Metalink Again

Title: RE: Metalink Again LOL!! == -Original Message- == From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] == Sent: Wednesday, April 04, 2001 12:41 PM == To: Multiple recipients of list ORACLE-L == Subject: RE: Metalink Again == == == Suprisingly, I just logged on and it took only

RE: Unix memory used

Title: RE: Unix memory used -Original Message- From: David Miller [mailto:[EMAIL PROTECTED]] There are lots of papers/documents on the web describing how Solaris uses memory and tools to monitor usage. One place to start is:

l'market / RE: Metalink Response ....FYI

Waiting is probably good. Besides knowing a couple of investment advisors (fellow soccer/little league dads, members of theology study study groups, and so forth), I try to listen to Louis Rukeyser's show on PBS every week (http://www.pbs.org/mpt/rukeyser), and as much of Bob Brinker's

Re: Recovery Manager vs. SQL Back Track

SQL-Backtrack was a good product at one time. In theory it still is. Here's the problem though. When Data Tools sold SQL-Backtrack to BMC, it seems that anyone that knew anything about the product left. There is no one in tech support that can help you beyond the menu items. There is no one

PL/SQL - invail declare of char

Hello, I know I am missing something. I just can't see it right now. Could someone please tell me what is wrong here? We use version 8.1.6 on Spar Solaris 7. I am getting the following error when I try to create this function as sys. PLS-00201: identifier 'CALANDERSTRING' must be declared

RE: 'PMON did not start after 120 seconds'

Title: RE: 'PMON did not start after 120 seconds' What version of oracle and OS? I have seen this on 8.1.7 on hp when trying to use asyc i/o and the setprivgrp command has not been run. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is

RE: can I set a default index tablespace??

Not as far as I know John, if so I should think it would be a part of the ALTER USER command, and there is no listing for this in any manual or book I have read. List correct me if I'm wrong, as I'd love to see this too.. Regards Mark -Original Message- Sent: Wednesday, April 04, 2001

RE: Metalink Again

A TRS-80? Why not a Sinclair? : ) -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: Metalink Again Suprisingly, I just logged on and it took only a second.

OEM

I don't use OEM but am considering starting to use it. One requirement is that after an Oracle instance starts, then a number of Unix scripts need to be run. How easily, if at all, does OEM provide the ability to invoke scripts both before after both STARTUP SHUTDOWN; in other words before

RE: PL/SQL - invail declare of char

Niel, You have declared CALAND'A'RSTRING. Change that from 'a' to 'e'. Prakash -Original Message- Sent: Wednesday, April 04, 2001 2:41 PM To: Multiple recipients of list ORACLE-L Hello, I know I am missing something. I just can't see it right now. Could someone please tell me

Re: PL/SQL - invail declare of char

You didn't spell calanderstring consistently bi guy...(calendarstring...) [EMAIL PROTECTED] 04/04/01 02:41PM Hello, I know I am missing something. I just can't see it right now. Could someone please tell me what is wrong here? We use version 8.1.6 on Spar Solaris 7. I am getting the

RE: Metalink Response ....FYI

ROFL! On 3 Apr 2001, at 19:35, Steve Adams scribbled with alacrity and cogency: ... There have been growing pains, mostly caused by Oracle bugs, but they certainly seem to be able to make their Oracle stuff scale much better than MetaLink does. Maybe its because of the performance consultant

Re: Oracle client install 8.1.7

This may be a weird idea, but if you have bandwidth, you could experiment by downloading the free Forms6 (Developer6?) stuff from technet, and look at the installer on that. regards, ep On 4 Apr 2001, at 1:45, John Dunn wrote: Date sent: Wed, 04 Apr 2001 01:45:26 -0800 To:

table/index space usage

I need to determine how much space some tables/indexes are really using, as opposed to how much is allocated to them. Anyone have a script you'd be willing to share? Cheers! -- My employers like me, but not enough to let me speak for them. Greg Norris Sprint LTD Database Administration

RE: l'market / RE: Metalink Response ....FYI

example: http://news.morningstar.com/doc/article/0,1,4382,00.html?hSection=fromAnalysts ---excerpt--- ... One Hand Washes the Other I was talking to a reporter a couple of days ago about some upcoming accounting changes that could potentially boost some companies' reported earnings by

RE: PL/SQL - invail declare of char

Neil, I bet you saw your spelling error the second you hit send. ;-) calendarString vs. calenderString Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED] -Original

RE: PL/SQL - invail declare of char

Easy one, Neil, you spelled calendar two different ways. (both of which are incorrect, not that it matters!) calandarString CHAR(10) := ' '; RETURN (calanderString); -Original Message- Sent: Wednesday, April 04, 2001 11:41 AM To: Multiple recipients of list ORACLE-L Hello,

RE: DB2 forums/listserves

Title: RE: DB2 forums/listserves Also, DB2-L Send note to: [EMAIL PROTECTED] Subject: blank or space Body of note: subscribe DB2-L firstname lastname DB2 Level 1 and Level 2 monitor this list, and all the vendor company reps participate. -Original Message- From: Marin

RE: How can I tell if an index is a function-based index/

Jack, Thanks for your helpful reply. Looks like my index is not function-based. Darn! Now I don't know why I'm getting this error and Metalink won't let me in to update my TAR. Cherie

killing a thread

Is there a way to kill (other than kill session) a thread that is doing an insert - nologging? I have tried "alter system kill session" to no avail. It gives me the message "marked for kill" but the process continues to hang. The process has a row exclusive lock with a lock type of TM(dml).

advanced replication error v8.1.7 ORA-01403

When running master to master replication, we experience an error that caused a deferred sys transaction error. The cause of the original error is fixed and we attempted to run DBMS_DEFER_SYS.EXECUTE_ERROR to rerun the transaction in error. This fails with the same original error of ORA-01403.

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

Thanks all of you for reply. I'm now use following to adjusted the logic: declare V_AKTIV_NR aktiv.AKTIV_NR%TYPE; V_PROBLEM aktiv.PROBLEM%TYPE; V_ENDDAT aktiv.ENDDAT%TYPE; V_ENDUHR aktiv.ENDUHR%TYPE; V_AUSSAGEW aktiv.AUSSAGEW%TYPE; V_LANGTEXT aktiv.LANGTEXT%TYPE; V_LONGTEXT VARCHAR2(2);

Re: can I set a default index tablespace??

Hi ! I don't think it so. But there is an enhancement request pending with Oracle (I don't have the number right now) pending with oracle. Probably in next versions. So they answer is NO. = Have a nice day !! Best Regards, K

RE: l'market / RE: Metalink Response ....FYI

another example: http://www.tcwgroup.com/press4.shtml - This guy was on Rukeyser's show several weeks ago, and reportedly has a knack for picking good tech stocks amidst the rubble: http://www.tcwgroup.com/bios/bickerstaff_glen.htm ---

RE: can I set a default index tablespace??

Mark, Yeah, I've wanted that for years. I tried to automate changing the User's default tablespace in a Before Create trigger on a schema, but couldn't figure out how to tell if an index was being created and, anyway, you can't do that kind of DDL in that kind of trigger. What I've done is run

RE: Unix memory used

I guessed (emphasis on "guess") that you weren't using the memory you had because you originally showed your SGAs were very small. I looked at a Sun server that I run 2 databases on and the Total SGA for my training database was 35 MB, while my production was over 100Mb. Another thing I said,

RE: table/index space usage

Gregory, This will give you the number of extents allocated and the the last used block# for a given segment. select extent_id+1, block_id from dba_extents where extent_id = (select max(extent_id) from dba_extents where segment_name =

Re: Re: bFILES Recovery Manager

Hello! Does recovery MANAGER support bfiles? if so any idea when Oracle plans to support them? THanx - Original Message -- [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:[EMAIL PROTECTED] Date:Wed, 04 Apr 2001 10:20:29 -0800

RE: table/index space usage

Also use dbms_space.unused_space procedure. This gives the number of unused blocks. You need to subtract this from the below formula to get the exact size. -Original Message- Sent: Wednesday, April 04, 2001 2:48 PM To: '[EMAIL PROTECTED]' Gregory, This will give you the number of

RE: Metalink Again

MMmmm TRS-80. what's a Sinclair? -Original Message- Patrice J Sent: Wednesday, April 04, 2001 3:02 PM To: Multiple recipients of list ORACLE-L A TRS-80? Why not a Sinclair? : ) -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent:

Compare tow schemas

Hi! I know there has been a thread about this topic recently, but I can't find the emails... And the archives don't have them either. Does anybody have a script to compare two schemas and show the differences? I know that I can do it with TOAD, but I would need the script anyway. Sorry for

OT : Sinclair was RE: Metalink Again

Sinclair was a brand of personal computers that came out in the UK about 20 years ago, If memory serves , they started of with the ZX 81 which had a whole 1K of memory. Their next offering was the Spectrum 16K followed by the 48K. with rubber keys and programmable in basic. I remember back in

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

Probably you are exceeding the length of the PL/SQL variable when you are assigning values to it. Check the length by inserting the following line in your code: dbms_output.put_line(length(V_LONGTEXT)); dbms_output.put_line(length(V_LONGTEXT_TRIM)); -Original Message- Sent:

OT - RE: Metalink Again

Sinclair Spectrum and Z80 (UK built machine I think)... I used to have a Sinclair Spectrum... top of the line at 48Kb of RAM. I used to spend my time trying to load games into memory from tape and then copy them back to another tape. The games used to be copy proof... they used to poke a value

RE: killing a thread

did you try alter system kill session immediate? -Original Message- Eric Sent: Wednesday, April 04, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Is there a way to kill (other than kill session) a thread that is doing an insert - nologging? I have tried "alter system kill

RE: OT : Sinclair was RE: Metalink Again

Wow, it was like the Tandy for the UK. I didn't get my first computer until I was like 20 or 21. I am jealous of all of the people who got started early. -Original Message- [EMAIL PROTECTED] Sent: Wednesday, April 04, 2001 4:16 PM To: Multiple recipients of list ORACLE-L Sinclair

RE: OT : Sinclair was RE: Metalink Again

I had a Spectrum 48K and the rest of the story is about the same for me. Same downward spiral and all... -Original Message- Sent: Wednesday, April 04, 2001 4:16 PM To: Multiple recipients of list ORACLE-L Sinclair was a brand of personal computers that came out in the UK about 20

Re: Linux ver and Oracle

I am running Caldera Linux 2.5 (?) and Oracle 8.1.7 rel 2. Installed cleanly. Runs flawlessly. This is a personal sandbox not production. Pete Barnett Oracle Database Administrator Regence BlueCross BlueShield [EMAIL PROTECTED] On Wed, 4 Apr 2001 [EMAIL PROTECTED] wrote: I'll be

Re: HP environment - standby db?

I would try to answer your questions by a series of observations 1. Only upto 4 ARs could be attached to a L or N class HPs. Moreover this is possible only if you daisy chain the 2 ARs which will in turn degrade the performance . 2. The Parallel server Option has to be approached with

RE: OT : Sinclair was RE: Metalink Again

In 1982ish, Dad brought home a used TRS-80 mod III with 16k ram and a tape drive. Started a downward spiral. I tried to get out, no I really did. Got a degree in mathematics instead of CompSci. Joined the Air Force as an aircraft maintenance officer. But alas, it didn't last. I spent my time

RE: OT : Sinclair was RE: Metalink Again

I've got my Commodore 64. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] Any more spectrum owners out there that want to admit to it ? -- Please see the official ORACLE-L FAQ:

RE: OT : Sinclair was RE: Metalink Again

On Wed, 4 Apr 2001,Dasko, Dan scribbled on the wall in glitter crayon: -In 1982ish, Dad brought home a used TRS-80 mod III with 16k ram and a tape all you youngsters! i started programming in 1968 [yes i *am* that old, yes we *did* to have computers back then.;-)] first project was a payroll

Re: Re: bFILES Recovery Manager

On 4 Apr 2001, Cyril Thankappan wrote: Hello! Does recovery MANAGER support bfiles? if so any idea when Oracle plans to support them? THanx I don't know, but I doubt it. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED]

RE: OT : Sinclair was RE: Metalink Again

Yea I started with the ZX 80, got a kit and built it. My background is on the hardware end of MainFrames, so I borrowed a Logic Analyzer from Work, hooked it up, and scoped all the revelent CPU timings, using memory loops and BIOS calls, what fun that was. Then we got the TIMEX version of

  1   2   >