Point-In-Time recovery question, Non-RMAN solution

Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 approximately 17:00 I drop a table. Today I decide I want that table back. I want to do an

RE: Point-In-Time recovery question, Non-RMAN solution

How was the timestamp derived prior to logminer as Point-In-Time recovery has been around a long time? Thanks Rick Scott Canaan

Who is using temp tablespace?

Hi All, How can I determine who is using temp tablespace? I have a 1 gb tablespace and it is almost full. I want to know who and what sql is using most of it. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City

Re: Datatype conversions

INSERT INTO new_table(price) SELECT REPLACE(price, ',' ,'.') FROM old_table; Rick Mladen Gogala

Enterprise Manager Console create report utility stops after 3%

Hi DBAs, Oracle 9.2.0.1 Win 2000 In Enterprise Console there is an option to produce a report on either 1 Database Configuration Report or 2. Database Status Report. When I choose either on I always get 3% complete and amount of time thusfar just keeps going. I never get a report and never

How to trace 3rd party app

Hi DBAs, How can I trace a 3rd party app that produces a ora-3113 error? I am looking into dbms_support package but I am not sure what trace event and level it does. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City

RE: How to trace 3rd party app

Dennis, The dot net app is on a remote server. I will search MetaLink. Thanks Rick DENNIS WILLIAMS

RE: Using ' in Update statement

Ahhh!!! there is no elite and the question was trivial. The great and powerful has spoken, perhaps all questions should be filtered your way for classification. I can assure nothing on this forum is worthy of becoming Testy, merely trying to provide a solution for someone who needed help and

Re: Using ' in Update statement

I assume you mean quote update tablea set fielda =' james'ste Camp 'first,'sec' ' update tablea set fielda =' james''ste Camp ''first,''sec'' '; Just use 2 single quotes

Re: Using ' in Update statement

Hamid started his question How can I user comma ' in my update statement? I am merely correcting his mistake and then providing a solution. Wow, what a concept on a Oracle Listserv site design for that very purpose. Just curious, Would you have answered in the same way if it had been asked

Any known problems with installing new MS patch on Oracle server

Hi All, Has anyone heard of any known gotchas with installing the latest MS patch on Oracle server? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Oracle 9iAS form displays gray box

Hi

OT: Oracle 9iOAS install help needed

Hi All, I am trying to install Oracle 9iAS on Win 2000 I installed Infra structure successfully. While trying to install next component OAS with BI/Forms I get a message Existing Oracle9iOAS Single Sign-On. Enter hostname and port number of existing Single Sign-On. Heck I do not know if it

RE: Oracle 9iOAS install help needed

Thanks for the reply. I already verified the correct port but no go. Thanks Rick Boivin, Patrice

Re: C program won't run in 9.0.2.3

Ruth, Just to be clear you are pre-compiling(not compiling) under 9.0.2.3 and compiling with same C compiler then linking with new 9.0.2.3 libraties. OS is the same. Obviously the contents of sqlca.sqlcode memory location is getting stomped on as 1093480496 is garbage. I would not think the

OT: DataType mapping between Oracle and SQL Server

Can someone post a URL or other reference where I can get a 1-1 mapping where applicable of all Oracle datatypes to SQL Server. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: What is _NEXT_OBJECT

According to MetaLink _NEXT_OBJECT is a hidden entry in obj$ which determines the next

RE: Analytical Functions

I think it is only available in EE not SE Rick Hatzistavrou John

RE: ora-600 when analyzing IOT

Igor, When you gather statistics on an IOT with the ANALYZE command, it will analyze the primary key and overflow segment so I would think this is all that is required by CBO. Hopefully others have more insight. Rick

Re: ora-600 when analyzing IOT

According to MetaLink you need to delete statistics and re-analyze I do not know your database version but this is supposely fixed in 8.1.6 execute

Re: Antw: Take an Oracle 8.1 export file back to an Oracle 7.1

You could load the 7.1 exp on the 8.1 server and export then import on 7.1 server Rick |-+ | | Guido Konsolke | | | [EMAIL PROTECTED]| | | nkrupp.com

RE: License Question

Harvinder, You should call you Oracle sales rep. All pricing is negotiable depending on whether it is end-of-quarter, how close mars is in alignment with earth,etc. Also, always try to negotiate education credits,etc. I have found end-of-quarter is best, they all like that trip to

RE: ora-600 when analyzing IOT

I am not sure but based on the definition of an IOT I would think you would have to ANALYZE TABLE since the primary key data is not duplicated in a separate index. Rick

RE: ** is there PL/SQL for case

Starting with Oracle9i, PL/SQL supports the use of case statements

RE: impersonating another user???

Dennis, Thanks for replying but I think you either read/responded to the wrong question or jumped to the wrong conclusion. Perhaps the subject line was the reason. Tom Kyte has an entire section on n-tier authentication as well as Oracle. However I cannot put all the pieces together as no

Re: what is BAARF?

According to http://www.baarf.com/ Battle Against Any Raid F BAARF was invented by James Morle on Wednesday the 4th of June, 2003, in the Grange hotel outside Birmingham while having a beer or two with Mogens Nrgaard. On the following day - Thursday the 5th of June, which happens to be

impersonating another user???

Hi DBAs, Oracle 8.1.7.4 I want to be able to have users log into the database with an OS integrated account and set up only certain users that log in to act on the behalf of another integrated user account. (i.e. A manager is given access to a database where he may delegate his authority to

Top DW requirements needed

Hi DBAs, I am very new to data warehouse and I am looking for bullet list, URLs, etc. that list what are the essential data warehousing requirements that needs identifying. I know you obviously have to understand the business prior to identifying requirements. I assume some of the

RE: Windohs - monthly at job

Looks correct but you should use task scheduler. Rick Farnsworth, Dave

Re: ORA-01858: a non-numeric character was found

Try it without the quotes surrounding your date field. Rick Martin, Alan

Need ocfgutil.exe

Hi, I have installed Oracle Administration Assistant 8.1.7.4 on Win 2000. However the utility ocfgutil.exe was not installed. Apparently this is a common problem according to MetaLink. Does anyone have this utility that can be e-mailed offline? If so please rename the extension. Thanks Rick

How to prevent single point-of_failure with ONAMES

Hi All, Oracle 8.1.7.4 Win 2000 ONAMES with region database I have ONAMES repository on server1 I have 2 additional onames services on server2 and server3(no database/repository). I received a NNO-50 serious errors in configuration data. I do not know how it happened but I had to truncate and

RE: How to prevent single point-of_failure with ONAMES

What had happened was the data in the table onrs_region got corrupted but the region database was still up. Somehow this caused all 3 name services to shutdown on all 3 servers. I do not have a clue how that is possible. There were checkpoint file on all servers but still no one connected.

How to delete name service

Hi All, Oracle 8.1.7.4 Win 2000 Does anyone know how to delete a name server. I created thru net8 assistant however it will the service will not start. I want to remove it. When I highlight it the 'X' is not deleted nor thru menu options. How can I safely remove name service. Thanks Rick --

SQL*LOADER question

Hi All,

Best way to secure underlying tables in a view

Hi All, I have a view made of 4 tables with different owners. I want to grant users select privs on that view but I do not want them to select on underlying tables. What is best approach? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL

AFTER database logon trigger keeps sessions open

Hi All, I have a after database logon trigger on server/instance 1. All it does is insert a record into instance on server2 via a database link. This creates a session on server2. So every user who logs on to server1 a session is created on server2. The session does not go away. Does anyone

RE: What privs are required to alter a trigger owned by SYS?

Yes but do you have an answer to original question Jamadagni,

Re: show errors doesn't show anything ???

You can try select * from dba_errors where name='PRV_ADMIN'; Rick Janet Linsy

What privs are required to alter a trigger owned by SYS?

Hi all, I have trigger owned by sys. It is actually an after login trigger. I want certain users to be able to enable/disable this trigger. What privs are required? I have tried alter any trigger and I still get insufficient privs when trying to enable trigger. Thanks Rick -- Please see the

Info on context option

Hi DBAs, Oracle 8.1.6 SE, WinNT We are considering using Oracle Context. Is this a separately sold product and is it available in enterprise edition. I cannot find this info anywhere. Any help is appreciated. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

Name Server questions

Hi DBAs, Oracle 8.1.6 WinNT I am trying to understand how Oracle Names is configured. We have a Oracle Names database on server 1. We also have 2 other oraclenames services on server 2 and 3. I understand how server 1 was created and works. What I do not understand is the services on server 2

Is there a way to have ops$account privs to shutdown/startup database

Hi All, Oracle 8.1.7.4 WinNT Is there a way to have ops$account privs to shutdown/startup database? Oracle does not allow granting sysoper to external accounts. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network

Re: Service startup on Windows 2000 fails

Lisa, Pick your favorite sid on that server ex. lisa delete the password file associated with sid lisa. It will be in your oracle_home\database directory. At the command prompt delete that instance. This will not delete the database oradim -delete -sid lisa Recreate service using oradim -new

How does the Oracle Home selector get installed

Hi All, I have installed Oracle 8.1.6 and 8.1.7 on WinNT in different Homes. When I had multiple Oracle homes in the past there was always an Oracle home selector installed. It was not this time. How does this get installed? I want to install this portion. Thanks Rick -- Please see the

Re: When were Locally Managed Tablespaces introduced?

8i Grant Allen grant@towerso To: Multiple recipients

RE: No redo or archived log files

Yes it is my understanding he does not have any online redo or archive logs current or backups. He just has current datafiles where the database will not start because of no online redo so I can assume those have been lost,corrupt,etc. Thanks Rick

No redo or archived log files

Hi All, One of my friends has a database crash. He has no backup of online redo and archived log files. His question is How do you recover the database if all the online redologfiles and all archived files are lost ? Don't ask me why he did not have any backups or mirror online redo. Thanks

database file sizes....more of smaller size or less of larger size?

Hi DBAs, Oracle 8.1.7 WinNT I would like pros/cons on datafile sizes. It is better to have more of less size or less with larger sizes and why? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services--

What is minimum privs to have user do hot backups

Hi All, If I create a backup user, what is the minimum requirements to connect as that user and do hot backups? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Determine how many used and free blocks in an extent.

Does any have a script that shows actual # of used and free blocks in an extent? I would like to determine the maximum # of contiguous free blocks within an extent Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network

RE: 100% CPU utilization, urgent

Lisa, To get info at the thread level and determine what thread within a process is consuming the most CPU you have to use something like performance monitor or Process Viewer. Using Performance monitor you want to choose THREAD from the performance object drop-down and choose ID Thread from

Installer does not run on Win 2k Service Pack 3

Hi DBAs, Has anyone had trouble installing Oracle 8.x on Win 2k Service Pack 3?. When I tried installing 8.1.6 and 8.1.7 the installer does not start. Oracle 9.x installs fine. I do not know if it related to SP3 or not as I was able to install on similar server with SP 2. Thanks Rick -- Please

Re: Installer does not run on Win 2k Service Pack 3

Ooops I forgot it is that P4 bug!!! Rick_Cale@team health.com

Where to get info on global temp tables

Hi All, I cannot seem to find DD view on global temp tables. I would think Oracle stores it somewhere. Also is there a way to change from delete rows to preserve rows via some alter command. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL

Re: Which session is killing performance?

Once you know the thread id (ex. 2496) you can do the following SELECT s.osuser,s.program,s.terminal /* whatever you want to see */ FROM v$session s, v$process p WHERE p.spid = '2496' AND p.addr = s.paddr; Rick

Re: Determine max # of concurrent users at schema level

This is at the instance level. As suspected the only way is through auditing. Thanks Rick Charlie_Mengler@Hom

Determine max # of concurrent users at schema level

Hi All, V$LICENSE will show max # of concurrent users since instance startup. Is there another view or something to determine max # of concurrent sessions for each schema? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat

Re: Which session is killing performance?

I believe you can if you use performance monitor and chart by thread. Rick Igor Neyman

Re: Determine max # of concurrent users at schema level

Yeah that's what I thought. Thanks Stephane

RE: Different Oracle clients give different results

Oracle says this is intended behavior for desc function just more rigorously enforced in later versions. I am still skeptical as desc works in 8.1.6 svrmgrl. Perhaps enforced in sqlplus but not svrmgr...too many inconsistencies. Thanks Rick

Different Oracle clients give different results

Hi DBAs, Oracle Server 8.1.6 Win 2000 Oracle Names I have the following Oracle clients installed locally. I connect to the server using the same USER. When I describe a package and procedure with package I get different results depending on the client. Any ideas what is going on here 8.0.5

RE: Different Oracle clients give different results

Brian, Yes I have checked all of this. Three other co-workers are having same problem except they just have the one Oracle client 8.1.7. It appears to be client related. Thanks Rick

Re: Rebuilding Indexes...

If you know you have 3 duplicate records in the table then the PK must have already been disabled so you have to rebuild anyway. I do not see where you had to disable in order to use the exception table. It was already disabled therefore it probably not an app problem but a disable constraint

Oracle.exe , CPU running at near 85%

Hi, Oracle 8.1.6 on NT 4.0 Oracle.exe is running at about 85% CPU utilization. What can I check to see why that is the case? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

OT: Forms,Reports performance problem

Oracle 8.1.6 Win Nt Has anyone experience/heard of performace problems after migrating from forms 5 to forms 6.0.8.15 and from reports 2.5 to 3.0? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services--

Re: best case scenarios for export/import

First of all you have to have an estimate on how long the import should take. Oracle rule-of-thumb formula for that is import

Re: import and rollback segments

If you cannot take the small ones offline, I do not think you can force to use a particular RBS. You could possible create multiple large RBS then take smaller ones offline then import. After completion put smaller ones online. You can try commit=y to commit after each buffer instead of each

Re: 8i OCP DBA Exams

Hi, Voucher expiration dates having NOTHING to do with retiring of a track. Every voucher has an expiration date, no different on any coupon you get out of the newspaper. No announcement has been made on retiring 8i DBA track. Oracle typically retires a track 6 months after announcement. Rick

RE: Happy Holidays!!

I have never met RUTH and I apologize in advance if I am wrong but I thought I remember a post long ago indicating Ruth G is male? Again a big oops if incorrect.

RE: Happy Holidays!!

Ah Yes, that is exactly who I was thinking of. Sorry Ruth Gramolini Weaver, Walt

OT: Guidelines/Standards for supporting non-oracle databases

Hi, We are virtually an Oracle shop with 2-3 sql server databases due to 3rd-party software restrictions. We have been asked about supporting other small databases such as Access,etc within our company. My question is if you were asked to support smaller databases what

RE: archiving redo logs

You must use the same version, release, and patch of the

RE: Indicator variables

Tom is correct indicator variables 0 - NOT NULL and data retrieved successfully -1 - data is NULL 0 - NOT NULL but possible truncation of data. In 3gl programs such as C ALWAYS use indicator variables. Rick

Re: STATSPACK

I have not done it but supposely oracle_home\rdbms\admin\sppurge will do it. Rick Seema Singh

sql tuning help

Hi, Oracle 8.1.6 NT 4.0 I have a rather complex query a developer gave to me to try to improve performance. There are 3 tables used. All relevant columns used are indexed. The tables have been analyzed SQLWKS select count(*) from physicians; COUNT(*) -- 340043 1 row selected. SQLWKS

Re: sql tuning help

Thanks for the reply but I only see 1 FTS for the last inline view. Some of the info was truncated from previous post. I am resending output Plan Table | Operation | Name| Rows | Bytes| Cost

RE: sql tuning help

Tom, Actually it returns 1 record. Thanks Rick Mercadante,

Experiences with global temp tables

Hi All, Oracle 8.1.6, NT 4.0, Forms/Reports 6i, Has anyone had any trouble using global temp tables in above environment or elsewhere where it cause Oracle to complete lock up. Only way out was to kill oracle.exe...not a good thing. I have found some postings on MetaLink that may be related

ORA-2083 DATABASE name has illegal character '-'

Hi, Oracle 8.1.6.0.0 NT 4.0 I have the following logon trigger. It works fine as long I insert into local table. If I try to insert into a table across a database link the record get inserted but upon exiting the app whether it is sqlplus,forms,etc I get ora-2083. I think it is probably a bug

Re: which bind variable value causes ora-1722

It looks like that is bind value 4(gl_id) = 0. How did you determine it is 6.55802? I certainly do not how to read this trace but looks like it is define correctly :element_id, bind 0 :fixed_operand,bind 1 :flags,bind 2 :free_quantity,bind 3 :gl_id,

RE: ORA-2083 DATABASE name has illegal character '-'

Yes I have taken the insert statement out of the logon trigger and it works fine. I think there may be a possible bug with logon trigger using database links.

Re:

I would recommend a restore because you are going to backup for applying a patch anyway RIGHT? Logminer would do nothing as far as the OS files getting overwritten by applying the patch. Rick

ora-2083,ora-1256 Urgent

Hi All, I have a down production system on Win NT4,Oracle 8.1.6. I just started getting ora-2083 database name has illegal character '-'. When I try to connect via svrmgrl after setting oracle_sid I get tns-12560 tns protocol adapter error. The other 2 instances work fine. Nothing on MetaLink

tns-12500 unable to start dedicated server process.

I have 3 instances on Oracle 8.1.6,Nt 4. They are all started but on one instance I connect via the listener. The only connection is at the server not using service name. I have the usual plenty of memory,swap,etc. It has been working fine until today. I even stopped the other 2 instances

Re: How to make ORACLE Developer 6i understand ORACLE 8i client?

The developer 6i should have the net8 to install so you can connect to 8.0.5 Rick dist cash

opinions on SAN devices for Oracle

Hi All, We are considering the following 3 SAN storage devices. If anyone can share any info on any I would appreciate it. They all have 2gig fibre channel. Hitachi 9200 EMC CX400 HP EVA 2c2d Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET:

Re: Partitioning

Is there a single column/value that you could do LIST partitioning on instead of range or hash? Rick Rishi.Jain@VerizonWi

RE: New development in Cobol or PL/SQL - please help

Babette, If they are a Cobol shop then there is nothing wrong with using Pro*Cobol. I disagree with your statement about using PL/SQL for the business logic. I personally think you should put as much of that in the database. Rick

Re: set arraysize in Pro*C

I have not done it for a while but look in the precompiler options. There is an option to increase. Rick Govind.Arumugam@

RE: When will Oracle 10i be out?

Actually what I have heard is that nothing has been published externally. Oracle recommends to contact sales rep on info concerning future releases Rick Wong, Bing

Differences between Oracle 9.2.0 EE and SE

I have given up on trying to find document detailing differences between Oracle 9i (9.2.0) EE and SE. Can someone provide a link,etc for this? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services--

RE: OCP Exams - What to study out of?

The Cloverleaf product I know is from Quovadx. One of its usages it provides an interface between Healthcare systems and Oracle(many other DBMS). For ex. we use to interface with hospitals sending data in standard HL7 format and Cloverleaf interprets HL7 format and data is loaded directly into

Data modeling question

I was reading one of the papers on the quest website about data modeling. An example was presented and I did not believe the results so I tried it out. Of course the writer ( Phd) was correct. Does anyone know why does not enforce RI constraint if any of the foreign key colums are NULL. I took

Re: Data modeling question

Jared, Yeah, It may be just a design issue but not quite sure. I was referencing from a document Data Modeling: It's Really All About the Relationships by Dr. Bert Scalzo of Quest Software. Data modeling is part of the conceptual design phase. When speaking of the E-R methodology, the data

Re: [Q] what kind of documents shoud contractor provide to me before

I suspect the contractor will only provide the documents all parties agreed to be delivered at completion. Deliverables are part of the contract and require a considerable amount of effort. If your company did not account for this my guess is to document it in your lessons learned.

Re: Adhoc queries and limiting the amount of records queried...

You could implement FGAC or create views that only contains necessary records. Rick Grabowy,

Re: BUG 2632931 on 9.2.0.2

native_threads process associated with 9.2.0 OEM

RE: Suggestions solicited - Change Column Datatype from Number to

The user stated they were using 8.1.7.1 :) Rachel Carmichael To:

RE: Suggestions solicited - Change Column Datatype from Number to

Ooops!!! I missed where the thread changed from 8i to 9ig Rachel

  1   2   3   >