RE: How apply cursor attribute to non-cursor %NOTFOUND

no need to use exit ...the for loop exits automatically... rgds, Ams. -Original Message- DBA Sent: Monday, August 19, 2002 8:19 PM To: Multiple recipients of list ORACLE-L i have a question how can I apply cursor attribute to non-cursor? what should I put at ??? in the code. Thanks in

RE: Suggestions for a single sign on in Forms and Reports ....

use the concept of "single login" facility rgds, Ams. -Original Message- Michael Sent: Tuesday, August 20, 2002 2:03 AM To: Multiple recipients of list ORACLE-L Just got back from vacation and have been dragged into a working group on a problem the users find unacceptable on one o

RE: Catalog & target db on different version & O/S

Hi Thanx all for reply. Tim my both the database are 8i but different release 1)Target 8.1.5 on Solaris 8 2)Catalog db 8.1.6 on Win2k will different O/S and different version be a problem Pawan -Original Message- Sent: Monday, August 19, 2002 11:58 PM To: Multiple recipients of list O

Re: how to reduce SQL*Net more data to client wait event

Suhen, I can't see the report your link is pointing at, but I guess that the "more-data-to-client" event is a big part of total waittime. Basically the event indicates, that the server is trying to send data to the client for a second, third time. Meaning that the it is sending consecutive

RE: Hot Backup using EMC /BCV splits

Hi, The logic should be like this 1. tablespace begin backup 1a. archive log current 2. suspend database (or sleep) 3. EMC synchronized standard volume and bcv 4. after all mount point (datafile) synchronized EMC split 4a. after EMC split you can mount your bcv

Re: Win2000/8.1.7.3.0/SQL

Mike, Is the DEGREEE on the table > 1? You can see this in DBA_TABLES. If the degree of parallelism is > 1 then CBO will be used regardless of OPTIMIZER_MODE or OPTIMIZER_GOAL. Using a RULE hint will override the optimizer settings. I'm guessing that degree is > 1 and you have old statistics

how to reduce SQL*Net more data to client wait event

Hi,   I am tuning a system at a client site and notice lots of waits for SQL*Net more data to client (97%) for a fraction of the CPU consumed by the system.   I know this is not to be characterized as an idle wait event and can yield better performance if we increase the packet size.

RE: Win2000/8.1.7.3.0/SQL

Ok...this is strange. The optimizer_mode is set to RULE, but if I put a RULE hint into the SQL it runs OK. I tried increasing the sort_area_size, but no joy. The segment with the largest number of extents is the silly TEMP segment with 985. After that is IDL_UB1$ with 739, and it tapers off qu

Oracle OPS and IBM VSD

Once you allocate a tablespace within a VSD (Virtual Shared Disk) file system, can you ever drop the tablespace and re-use that space for something else?   (ex: chaining is a huge issue at this site, and there is not enough rollback space to analyze some of the table for chained rows... coul

RE: Win2000/8.1.7.3.0/SQL

Mike, > Hmmm...that's a possibility. However, the query is blowing out a > 2GB temp space that is empty when the query starts. I'll check > and play with this field anyway. A 100046 trace would be a good tool to use in the case... Alternately, just use the 'alter session set sql_trace = TRUE'

RE: Win2000/8.1.7.3.0/SQL

Title: RE: Win2000/8.1.7.3.0/SQL Just a WAG, but do any of your objects have a huge number of extents? Dan. > -Original Message- > From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 19, 2002 4:23 PM > To: Multiple recipients of list ORACLE-L > Subject:

RE: Win2000/8.1.7.3.0/SQL

Hmmm...that's a possibility. However, the query is blowing out a 2GB temp space that is empty when the query starts. I'll check and play with this field anyway. Thanks, Mike -Original Message- Sent: Monday, August 19, 2002 4:18 PM To: Multiple recipients of list ORACLE-L The order by

RE: Win2000/8.1.7.3.0/SQL

or is that 1 db set to first_rows? If so try the query with a rule hint? Bruce Reardon -Original Message- Sent: Tuesday, 20 August 2002 8:49 Mike, > ...and it works great everywhere. Well, almost everywhere, and > there's the rub. Thie query works on my 7.3, 8.0, 8i, 8iR2, and > most

RE: Win2000/8.1.7.3.0/SQL

John: > Does that particular Db have it's SYS schema ANALYZED? This should return no > rows - if it does, then you can drop the stats for SYS and run this query > again. Nope. Checked that already, but I checked it again. Any other suggestions? Thanks, Mike -- Please see the official ORACLE-L

Re: Win2000/8.1.7.3.0/SQL

The order by is dong a sort and you have insufficient sort space configured so it is doing it to disk and that is the temp tablespace or whatever is allocated as the users temporary tablespace. I suspect that this database has the smallest SGA for any of the databases you have tested. You migh

RE: How to clone a local database from 9i server to a remote 8i server

Hi All, Thank you all for your helpful information.  I do appreciate it very much.  I am working on it at the moment.  Will need your input again very soon. Thanks Lenka  Abdul Aleem <[EMAIL PROTECTED]>wrote: Perhaps: 1- Using materialized views on 8i Server from tables in 9i server. 2- Conn

RE: Win2000/8.1.7.3.0/SQL

Mike, > ...and it works great everywhere. Well, almost everywhere, and > there's the rub. Thie query works on my 7.3, 8.0, 8i, 8iR2, and > most 8iR3 databases. In this one database, on Windows 2000, it > blows out the TEMP tablespace. Every time. And this is the only > system where that happ

Win2000/8.1.7.3.0/SQL

Hi Gurus: I have this SQL, see... col segment_name format a30 heading "Segment Name" col maxseg format 9,999,999.9 heading "Largest|Segment (MB)" col segment_type format a15 heading "Segment|Type" col pct_increase format 999 heading "Pct|Incr" col next_ext

Suggestions for a single sign on in Forms and Reports ....

Just got back from vacation and have been dragged into a working group on a problem the users find unacceptable on one of our new systems. Has anybody had any experience with Forms / Reports through the 9IAS server such that one can be authenticated using the unix login/password without having to

RE: SQLNet and NET8

You can have one app using separate oracle home. A little bit of coercion, brute force and violence directed to the application vendor would also help > -Original Message- > From: Satish Iyer [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 19, 2002 5:39 PM > To: Multiple recipients of

Re: Catalog & target db on different version & O/S

Thanks for the support, I knew I was right but I was even questioning myself. RBG - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, August 19, 2002 5:33 PM > Ruth is correct. > > --Walt > > -Original Message- > Sent: Monday, August

SQLNet and NET8

Is it possible to have SqlNet and Net8 installed on the same client machine ? The reson behind this is that on the same machine we have an 3rd party application which can connect only through sqlnet and for the rest of the apps we want to use net8. Any ideas on this configuration should be done.

RE: Catalog & target db on different version & O/S

Ruth is correct. --Walt -Original Message- Sent: Monday, August 19, 2002 2:48 PM To: Multiple recipients of list ORACLE-L > The rcvcat(8.0.x) or rcat > (8i) is the database which hold the recovery catalog. It has to be the same > or higher version than the target. That bit *does* so

Re: Index move

Title: RE: Index move I always want to learn :-) - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Monday, August 19, 2002 8:28 PM Subject: Re: Index move Go get 'em, big guy! - Original Message - From:

RE: Catalog & target db on different version & O/S

I agree. The rcvcat has to be a higher (or equal) level than the target. I've even had problems with them being at different levels (but I think this was early versions of Rman). I would not run an Rman catalog at a different level than the target db for a very long time - get'em both at the s

Re: Catalog & target db on different version & O/S

> The rcvcat(8.0.x) or rcat > (8i) is the database which hold the recovery catalog. It has to be the same > or higher version than the target. That bit *does* sound familiar. I've only played with RMAN, not yet in production here. Maybe one of the local RMAN gurus can straighten us out here.

Re: Desperately seeking help in deciphering part of sqlnet

Rick, Are you trying to connect across a firewall? Also can you ping both directions client -> server, server -> client? Here is what I think is important in you're trace file: nttcnp: Validnode Table IN use; err 0x0 nttcnp: exit nttcni: entry nttcni: trying to connect to socket 204. ntt2err:

Desperately seeking help in deciphering part of sqlnet trace file

Hi, I am getting a ORA-12535 timeout error when connecting to server. I can tnsping Ok. The environment is Oracle 8.1.6 using NET8 on Win NT. Below is what I believe is relevant part of trace file. However I cannot determine cause of error. Any helps is appreciated. Thanks Rick nttbnd2addr:

Re: Oracle Reports 6i Vs 9i

IMO, 9iAS R2 is _OVERLY_ complex, complicated & confusing. I was forced to using R2 because of a _BAD_ memory leak in the f60webm executable in R1. Oracle Tech. Supp. for 9iAS R2 is poor to nonexistent. My advice is to avoid 9iAS R2 if at all possible. "Loughmiller, Greg" wrote: > > Does anyon

Oracle Reports 6i Vs 9i

Does anyone have an opinion as to which is easier to implement, architecture, performance and development differences? We are working on implementing on of these.. We have a standard on App Servers and we need to consider the use of BEA/Iplanet and being used as a proxy... thanks! Greg Greg Lou

RE: Oracle 9.2 Client/Server cnct to Oracle7 NOT Supported

Anybody know anything about the reverse? A 7.3 client with a 9.2 server? TIA, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Monday, August 19, 2002 9:54 AM To: Multiple recipients of list ORACLE-L An Oracle Alert Note 207319.1 has been issued

Re: WG: Re: Data Warehouse on Windows

Hi, Sure that Sybase has not all the nice features Oracle has but I'm a bit surprised that you find it way too slow, do you have Sybase 12.5 ? 12.5 has interesting new features compare to 11.9 version. "20 users doing ad hoc queries ..." I supposed you have a tool like Business Objects or Cogno

Storing/retrieving DES3 data w/Perl

Hi all (especially Jared!), I'm trying to store a password in an Oracle 8.0.5 table using Perl and DES3. I've tried making the attached Perl, but I can never get the password to return correctly. My guess is that there is some casting going on that is hosing up the raw data. I've got the "valid

Re: Upgrade from 8.1.6 to 9.2.0

Thanks Raj I know that I can import/export. I want to convert the existing DB. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, August 19, 2002 8:48 PM > We are upgrading from 8161 to 92. You can export from 8161 and im

Re: Catalog & target db on different version & O/S

I thought that the target database was the one being backed up, at least that is what you put in the target statement. The rcvcat(8.0.x) or rcat (8i) is the database which hold the recovery catalog. It has to be the same or higher version than the target. Ruth - Original Message - To:

Re: Index move

Title: RE: Index move Go get 'em, big guy! - Original Message - From: Anjo Kolk To: Multiple recipients of list ORACLE-L Sent: Monday, August 19, 2002 11:43 AM Subject: Re: Index move "having the index on a different disk from the table should give you bett

RE: Upgrade from 8.1.6 to 9.2.0

We are upgrading from 8161 to 92. You can export from 8161 and import into 9.2, that is supported. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't re

Upgrade from 8.1.6 to 9.2.0

I tried to upgrade a test (my private) database from 8.1.6 to 9.2.0. I got a MSG: Converting from 8.1.6 to 9.2.0 not supported. Upgrade to 8.1.7 or 9.0.1 and then to 9.2.0. Since we have about 15 servers it seems silly to me to do 2 upgrades on each one. Have anybody encountered this and how did

RE: compile invalid objects SCRIPT

>From the oracle Metalink.. /* Doc ID: Note:1036972.6 DATABASE Type: SCRIPT Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 15-OCT-1997 Last Revision Date: 27-APR-2000 Language: USAENG == Title: == Compiling Invalid Objects in the Da

Re: Catalog & target db on different version & O/S

The RMAN executables and scripts have to reside in a server running Oracle8.x and above (i.e. the "target" database server), but the database housing the recovery catalog database is just a database that holds tables, indexes, sequences, views, and stored procedures/functions/packages. RMAN doesn

Re: Data Warehouse on Windows -more

Hello Aleem This is not a boundary. It is a problem if you use autoextend and the file grows from less then 4Gb to more then 4GB. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, August 19, 2002 1:48 PM > Where can I fi

Re: Catalog & target db on different version & O/S

It doesn't need RMAN to be a repository. "Ruth Gramolini" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/19/2002 09:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Catalog & target db on

Re: Index move

Unlikely. If you can a balanced load across the disks you have available where "balanced" means evenly spread across: - short peak volume timescales - longer summary timescales then you'll be pretty close to optimal. That does not necessarily mean separating data from indexes hth connor -

RE: Tuning methodology (was T3's) and use of NetApp's

Thank you, Anjo. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Next event: Miracle Database Forum, Sep 20-22 Middel

Re: How apply cursor attribute to non-cursor %NOTFOUND

The FOR-LOOP will automatically exit and "close" the cursor when no more rows are available. For implicit cursor SQL, you can use SQL%NOTFOUND. eg begin update blah set x = y; if sql%found then ... end if; end; hth connor --- EntryLevel DBA <[EMAIL PROTECTED]> wrote: > i have a q

Re: Index move

Title: RE: Index move "having the index on a different disk from the table should give you better performance."   Why ? - Original Message - From: Whittle Jerome Contr NCI To: Multiple recipients of list ORACLE-L Sent: Monday, August 19, 2002 7:24 PM Subject: RE:

ora 14130 when doing an alter table exchange partition

Hi. I'm getting an ora-14130 error when trying to exchange a partition with a table. Both table and partition have the same set of the indices, constraints. All indices/constraints are enabled and have the same fields. The only way I can fix it is to rebuild the indices. Does anyone have any id

RE: Reasons to upgrade from Oracle 7.3.4 to 8i

I'd suggest support. Issues I've seen are the hardware needs replacing, they don't make that size of hard drive any more, that version of the operating system doesn't support the new hard drives that are available. The new version of the operating system isn't supported by Oracle 7.3.4. The

RE: Index move

Title: RE: Index move Seema, The big question: where is the table? Forgetting about RAID, having the index on a different disk from the table should give you better performance. As far as moving the index to another tablespace without considering the table, it depends on what else that dis

Re: Catalog & target db on different version & O/S

But it does not include rman...and EBU won't do it. RBG - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, August 19, 2002 10:53 AM > > I'm not recommending 7.3.4 for the repository > > Why not? > > It seems to be the most stable 7+ version

RE: patch url needed please.

The last time I went to the patch download area on metalink, there was a new link to ftp://updates.oracle.com. You can't browse this server, but you can get a patch if you know the patch number and file name as ftp://updates.oracle.com//. You can get these from metalink. For instance, the Solaris

Index move

Hi Is any performance gain/impact if I move unique indexes from one tablespace to another tablespace if both tablespaces are on diffrent physical disk? Thanks -Seema _ MSN Photos is the easiest way to share and print your photos:

Data Modeling: Good, Bad & Ugly

Our current practice today: a developer asks a DBA for a table and they create it (no modeling is done). I believe that someone within our IT should be doing some logical modeling (& conceptual??) and turning that over to the DBA for the physical modeling. I am looking for some thoughts related

Re: Reasons to upgrade from Oracle 7.3.4 to 8i

And don't forget you can use rman with 8x. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, August 19, 2002 11:28 AM > Not "completely unsupported" - plenty of old patches exist and can be > downloaded and applied. There's tons of su

Re: Reasons to upgrade from Oracle 7.3.4 to 8i

I would say the same thing, but "unsupported" generally means that new patches aren't being produced, period. It doesn't mean "we won't answer the phone" or "we won't respond in TAR". If they're paying for support, then Oracle has to provide support... They are holding a pretty unassailable pos

RE: patch url needed please.

You can get the Windows one here - http://ap103aru.oracle.com/ARULink/PatchSearch/process_download/p2376472 _8174_WINNT.zip?patch_file=p2376472_8174_WINNT.zip&aru=1797444&email=unk nown Don't know about other platforms... -Original Message- Sent: Monday, August 19, 2002 10:14 AM To: Mu

How apply cursor attribute to non-cursor %NOTFOUND

i have a question how can I apply cursor attribute to non-cursor? what should I put at ??? in the code. Thanks in advance Dave DECLARE BEGIN For i IN (SELECT * FROM EMP) LOOP EXIT WHEN ???%NOTFOUND; /*SOURCE CODE*/ END LOOP; END;

Re: ORA-12500: TNS:listener failed to start a dedicated server process

Interesting. When installing Oracle 8.0.4 on NT, there are 2 versions of the listener installed, tnslsnr.exe and the 'new' tnslsnr80.exe. A service is installed for each. For some reason, the old tnslsnr.exe is setup to start automatically, while the newer tnslsnr80.exe is not. Try connecting

RE: Reasons to upgrade from Oracle 7.3.4 to 8i

Not "completely unsupported" - plenty of old patches exist and can be downloaded and applied. There's tons of support docs on solving issues aside from applying patches. If the DB crashes (which doesn't happen often as the databases are usually stable and the hardware unchanging) support will work

executing shell script from a stored proc?

Hi all: Sorry for the (seemingly) easy question, but is it possible to execute shellcode from inside a stored procedure? Platform is Oracle 9.2.0.1 on Solaris 2.8 I understand that there are ways to do it using java or Pro*C, but I don't know which resources to use, and I'm hoping that somebody

patch url needed please.

Hi all. Does anyone have the url for the ftp site to download the Oracle 8.1.7.4 patch? Every time I click on the download button, it downloads the web page, and not the zip file. So I am trying to download it via download accelerator, but need the URL. Any help would be great. Thanks Clint --

Re: Reasons to upgrade from Oracle 7.3.4 to 8i

It doesn't matter that Oracle no longer supports 7.3.4 and any changes in hardware/OS/etc may force an upgrade? Extended Maintenance Support ends at the end of 2002, so that's it for bug fixes (I wonder if that includes security patches?). Certification with supported products, newer OS versions

RE: Data Warehouse on Windows

Oracle licenses are generally sold per CPU or per user, and cover only the machine on which the license was purchased for. We have a licensing arrangement that is per user and covers that user on any system we wish to put a database on. I don't know if Oracle still sells licensing that way. I d

Exportable Users?

Title: Exportable Users? Hello Guru's Oracle 817 and Win2K I'am experimenting with a script - hopefully in the right direction. The idea is to create a list of users who own any object and thus should/could be exported.  -Script so far -  SELECT owner FROM all_objects, all_users  W

Re: Reasons to upgrade from Oracle 7.3.4 to 8i

Andrey, Playing Devil's advocate, the only valid reason I can think of is due to support issues. An unsupported version of Oracle is something of problem should you find new bugs. The platform it's on will no doubt leave it's support window at sometime in the future. If the customers are happy

Re: Reasons to upgrade from Oracle 7.3.4 to 8i

Did you try telling them that 7.3.4 is not supported by Oracle anymore and they shouldn't be running an important database on an unsupported version? Gene --- Andrey Bronfin <[EMAIL PROTECTED]> wrote: > Dear gurus ! > I know it's a "beaten to death horse", but... > I want to convince a customer

Re: Catalog & target db on different version & O/S

> I'm not recommending 7.3.4 for the repository Why not? It seems to be the most stable 7+ version available. :) Jared "Tim Gorman" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/19/2002 06:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAI

RE: Reasons to upgrade from Oracle 7.3.4 to 8i

How about the fact You are completely unsupported by Oracle in that version. "Simplicio Noronha,

ORA-12500: TNS:listener failed to start a dedicated server process

Hi DBAs, This is a partial response from Oracle on ORA-12500: TNS:listener failed

Oracle 9.2 Client/Server cnct to Oracle7 NOT Supported

An Oracle Alert Note 207319.1 has been issued : Connections from Oracle 9.2 to Oracle7 are Not Supported This alert documents a restriction introduced in Oracle 9.2.0.1 which was omitted from the shipped documentation / README files. Versions Affected Oracle9i Release 2 (9.2.0.1) onwards is

RE: SCO UNIX

8.1.7 is terminal release for SCO. If you want Intel hardware, use Linux (Suse ? - Red Hat ?) -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Atul Kumar Srivastav Enviado el: lunes, 19 de agosto de 2002 14:59 Para: Multiple recipients of list ORACLE-L As

RE: Reasons to upgrade from Oracle 7.3.4 to 8i

What about 1) OOP support 2) Java support Regards Savio -Original Message- Sent: Montag, 19. August 2002 15:33 To: Multiple recipients of list ORACLE-L Dear gurus ! I know it's a "beaten to death horse", but... I want to convince a customer to upgrade their OPS 7.3.4 DB to an Oracle 8

Reasons to upgrade from Oracle 7.3.4 to 8i

Dear gurus ! I know it's a "beaten to death horse", but... I want to convince a customer to upgrade their OPS 7.3.4 DB to an Oracle 8.1.7 OPS or even (in a best case for me) to Oracle9i RAC (don't even know whether or not one exists and is supported for Digital UNIX on EMC Symmetrix storage). I am

Re: Catalog & target db on different version & O/S

Years ago, we backed up an 8.1.5 production database (along with it's "dev" environment) with the RMAN catalog housed on an NT workstation running 7.3.4. Worked just fine. We eventually upgraded the NT box to 8.1.5 also, but that was just an export/import and we were off and running again... Th

RE: how to force a log switch - SOLVED !

Thanks a lot to all who replied ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Sunday, August 18, 2002 6:36 PM To: LazyDBA.com Discussion; Andrey Bronfin After researching lot of issues with having smaller size redo logs , we opted for so

RE: OPS 7.3.4 - DONE. THANKS !

Thanks a lot to all who replied ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 14, 2002 4:24 PM To: Multiple recipients of list ORACLE-L Requirements: 1. Database must be reconfigured/rebuilt. 2. All datafiles must resi

SCO UNIX

Hi everybody, Could anybody tell which is the latest version of SCO UNIX. and does Orale 8i DB works on that. Any info of Oracle on SCO unix. Thanx in advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Atul Kumar Srivastav INET: [EMAIL PROTECTED] Fat City N

RE: Data Warehouse on Windows -more

You can search metalink for "4gb boundary" or "windows 4gb corruption" - both of these should raise various notes which refer to it. But, as already mentioned if you ensure AUTOEXTEND is OFF you'll have nothing to worry about. AFAIK this is only a WINDOWS problem. Lewis Bishop --- Barclays Enable

RE: Data Warehouse on Windows -more

-- Abdul Aleem <[EMAIL PROTECTED]> > Where can I find the more information on this boundary? Is there any such > limit for Oracle/Linux? Corruption, not that I've seen. Unless you compile the kernel w/ extended memory translation turned on. The default looks something like: CONFIG_NOHIGHM

RE: Materialized View

Title: RE: Simple question on logging.. Not sure but I think you need to have Enterprise Edition for that. Otherwise it should work fine   Aleem   -Original Message- From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 5:18 AM To: Multiple recipients

RE: How to clone a local database from 9i server to a remote 8i s

Title: RE: How to clone a local database from 9i server to a remote 8i server site Perhaps: 1- Using materialized views on 8i Server from tables in 9i server. 2- Connecting from 8i server to 9i server, taking backup (exp) of 9i Server, from 8i server and restoring it on 8i server.   HT

Re: Catalog & target db on different version & O/S

Pawan, look i the rman manual for the compatability index. I've got it in the 9i docs, so worst case you can check it out at technet.oracle.com joe Pawan Dalmia wrote: >Hi List, >I am planning to start taking backups through RMAN.Database is around >60GB(Solaris Oracle 8.1.5) and therfore i

RE: Data Warehouse on Windows -more

Where can I find the more information on this boundary? Is there any such limit for Oracle/Linux? TIA! Aleem -Original Message- Sent: Thursday, August 15, 2002 7:44 PM To: Multiple recipients of list ORACLE-L Subject:RE: Data Warehouse on Windows Don't forget the Oracle/W

RE: Data Warehouse on Windows

Jard, "If you're not already under some kind of license that covers existing users on a new system, Oracle will likely tell you that you need to license per CPU." As we are on licensing with Oracle, I would appreciate if you could elaborate what you mean by "covering on new system". TIA! Alee

RE: Convert PL/SQL to Java

What about SQLJ? You can wrap the entire PL/SQL code inside a SQLJ file and use it as such without converting it into Java HTH Naveen -Original Message- Sent: Monday, August 19, 2002 4:03 PM To: Multiple recipients of list ORACLE-L Does that actually convert PL/SQL to java, or just put

Catalog & target db on different version & O/S

Hi List, I am planning to start taking backups through RMAN.Database is around 60GB(Solaris Oracle 8.1.5) and therfore i am planning to using Catalog.Since There is no space on our solaris box i am planning to create catalog db on WIN2K machine(Orcale 8.1.6) . will there be compatiblity issues c

RE: Convert PL/SQL to Java

Does that actually convert PL/SQL to java, or just put some sort of java wrapper around the PL/SQL? John > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: 16 August 2002 07:23 > To: Multiple recipients of list ORACLE-L > Subject: Re: Convert PL/SQL to

Re: how to force a log switch

No, but this is close... "ARCHIVE_LAG_TARGET ARCHIVE_LAG_TARGET limits the amount of data that can be lost and effectively increases the availability of the standby database by forcing a log switch after a user-specified time period elapses. A 0 value disables the time-based thread advance feat

RE: Moving to UK - what are Oracle contracts like?

It works both ways. My english agent phoned me and told me she was heading out to Oz for a couple of years. She was taking her motor scooter because she intended going around the continent "scooting from village to village"... I have visions of skeletal remains next to a scooter just outside Eu

RE: compile invalid objects

@?/rdbms/admin/utlrp.sql hth connor --- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> wrote: > I have written scripts like this in the past, but > the problem > I run into is that recompiling some objects > invalidates others, > sometimes in a circular loop. What I'd like to > find/see/learn-ho

RE: Amount of redo

Hi, I am highly thankful for u replies as a result i was able to take imp. decission. Pawan -Original Message- Sent: Sunday, August 18, 2002 3:38 PM To: Multiple recipients of list ORACLE-L I sit corrected. Yechiel Adar Mehish - Original Message - To: Multiple recipients of

Re: Tuning methodology (was T3's) and use of NetApp's

On the total_timeouts column: This column has the same meaning for all events (how can it be different?). There are basically two kinds of events: 1) That specificies a timeout value for the wait and can be posted (not needed though) if (posted = wait(max_wait_time)) {

RE: How to clone a local database from 9i server to a remote 8i s

Lenka -   Big (tasty!) job - the following product called DataBee may be of help. Its free. It will capture your entire DDL.   http://www.cool-tools.co.uk/Support/Tutorials/databee_tutorials.html   peter edinburgh   -Original Message-From: Meomeo Nguyen [mailto:[EMAIL PROTECTED]

RE: Moving to UK - what are Oracle contracts like?

LOL I thought that.. And a "town" it most definitely is *not*.. :) -Original Message- Lee - lerobe Sent: 16 August 2002 18:04 To: Multiple recipients of list ORACLE-L Well, thats a new one on me London - beautiful ??? -Original Message- Sent: 16 August 2002 16:59 To: Mul