[Replication] Altering Master Object at materialized view replication environment

Hello How can i replicate DDL on table (modify column for example) in materialized view replication environment ? DBMS_REPCAT.ALTER_MASTER_REPOBJECT alter the object, put changes are not propagated to MV site ... I try DBMS_REFRESH.REFRESH and DBMS_REPCAT.REFRESH_MVIEW_REPGROUP at MV site, but

RE: Minimum required init.ora parameters

No, I tried to startup the DB without compatible parameter. It throws message as the same parameter is required. Nirmal. -Original Message- Sent: Monday, January 13, 2003 5:55 PM To: Multiple recipients of list ORACLE-L compatibility or compatible is not a mandatory init.ora

Info about running procs

Title: Info about running procs Hi list, I'm looking for a Oracle system view or table where I can see all actual running procedures. Where can I find this info. TIA Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de

Re: Different Backups - A Comparartive analysis

Hello Jared AFAIK SQLBackTrack can do a TABLE restore from the backup and RMAN can not do it. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 13, 2003 7:51 PM On Monday 13 January 2003 06:03, Tim Gorman wrote:

Foreign key indexes on individual columns or multiple columns

Hi List, I have a table by name Benchmark_hdr with the following columns: BENCHMARK_HDR_IDNUMBERNOT NULL CALENDAR_TYPE CHAR (1), UOM VARCHAR2 (10), CALENDAR_PORT CHAR (1), CUSTOMER_MOT_ID NUMBERNOT NULL RESP_PARTY_NAME

RE: bitmapped indexes

Hi ! I don't remember where I got the paper, but I am attaching it. Cheers. -Original Message- Sent: ? 13 ? 2003 19:40 To: [EMAIL PROTECTED]; Andrey Bronfin Andrey, Perhaps you could tell us what paper, and where to obtain it. From the context, it sounds like a reference to

slowish query causing problems...

Title: slowish query causing problems... Hello List, Pls help me on this problem. Our application does a validation when it uses a certain screen, as it so happens this screen is used very intensively. The performance is very slow, I have isolated the main culprit. I have tried the

Re: Foreign key indexes on individual columns or multiple columns

Hi, following script may help you. The brief description of the script is as follows. -- REMThis file checks the current users Foreign Keys to make sure of the REMfollowing: REM REM1) All the FK columns

RE: slowish query causing problems...

Eva, Can you send the explain plan and what the indexes are . Is 'INPRG' really a literal and is the sql dynamic and the below is just an example? Iain Nicoll -Original Message- Sent: 14 January 2003 11:29 To: Multiple recipients of list ORACLE-L Hello List, Pls help me on

RE: slowish query causing problems...

Title: slowish query causing problems... Ouch! I hate to see queries written this way...the query should answer the question you are trying to ask. It appears you are checking for the existance of a record in fwepcode1 that matches the criteria. If I understand the query correctly, you

RE: bitmapped indexes

Title: RE: bitmapped indexes It was filtered by Listguru ... where did you get it from? Maybe we can pick it up at the source ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here

RE: Oracle 9i release 3 coming?

Title: Internet file system Hi I think you are seeing notes on the latest release of 9iAS which is 9.0.3. Ben -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Boivin, Patrice JSent: January 13, 2003 9:24 PMTo: Multiple recipients of list

RE: Question On High Parse to execute ratio

Title: RE: Question On High Parse to execute ratio If you are using 9202 and intermedia, intermedia will choke on anything other than exact for cursor_sharing parameter ... and yes, they finally have a patch that works. Raj __ Rajendra

RE: bitmapped indexes

Title: RE: bitmapped indexes But i got the attachment. AFAIK, listguru filters attachments, How did i get it then? Regards Naveen -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 14, 2003 6:24 PMTo: Multiple recipients of list

RE: slowish query causing problems...

Title: slowish query causing problems... Eva, Is there an index on the fwepcode1 table with the three columns used in the where clause? Are the three columns varchar or varchar2? Make sure the EXP column is not a number! Secondly, I think I would change the query as follows: SELECT

dates

I have a table with 1 column. I want to populate it with the dates of all the fridays for the last 2 years and the next 2 years from sysdate. so.. today is 14-JAN-2003 My column will have.. 10-jan-2003 03-jan-2003 ... .. 17-jan-2003 24-jan-2003 Any ideas? Cheers

RE: bitmapped indexes

It's from a paper called Bitmap Indexing in Oracle7.3 and 8.0 which is available at http://www.newagetraining.com/library/ora_dev/sql_plsql/script/BitmapIndexes .pdf http://www.newagetraining.com/library/ora_dev/sql_plsql/script/BitmapIndexe s.pdf The theory is true in relation to data loads

RE: Oracle 9i release 3 coming?

If they release 9.0.3. items for iAS, will they call that iAS 9i Release 3 or iAS 10i? Maybe the version numbers don't mean anything to them anymore... Pat. -Original Message- Sent: Monday, January 13, 2003 11:49 PM To: Multiple recipients of list ORACLE-L doubtful, they've said that

RE: Different Backups - A Comparative analysis

I don't believe RMAN does Oracle block level compression during the backup process. This was one of the original reasons Oracle support was giving SQLBT users trouble when they needed recovery support. Regards, Bill Burke The Kinder and Gentler DBA IOUG University Master Class Faculty 2001-2002

RE: dates

Title: RE: dates SELECT NEXT_DAY(SYSDATE + 7*(rnum-1),'Friday') FROM (SELECT ROWNUM rnum FROM DBA_OBJECTS) / Feel free to add a where clause Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion

RE: encrypted user/passwd connection

http://documents.iss.net/literature/DatabaseScanner/reports/oracle/OraPolicy.pdf Sony kristanto

RE: Conversion from CLOB to RAW

Thanks Dennis, I'm meeting with them this morning at 10 to discuss this in more detail now that I have some feedback from the list, all of which I appreciate. I don't believe they are searching the information, but will know shortly. Regards, Bill Burke The Kinder and Gentler DBA IOUG

RE: Was 8.1.6 certified on Solaris 8?

Title: RE: Was 8.1.6 certified on Solaris 8? We run a couple of apps on 8.1.6/solaris 8 with no problems. Matt Adams - GE Appliances - [EMAIL PROTECTED] My computer beat me at chess, but I won when it came to kick boxing. -Original Message- From: Miller, Jay [mailto:[EMAIL

RE: Oracle 9i release 3 coming?

Actually, I see references to iAS 9.0.3 and 9.0.4 in various places on Metalink. I think the real difference will be when iAS 9.0.6 is released, which at one time was supposed to be this quarter. A lot of things are supposedly fixed/enhanced in 9.0.5 which won't be released to the public.

Re: bitmapped indexes

Title: RE: bitmapped indexes you sure, you got it? Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Naveen Nahata To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 14, 2003 8:34 AM Subject: RE: bitmapped indexes But i got

RE: Minimum required init.ora parameters

Which version and platform ? I've never found COMPATIBLE to be mandatory to startup a database. Every version does set a default value for COMPATIBLE [I believe it is 8.0 in 8.0.x and 8.1.x]. Hemant At 12:58 AM 14-01-03 -0800, you wrote: No, I tried to startup the DB without compatible

Re: Was 8.1.6 certified on Solaris 8?

Yep. I have an old certification matrix hanging on my wall, and it shows that 8.1.6 was supported with 2.6, 2.7, and 2.8 (for 32-bit). (Guess it's time to clean up my cubie!) Barb --- Miller, Jay [EMAIL PROTECTED] wrote: We're upgrading from Solaris 2.6 to Solaris 8 and 8.1.6 to 8.1.7 on one

Re: Internet file system

Chris, iFS 1.X.X and below is alternately with the 8.1.7 database and 9iAS 1.0.2.X 9iFS 9.0.1 is with the Database 9iFS 9.0.2 is part of 9iAS 9.0.2 9iFS 9.0.3 has been renamed as Oracle Files and is part of Oracle Collaboration Suite. Check the MetaLink certification pages for Internet File

RE: slowish query causing problems...

Title: slowish query causing problems... Hello, Thanks for the replies Here is the description of the table and the indexes, pls remember I have removed and tested each index seperately, still insisted on a Full search. 9 indexes is not my idea of a perfect situation these are created by

RE: bitmapped indexes

Title: RE: bitmapped indexes Oops! I had just saved it to be read later. When i try to open it says, 'Corrupted File' Sorry for the confusion Regards Naveen -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 14, 2003 8:15 PMTo: Multiple

RE: bitmapped indexes

The paper says performance is good but concurrency is a problem: Depending on the cardinality of data, this may mean locking several thousand rows at once. For this reason, it may not be a good idea to use bitmap indexes for environments where high levels of concurrent updates to the base data

Oracle 8 DBA with SAP R/3 experience needed- New York

Large national known company in New York City, New York needs an Oracle DBA with SAP R/3 experience to join their corporate IT staff. *PLEASE Do Not send your resume for this position UNLESS you already live in the Greater New York City area and have the skills outlined below for this

RE: Was 8.1.6 certified on Solaris 8?

We are running 8.1.6 against Solaris 8 patch level Generic_108528-15. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, January 13, 2003 3:10 PM To: Multiple recipients of list ORACLE-L We're upgrading from Solaris 2.6 to Solaris 8 and

RE: Minimum required init.ora parameters

Hemant - I believe this applies to Oracle8i versions. The key point is try it. If you have a small test database you can bounce, it will take you just a couple of minutes to comment out the COMPATIBLE parameter and bounce the database. I agree with you that my assumption was that it was

RE: Oracle 9i release 3 coming?

Maybe the version numbers don't mean anything to them anymore... Pat. bingo! Oracle 9iAS 9.0.3 is still Release 2 __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official

Re: Parallel Replication of Single Table

Hi Larry, In the distributed manual it makes a comment about DML serializing when doing remote operations. I am not sure about replication but in the past (on 8.1.5 and 8.1.6 versions) this has been my experience with CTAS over a dblink or DML over dblink in that it serializes. In order to

RMOUG Training Days 2003

The Rocky Mountain Oracle User Group Training Days will be held in Denver, Colorado on March 5 6, 2003. This year's scheduled speakers include Rachel Carmichael,Gary Dodge, David Ensor, Tim Gorman, Ruth Gramolini, Stephan Haisley, John King, Anjo Kolk, Cary Millsap, Craig Shallahamer, and

Re: USER_TABLESPACES has more rows than DBA_TABLESPACES

I'm still confused. They are not in DBA_TABLESPACES, only USER_TABLESPACES.Keith- Original Message - From: "Stephane Faroult" [EMAIL PROTECTED]To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Monday, January 13, 2003 1:34 PMSubject: Re: USER_TABLESPACES has more

RE: USER_TABLESPACES has more rows than DBA_TABLESPACES

Keith, yes, it's regular behaviour that the TS$ entry remains but the discrepancy between those 2 views is a bug which is fixed in 8.0.6. Basically, DBA_TABLESPACES excludes 'INVALID' tablespaces but USER_TABLESPACES doesn't. There are duplicates for the bug. The numbers are 284887, 553723 and

Re: slowish query causing problems...

This query make sense. It should not use full table scan. Denham, did you try that, I am curious to know the answer. Joan Toepke, Kevin M wrote: Ouch! I hate to see queries written this way...the query should answer the question you are trying to ask. It appears you are checking for the

User memory connections...

Hi guys... I would like to know how can I get: how much memory an user connection/session is using? Can u help me? Thanks in advance! Regards! JL __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com

RE: Database/system Crashing

Title: RE: Database/system Crashing Please do. Any information at this point will help. The only difference is that when it fails it doesn't even get to write the /var/adm/messages or the core dump. Oracle wasn't writing to the alert log file until I moved it off the root disk an onto

RE: slowish query causing problems...

Eva, Don't know if the problem is only 3 out of 4 parts of the composite index are used so it can't work out how many distinct values there are of the first three parts only (are you able to try creating an index with only the 3 parts to see what would happen)? Iain Nicoll -Original

Context/Intermedia/OracleText index rebuilds and ORA-29863

Hey all, Spent last night (til the Witching Hour) patching from 8.1.7.2 to 8.1.7.4. During the process, we had all three of our Context indexes trashed. My guess is that it was because CTXSYS.CTX_DDL.INDEX_SYNC() DBMS_JOB was running while the CTX upgrade scripts were running. I thought it was

strange SQL with TOAD

List, We use TOAD as one of our database tools and I was viewing some of the SQL statements that were processed and I can't explain the why the statement is the way it is. The developer wrote Select to_char(sysdate,'mm-dd-') from dual; in a VB application. We use the Oracle and MS ODBC

Re: Different Backups - A Comparative analysis

Ditto what Jared said. It was bad! --- Jared Still [EMAIL PROTECTED] wrote: Yes, well, I've heard that claim too. It may actually work now, but a very capable DBA ( 2 actually ) spent quite a bit of time testing this with no good results. And then there was the SQL BT glitch that

RE: dw tool question

From: Koivu, Lisa [EMAIL PROTECTED] Subject: RE: dw tool question We have two products here: Business Objects and BRIO. It depends on what kind of end-user you expect to support. The main difference I see between these two is that Business Objects can easily hide the metadata detail and joins

redo log placement question

Hi, I understand the reasons most documents suggest not putting redo on raid-5 array. But my situation is limited to either on raid-5 with multiple controllers or on raid-1 with single controller. Raid-5 hosts only database files, Raid-1 hosts OS and Oracle software. What will be the better

RE: dw tool question

One follow-up thought that I neglected to mention before: Business Objects definitely does metadata better. If you're looking for embed a lot of metadata about heirarchies, related tables, source information, etc., then BO will support that better. Brio is okay, but it's not really robust in

RE: Was 8.1.6 certified on Solaris 8?

Thanks everyone! -Original Message- Sent: Tuesday, January 14, 2003 10:51 AM To: Multiple recipients of list ORACLE-L We are running 8.1.6 against Solaris 8 patch level Generic_108528-15. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message-

RE: strange SQL with TOAD

Do you have the Option, Show Rowid enabled under Options/Data Grids-Data ?? -Original Message- Sent: Tuesday, January 14, 2003 11:34 AM To: Multiple recipients of list ORACLE-L List, We use TOAD as one of our database tools and I was viewing some of the SQL statements that were

RE: Database/system Crashing

Title: RE: Database/system Crashing Val, Here is the Sun patch 108727-16 that was related to our problem. Does the system have savecore running? You can try to symbolic link /var/adm to another disk. In our case Oracle never wrote anything to alert log because it was a system crash.

RE: strange SQL with TOAD

Title: RE: strange SQL with TOAD Also, you might try turning off the 'editable queries' in the options. That causes it to do a select rowid, * from table, so that once you edit the grid, it will use the rowid to go back and actually make the update to the data. -Original Message-

RE: strange SQL with TOAD

Ron, Are you using VB with ADO to return XML? ADO does some mighty strange stuff under the covers. If so, then I would guess that this is the cuplrit. My other guess is the VB is doing it in preparation to perform an update using the ROWID column in a where clause. Tom Mercadante Oracle

RE: dw tool question

Title: RE: dw tool question Hi Bruce, Thank you so much for your comments. Turns out I have a lot to learn about Brio. It's not my job to create the metadata layer in the app so I passed that info on to our report programmer. She knew exactly what you were talking about whew! I really

Re: perl timeout

Thx I left your book in Missouri:( Now I'm trying to simulate a database with hanging connections to test the script. Anyone know how best to simulate that? Dave On Mon, Jan 13, 2003 at 07:43:29PM -0800, Jared Still wrote: Gee Dave, I know of a book that has scripts that already do this. ;)

Re: Foreign key indexes on individual columns or multiple columns

The only requirement for indexes to support an FK is that the leading columns of the index match the columns of the FK. I believe that they must also be in the same order, but I'll let you look that up in the fine manual. So, if you find that you need an index made up of the columns

Problem with Oracle 8.0.6 and Cisco Intrusion Detection System (I

Hi! I'm encountering this error when the Cisco Intrusion Detection System (IDS)tries to connect to Oracle database (8.0.6): * ** Fatal OSN connect error 12545, connecting to:

update on slow connections

List, OS Novell 4.2 Oracle 7.3.4.5.1 disks. OS and Oracle RAID 1 Data and Index RAID 5 Hardware Dell 6300 with Perc Controller Card. The users were experiencing a doggy_slow_connect_time (technical term) connecting to the database. Of course it was the database that was the problem.

RE: strange SQL with TOAD

Hey Ron! My guess is that the Dev has Show ROWID in data grids checked in the TOAD options, probably in Data Grids - Data if your version of TOAD is recent. Take care of them fine VMS boxes... :) HTH! GL! Rich Rich Jesse System/Database Administrator [EMAIL

re-directing database connection requests

Hi Is there a way to re-direct incoming database connection requests to another server? I believe Oracle Connection Manager can do this but it requires the database to be running in MTS mode. Is there another way? Thanks, Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

RE: Parallel Replication of Single Table

Hi Larry, I do not know really how you want to parallelize this kind of operations! The final goal is to push the changes in site 1 to site 2 and get the data in both tables in sync. Changes include inserts, updates, and deletes. These changes (dml operations) could be cascaded on the same row

TSOUG

TriState Oracle Users Group is looking for speakers for the 2003 calendar year. January meeting is 1/28 with the remaining meetings scheduled for the third Tuesday of every month. Even months are scheduled to be geared more towards Developers, Odd months towards DBAs. If anyone is

RE: re-directing database connection requests

Really? I don't remember such a requirement. I think it works with or without MTS. -Original Message- Sent: Tuesday, January 14, 2003 2:34 PM To: Multiple recipients of list ORACLE-L Hi Is there a way to re-direct incoming database connection requests to another server? I believe

Re: perl timeout

Try killing the processes for an Oracle test database. The goal is to fool the listener into thinking the database is still up, and creating a server, which should then hang. It's worked for me in the past, but not always 100%. May take a few tries. Jared David Turner [EMAIL PROTECTED]

Re: USER_TABLESPACES has more rows than DBA_TABLESPACES

Keith Moore wrote: I'm still confused. They are not in DBA_TABLESPACES, only USER_TABLESPACES. Keith Because DBA_TABLESPACES filters them out. Try select name, online$ from sys.ts$ and you'll see them with online$ = 3 (out of memory). - Original Message - From: Stephane

Re: re-directing database connection requests

Ben wrote: Hi Is there a way to re-direct incoming database connection requests to another server? I believe Oracle Connection Manager can do this but it requires the database to be running in MTS mode. Is there another way? Thanks, Ben hacker modenetcat ?/hacker mode -- Regards,

Re: Info about running procs

[EMAIL PROTECTED] wrote: Hi list, I'm looking for a Oracle system view or table where I can see all actual running procedures. Where can I find this info. TIA Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de I think that a join between v$session (where status =

RE: Problem with Oracle 8.0.6 and Cisco Intrusion Detection Syste

What's the user account you have your IDS install under? I would check your Oracle environment variables first for that account. -Original Message- Sent: Tuesday, January 14, 2003 2:19 PM To: Multiple recipients of list ORACLE-L (I Hi! I'm encountering this error when the Cisco

RE: USER_TABLESPACES has more rows than DBA_TABLESPACES

Some of the system views have a lot going on under the covers, and sometimes don't act the way you would expect. Compare ALL_TABLES and DBA_TABLES sometime. They work pretty much the same from the command line for a user that has DBA privs. In a stored procedure however, ALL_TABLES suddenly

RE: DATA MAPPING ISSUE

Title: RE: DATA MAPPING ISSUE Guys, Can anyone recommend a reasonably priced good data mapping tool that helps map legacy data to RDBMS's - Oracle and SQL Server and normalized to denormalized or normalized to different normalized schemas? Thanks, Paula -Original Message- From:

XML functonality in Oracle XML Developer Kit

Good afternoon all Im interested in using xml to hide sql querries on web applications (and storing xml querries) in the db A cursorary search http://www.dbspecialists.com/presentations/xml_and_oracle.html Shows me that in fact XML can work well however Im interested in feedback from

RE: slowish query causing problems...

Denham, Some others have already made good suggestions - including Thomas' reply which I would like to extend upon... Thomas suggested: SELECT DISTINCT (1) FROM fwepcode1 WHERE (wotype = 'TST' AND func = 'C0NEPRF' AND EXP = '2') OR not exists(select 1 FROM

How to categorize Oracle module complexity

Hi Folks ! We are attempting to categorize the technical complexity of ourOracle modules (Forms, Reports, Pro*C etc.) so that any future effort for migration/across the board changes can be estimated can be a little more accurate than a guestimate. Have you come across any methods of

Run obsolete Oracle 7 scripts against Oracle 8i database?

Hi Guys, In OEM reports, under the ELEMENTS tab, you can specify Table from SELECT statement for database versions. ie. the minimum version of the database for which a script will run. So you can have scripts that used to work in Oracle 7 and still have it run in Oracle 8i. ie. Even though the

OEM 9.2: breaks in reports

Hello again, Does anyone know how to add breaks in a SQL output for OEM reports? ie. the SQL for table from SELECT statement What I need is something similar to this in SQL*Plus: break on owner on table_name Or even just a blank line between each break. Is this possible? How do I go about

Subject:RE: Export/Import Error and Validation !!!

Tracy, I hit the same bug when doing reorg using export/import (Solaris 2.6, Oracle 8.1.7.4) for some tables in our baan erp database. The tables had unique constraints that were failing after the import. Found out that import has changed the values in some unique index columns. The export was

Win2k/8.1.7/SQL Question

My European customers are trying to optimize some SQL that is used in their Siebel implementation. It uses a syntax that I am unfamiliar with. The SQL looks like: SELECT ... FROM SIEBEL.S_PARTY T1 INNER JOIN SIEBEL.S_ORG_EXT T2 ON T1.ROW_ID = T2.PAR_ROW_ID INNER JOIN

Re: perl timeout

Cool, thx, Dave On Tue, Jan 14, 2003 at 12:16:27PM -0800, [EMAIL PROTECTED] wrote: Try killing the processes for an Oracle test database. The goal is to fool the listener into thinking the database is still up, and creating a server, which should then hang. It's worked for me in the past,

Re: Oracle 9i release 3 coming?

9i release 2 is the terminal release. There will not be any release 3 from Oracle. The next major release will be 10i. Got this info from Tom Kyte of Oracle Corp. Shaibal Talukder Sr.Oracle DBA Database Engineering Discover Financial Services From: Jared Still [EMAIL PROTECTED]

Re: Run obsolete Oracle 7 scripts against Oracle 8i database?

As long as you aren't using any x$ views or sys.$ tables, they should work as is, with a minimum of exceptions. There were some v$ views that changed, v$log_history for instance. There were also some cases of '#' being added to some column names, but I can't recall which views those were.

RE: Parallel Replication of Single Table

I am not sure about replication but in the past (on 8.1.5 and 8.1.6 versions) this has been my experience with CTAS over a dblink or DML over dblink in that it serializes. In order to achieve parallelism, the only workaround we had was (though not pretty :-) ) to use the ROWID hint on the

RE: Parallel Replication of Single Table

Waleed, Thanks for chiming in. Regarding refreshing multiple tables in parallel, well yes, that could be done on a group level. Instead, though, they choose to have the scheduling tool kick off multiple single table refreshes. They start many at the same time, so they do in essence get

HP-UX 11.0 mount parameter mincache

We have HP-UX 11.0 and are having IO problems. Oracle and HP say to set a mount parameter mincache=direct. We currently have it set to mincache=tmpcache. But when we set it to direct the db slows down to the point it's unusable. HP said to increase the db_block_buffers, so we increased then

RE: Info about running procs

Take a look at Steve Adam's http://www.ixora.com.au/scripts/sql/executing_packages.sql This script lists the packages (and other stored code objects) that are currently being executed, and the SIDs of the executing sessions. It is listed as for 8.0 / 8.1 Remember to check out the prerequisites

RE: Win2k/8.1.7/SQL Question

Title: RE: Win2k/8.1.7/SQL Question Well that looks like ANSI compatible SQL that should run under Oracle9i. Take a look and the 9i docs to develop a strategy for the retrofit. This is so weird for me... having to unlearn Oracle syntax in order to write ANSI SQL. Sigh... -Original

RE: Parallel Replication of Single Table

I remember too being able to achieve parallelism (8.1.7) with CTAS or inserts across DB's too but I'm not able to achieve this now. I tried it from the source side and the target side without success. It's always serial. Curious how you are able to test this. Thanks Waleed -Original

Re: Run obsolete Oracle 7 scripts against Oracle 8i database?

some of the dba_ views changed as well. Can't remember them offhand, I know when we were doing the 101 book, we flagged new or different or obsolete columns when we discussed those views. --- [EMAIL PROTECTED] wrote: As long as you aren't using any x$ views or sys.$ tables, they should work

RE: Parallel Replication of Single Table

Waleed, Initiated from the target side. Parallel DML is enabled with an alter session. And you know it's using parallelism by watching the sessions spawned off on each side, the work they are doing, and the PQ stats. Another member of the list I work with (a darn genius I tell you, with a mind

Re: exp from 9.2.1 to 9.0.1

I intend to export my user in database 9.2.1 into my notebook which is running at 9.0.1 anyone successfull import ? Did i need to xcopy the catexp file from 9.2.1 into my notebook and execute it ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Raymond Lee Meng

RE: HP-UX 11.0 mount parameter mincache

Have you tried mincache=direct,convosync=direct options? Here is a link to an article that might be of some help... http://www.interex.org/pubcontent/enterprise/may00/08sysadx.html - Kirti -Original Message- Sent: Tuesday, January 14, 2003 7:29 PM To: Multiple recipients of list

Date data type

Hi Listers, Does the date data type is not consistence on oracleDB ? I have the query below : Create table test (dt date, name varchar230)); SQL Select * from test where dt between '01-DEC-02' and '31-DEC-02' - it returns 22 rows selected SQL Select * from test

RE: Parallel Replication of Single Table

I knew I ran a parallel CTAS some time ago but was not successful doing this today. And here is why (you will like this): From 8.1.7 doc: DML statements and CREATE TABLE ... AS SELECT statements that reference remote objects can run in parallel. However, the remote object must really be on a

RE: Date data type

Your between is the same as: where dt = '01-DEC-02' and dt = '31-DEC-02' and since '31-DEC-02' is '31-DEC-02 00:00:00', you are excluding records after '31-DEC-02 00:00:00'. Hence less records are returned. -Original Message- Sent: Tuesday, January 14, 2003 11:49 PM To: Multiple

HELP

HELP Stefan Jakobsson Programmerare Arel-Data Tele: 08-470 24 00 Fax: 08-470 24 24 Stefan Jakobsson (E-mail).vcf Stefan Jakobsson (E-mail).vcf Description: Binary data

Woops

Sorry, sent that to the wrong address ... :) Stefan Jakobsson Programmerare Arel-Data Tele: 08-470 24 00 Fax: 08-470 24 24 -Ursprungligt meddelande- Från: Stefan Jakobsson [mailto:[EMAIL PROTECTED]] Skickat: den 15 januari 2003 07:44 Till: Multiple recipients of list ORACLE-L Ämne: