RE: Oracle Tools for Data WareHousing

Title: Message Hi Santosh, Check out these sites www.knowledgestorm.com http://technet.oracle.com/products/warehouse/contents.html http://devnet.informatica.com This should help for a start. regards, Satya Prakash -Original Message-From: Santosh Varma [mailto:[EMAIL

Can't find orazht.msg file

Dear all, Where can i download orazht.msg? 'Cos when i issue 'oerr ora 1562', it showed "Cannot find/home/oracle/product/8.1.6/rdbms/mesg/orazht.msg file." I'm using Oracle8.1.6 on Redhat7.2 Thanks in advance.

Re: Big SGA.......

Now you mention it, I have seen some other operating system use a reference to 'large' (4MB) pages. I have heard some comments, though, about one of the Solaris versions not being able to use shared page tables (ISM) when the SGA goes over a critical limit - but this could be highly

copycommit probs

Title: copycommit probs Dear All, I am trying to copy a local table to another local . I have created the link which is working when doing a select but when it comes to copying it gives an ORA-12154 eror. How can I resolve this? Kind Regards, Hatzistavrou Yannis Database Administrator

RE: copycommit probs

Title: copycommit probs Case resolved. Hint. Copy does only use the alias in tnsnames.ora and not the loopback db_links Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- From:

RE: Oracle Internet File System

Thank you very much. I hope this doesn't mean that future versions of Oracle Files. neé Oracle Ifs, will only be available by purchasing Oracle Collaboration Suite. There is always the possibility that this is exactly what could happen, if it hasn't already. Notice the way the main Oracle

Re: Apache and mod_plsql

I'm not sure about much regarding Oracle's license terms right now, but I have been told (while working in Oracle) that the Apache server that was built into 8.1.6 was purely there because OEM needed it (Morten - is that correct?) and that you were not allowed to use it instead of iAS.

Re: Can't find orazht.msg file

I think it is looking for the Taiwan Chinese (BIG5) error file, which you don't have. If you change your NLS_LANG environment variable to something that is available in that directory, it will probably work. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 6 Mar 2003, [big5]

RE: Apache and mod_plsql

About a month ago there were news they were going to hire 2000 people in India. HP has run into a bit of trouble over this, see TheRegister re. that company's customer support problems. Pat. -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]Sent: Thursday,

Re[2]: Duplicate online Database

Chuck, I'm inserested in this paper. Can you send it to me ? Thanks. -- Breno A. K. Magnagomailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares Tuesday, March 04, 2003, 11:03:43 AM, you wrote: CH I don't see why not. Prior to RMAN I used a procedure documented in

Re: Character Set / Encrypted text question

Mark, The most frequent type of programming error leading to this is that the programmer expects that a varchar2 column can contain any binary value. This is by definition not true, varchar2 (actually all char types, including clob and long) should ONLY be used to store readable text. If you

RE: PLSQL stored procedure

Jeremy, The price for the TOAD Expert is quit reasonable when you consider the fact that it includes the SQLab Expert module. The stand alone SQLab Expert yearly fee was big $$$ and could only acces 1 server per license. The TOAD expert can access many servers. I changed over to the TOAD Expert

RE: How Reliable is Explain Plan in 9.2

Title: RE: How Reliable is Explain Plan in 9.2 Thanks Wolfgang ... I understand your point ... I was just trying to be a little cynical ... about these *facts* ... the very elements about which Oracle tells us to rely upon. 1. Who in their right mind would add/drop an index on a live

RE: How to improve queries remotely

I have found in my testing that an inline view works just as well as a normal view . If you are unsure, run explain plan and check the OTHER column in the plan_table. It'll show what is being executed remotely. Kevin -Original Message- Sent: Wednesday, March 05, 2003 5:40 PM To: Multiple

Re: Oracle Tools

Maybe and maybe not. iSQLplus is web based and does not work 100% on pocket IE. For example you can't load scripts from it. If the 10i EM depends as heavily on java running on the client as the 9i browser based version of OEM does, that won't work on a PDA either. - Original Message -

RE: Oracle Internet File System

I don't think iFS will be available standalone. We are running iFS 9.0.1 [upgraded from 1.1.9] and were talking to Oracle about upgrading -- about whether we should go to 9.0.2 or 9.0.3. Oracle was recommending that we go for Oracle Files in OCS -- but we'd have to buy the OCS license. At

Re: Fine Grained Access Control (FGCA)

Hi Murali, In our case since the predicats are generated dynamically and a call to the function from outside will give me the predicate being applied. Thanks to Jonathan Lews, I will also make sure now using event 10730. Regards, Madhavan http://www.dpapps.com Thanks for the response. I did

Re: How Reliable is Explain Plan in 9.2

I agree with JL. You've never been guaranteed that the plan you generate after the fact is the same plan that executed at some prior time. If you're trying to optimize a query using explain plan and are concerned that the plan may change between when the SQL executed and when you ran your explain,

Re: How Reliable is Explain Plan in 9.2

MessageIs that something new in 9i? I don't have it in 8.1.7. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 05, 2003 4:19 PM A, that is what he is talking about, I wasn't aware of v$sql_plan. -Original Message- Sent: Wednesday, March

Fudging outlines

I have an application query that I do not have the source code for. It gets a crappy execution plan. I can add a hint or two to it and significantly improve the execution plan. I want to stuff that execution plan into a stored outline so that the unhinted query uses that plan plan each time it

Tricky SQL Question

Title: Tricky SQL Question Hi all, I have a tricky situation ... I have a table columns are owner varchar2(), name varchar2(), ana_tm number ana_tm represents how much time it took to perform statistics collection for owner.name value. the number ranges from 0 to about 12000 right

RE: Oracle Bug Reports...

Interesting bug. I'm spacing on one thing though. Don't see where the ORA-1555 is coming from on their test case. Henry ***EXCERPT FROM BUG REPORT *** *** REM Create the user and the tables in question REM create user medic identified by medic; alter user medic default tablespace users temporary

explain plans history

I found this on the 'net: http://www.databasejournal.com/features/oracle/article.php/2026601 On our servers people do ad hoc querying, but I thought it might be useful to somebody. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des

RMAN archive log Back up taking long time

We are using rman to backup the 8.1.6 database. Sometime it is noticed that rman is taking huge time to back up some archivelog files . Generally it takes 20 seconds to backup one archivelog , but for some archivelog files it is taking more then 2 hrs . Did any of you noticed this problem before.

FalconStor and Oracle performance

I have a potential consulting gig involving a system that includes a FalconStor storage virtualization component. I'm not (yet) familiar with this company or its technology. The database servers are RedHat Linux. RAID is supplied by a StorageTek array, and a FalconStor IPStor storage

RE: Fudging outlines

Title: RE: Fudging outlines Yup ... and oracle has a note that tells you how. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art

RE: How Reliable is Explain Plan in 9.2

Yes, the v$sql_plan is new in 9i -Original Message- Sent: Thursday, March 06, 2003 10:34 AM To: Multiple recipients of list ORACLE-L MessageIs that something new in 9i? I don't have it in 8.1.7. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Wednesday,

Re: Tricky SQL Question

Thinking back to university days, I think this was called the knapsack problem, and at the time there was no algorithm guaranteed to give an optimal solution. If there is no simple non-procedural algorithm - how about a strategy that simply allows each slave to take the longest task that has not

Re: Oracle Internet File System

It's part of the OCS now, I believe. OCS is apparently only available with Named User Plus licenses, which amount to 60 dollars per NUP. About the options you mention: Every option is only available to you if you have bought an EE license of Oracle: RAC, Spatial, Partitioning, Data Mining,

RE: Tricky SQL Question

Title: RE: Tricky SQL Question Thanks Jonathan, I'd like to assign the tables to a group, but need to do that periodically. Also what I do is load all tables that belong to a group in a pl/sql table (bulk updates/bulk collects). That's why I don't want to do read-from-table ... do-action

Re: Fudging outlines

Title: RE: Fudging outlines The only document I found on metalink was doc id 144194.1 which pertains to 9i. I didn't mention it in my OP but I am using 8i. Also the database I want to do this on is SE not EE so it looks like it's a moot point anyway. - Original Message - From:

show errors doesn't show anything ???

Hi, I have 9i on Linux Red Hat 2.4.9. A package is invalid after compiling. I did a show errors but nothing shows. How do I see where the error is ?? SQL alter package prv_admin compile; Warning: Package altered with compilation errors. SQL show errors; No errors. Thank you in advance!

remote / as sysdba

Hello, env: Oracle 9.2.0.2 on Solaris 9. Does anyone know of a way to use the / as sysdba logon remotely? (to a separate Oracle instance on a separate machine) Other remote user logons work OK. I have tried several variations from sqlplus, such as [EMAIL PROTECTED]connect /@DWQ as sysdba

RE: Big SGA.......

Title: Message Now you are talking, at a prestigious English public school (although at least a hundred years ago) there used to be a headmaster with 3 boys. Periodically he would hide them under a tarpaulin and hit them at random - the moral being 'life is unfair so get used to it'. Um,

RE: Fudging outlines

Title: RE: Fudging outlines It is Note 92202.1 - How to specify hidden hints on SQL statements with a prominent disclaimer: Disclaimer: This script is provided for educational purposes only. It is NOT supported by Oracle Support Services. The script has been tested and appears to work as

RE: Tricky SQL Question -- Solved

Title: RE: Tricky SQL Question -- Solved Okay, I cracked it ... if you are interested, read on ... it is not very optimal, but close to what I want. To me 8 streams is standard, so you'd see 8 as hardcoded. Also I found that select sum(obj_last_analyze_time)/8 from statistics_info / was

RE: Oracle Tools - OEM 4.0

And merely requires a 9iAS license (and associated DB license to run ), as I currently understand it. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Murali Vallath Sent: 06 March 2003 00:19 To: Multiple recipients of list ORACLE-L

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

show errors package prv_admin; show errors package body prv_admin; Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, March 06, 2003 1:23 PM Hi, I have 9i on Linux Red Hat 2.4.9. A package is

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

Janet, try compiling the package body and then checking for errors. alter package body prv_admin compile; show errors; bet you a dollar the package body has errors, not the package spec. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent:

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

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

RE: remote / as sysdba

have you got the remote login password file ? if you set it I think it should work . take a look at Note:1016540.6 -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 7:09 PM To: Multiple recipients of list ORACLE-L Hello, env: Oracle 9.2.0.2 on Solaris 9.

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

Title: RE: show errors doesn't show anything ??? try show errors package or show errors package prv_admin from the 9.2.0 SQL PLUS Reference Manual When you specify SHOW ERRORS with no arguments, SQL*Plus shows compilation errors for the most recently created or altered stored procedure.

RE: remote / as sysdba

Title: RE: remote / as sysdba As far as I know, it works like this: You will need to set init parameter REMOTE_LOGIN_PASSWORD_FILE to EXCLUSIVE. You then can sign on as SYS remotely, or as another user remotely if the other user has SYSDBA. See the users that have SYSDBA or SYSOPER in

sql question ???

Hi, I got a SQL question (9i on Red Hat), commands shown below. The first sql returns 3 rows with value 1, so trim(client_company) = '', how come the 2nd sql doesn't return anything?? SQL select decode(trim(client_company), '', 1, ' ', 2, null, 3, 4) from cli_clients where cli_id in (257,

Re: Character Set / Encrypted text question

Mark, I have seen this issue here where an application scrambles/encrypts data into a character field varchar2 but it doesn't work right when moved to another environment. The source environment was using NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 but the target was using

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

Title: RE: show errors doesn't show anything ??? select * from user_errors where name = 'PRV_ADMIN' / - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an

Re: remote / as sysdba

Bill, You can't do that. If you try to, you will eventually see ORA-1997 12:18:58 rsysdevdb.radisys.com - [EMAIL PROTECTED] SQL grant sysdba to ops$jkstill; grant sysdba to ops$jkstill * ERROR at line 1: ORA-01997: GRANT failed: user 'OPS$JKSTILL' is identified externally 12:19:07

Re: Fudging outlines

The disclaimer is very important, as the script is missing a second update to exchange the hint counts between the two outlines. If you don't do this, a subsequent export/import of the outlines loses any outlines where the hint count doesn't match the number of rows in ol$hints. I've got

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

Re: Tricky SQL Question

Jamadagni, Rajendra wrote: Thanks Jonathan, I'd like to assign the tables to a group, but need to do that periodically. Also what I do is load all tables that belong to a group in a pl/sql table (bulk updates/bulk collects). That's why I don't want to do read-from-table ... do-action

RE: Fudging outlines

Title: RE: Fudging outlines Chuck, You are right, they say it is 9i, but the update statement to exchange between different plans should (I am guessing) work on 8i as well. Have you already tried it?

System tablespace Oracle 9202

Title: System tablespace Oracle 9202 List, System tablespace for Oracle 9iR2 is defaulting to Dictionary Extent Management. I thought all tablespaces defaulted to Local in this release. Thu Mar 6 15:29:43 2003 create tablespace SYSTEM datafile '/oradb/DEV/system/system01.dbf' size 201M

Oracle Forms Reports Help!

Hi, This could be a very simple question to many of you.. but I would really appreciate if you could help me. I created Forms which call each other. And a Report from the Form. Everything seems to be good. However I am calling the Form through call_form() where I am specifying the entire path

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

Title: RE: What privs are required to alter a trigger owned by SYS? I'd rather own that trigger by someone other than *sys* ... Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any

RE: remote / as sysdba

*** Comments by BECKER, BILL Thu Mar 06, 2003 -- 03:30:49 PM I have tried this, but it still does not work. [EMAIL PROTECTED]select value from v$parameter 2 where name = 'remote_login_passwordfile'; VALUE

perl DBI question: fetchrow_array

I have some perl code which selects table data and write it into a file. I have something like: --- $dbh-{RowCacheSize} = 1; open(DATA, $tn) || die Can't open file\n; $dat=$dbh-prepare(select id||chr(9)||FUNCTIONID||chr(9)||GENEID from FUNCTION2GENE); $dat-execute(); while(($row)

RE: Oracle Bug Reports...

IIRC, the ORA-1555 was in another session. Jared Henry Poras [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/06/2003 08:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Bug Reports...

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

Title: RE: show errors doesn't show anything ??? -Original Message- From: Janet Linsy [mailto:[EMAIL PROTECTED]] I have 9i on Linux Red Hat 2.4.9. A package is invalid after compiling. I did a show errors but nothing shows. How do I see where the error is ?? SQL alter

Re: Tricky SQL Question

Very cute - But it doesn't really cope well with a few outlying values at the top end of the range. Using double the count to invert the high/low distribution is neat - but only if the distribution is fairly smooth to start with. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming

RE: Tricky SQL Question

Title: RE: Tricky SQL Question Stephane, Nice ... very nice script ... it is very close to what I came up with. Thanks everyone Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD:

RE: Oracle Tools - OEM 4.0

Merely? That's like saying a man standing in front of a tidal wave will merely experience some moisture. At $20K/CPU (I'm assuming that's the number of CPUs the Oracle semi Intelligent Agent runs on), we're looking at another $440K for OEM 4.0??? Ohh, I forgot -- 9iAS comes with OID...

RE: Tricky SQL Question

Raj, I may not be offering information useful in solving your specific stats problem. If that's the case, Undskyld. However, this information is certainly useful. This link to the asktom website contains a method for dividing up large tables into ranges of rowids so that multiple sessions can

Re: Export data to dbf

What type of file is 'dbf'? Sergey V Dolgov [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/05/2003 09:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Export data to dbf Hello, I can't find

Re: System tablespace Oracle 9202

It was only in 9.2 that it was possible to create the system tablespace as locally managed, and rumour says that in 10i system tbs defaults to locally managed. The reason it's not default in 9.2 is most likely because..: 1. Most likely they just didn't update the DBCA default scripts to

Oracle on a SAN.... Good, Bad or Proceed with caution?

Hello, We are currently spec'ing out hardware for our new ERP system. It is either going to be Peoplesoft or Oracle. We are also debating on using a SAN rather than attached storage. I'm just looking for any positives/negatives/rules of thumb I should be aware of when running Oracle on a

RE: Oracle Internet File System -- Oracle Taketh Away?

With apologies to Tom Leherer The project will be a big success The files accessed through OCS There is a very large difference between what's possibly happening with iFS and editions and options. It has always cost more for the Enterprise Edition. The spatial option has always cost more

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

Hi Janet, Try using 'show errors package package_name' or 'show errors package body package_name' ex. - SQL show errors package body DBMS_ASYNCRPC_PUSH Errors for PACKAGE BODY DBMS_ASYNCRPC_PUSH: LINE/COL ERROR - 103/27

Re: perl DBI question: fetchrow_array

try using fetchrow_arrayref and see if its faster or less resource intensive. On Thu, 6 Mar 2003, gmei wrote: I have some perl code which selects table data and write it into a file. I have something like: --- $dbh-{RowCacheSize} = 1; open(DATA, $tn) || die Can't open file\n;

RE: System tablespace Oracle 9202

Title: Message Only if you use DBCA, I believe. Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message-From: [EMAIL PROTECTED]

Re: Tricky SQL Question -- Solved

Very clever ! Can I make a couple of suggestions: You've got a very large number of tables in one group - and the startup time for the analyze might have a big impact on this group - so how about adding in (say) one second to the analyze type in order to cater for startup. Also - how about

RE: remote / as sysdba

Title: RE: remote / as sysdba If you want to do connect sys/[EMAIL PROTECTED] as sysdba then the database corresponding to TNS alias DWQ has to have remote_login_passwordfile EXCLUSIVE, and it needs to have a password file. It is not clear to me from your e-mail if remote database DWQ has

Re: Tricky SQL Question

Jonathan Lewis wrote: Very cute - But it doesn't really cope well with a few outlying values at the top end of the range. Using double the count to invert the high/low distribution is neat - but only if the distribution is fairly smooth to start with. Regards Jonathan Lewis

RE: remote / as sysdba

You could logon that way if Oracle allowed it. sqlplus /@dv03 as sysdba two different linux boxes, same OS account name on both boxes. While the previous will result in an ORA-1997 ( sorry, you can't remotely logon as SYSDBA ), the following works just fine: sqlplus /@dv03 Jared Jacques

Re: perl DBI question: fetchrow_array

1) fetchrow_arrayref is faster than fetchrow_array, as Alex has noted. 2) I see you've already set RowCacheSize. Anecdotal evidence ( not just mine) suggests that the diminished returns obtained by setting this 100 aren't worth it. 3) try selectall_arrayref if you're data is not really

RE: remote / as sysdba

The remote instance must have remote_login_passwordfile=EXCLUSIVE Any local instances, whether or not you are logged into them, are unimportant. In this case: [EMAIL PROTECTED]connect sys/[EMAIL PROTECTED] as sysdba ERROR: ORA-01017: invalid username/password; logon denied I would tend to

RE: System tablespace Oracle 9202

Title: Message In your create database script, make sure you have EXTENT MANAGEMENT LOCAL after the sysdate datafile clause. Here's an example - CREATE DATABASE abcUSER SYS IDENTIFIED BY xyzUSER SYSTEM IDENTIFIED BY xyzDATAFILE '/u10/oradata/abc/system01.dbf' SIZE 350M REUSEEXTENT

RE: System tablespace Oracle 9202

Title: RE: System tablespace Oracle 9202 Metalink Note:175434.1 has some interesting information on the subject. For example, it reminds you that if the SYSTEM tablespace is LOCAL, then you cannot create a tablespace with extent management DICTIONARY. You can tell the database creation

Re: Oracle on a SAN.... Good, Bad or Proceed with caution?

Perhaps you'll enjoy James Morle's Sane SAN paper on www.OakTable.net - if you haven't seen it already. Best regards, Mogens Scott Stefick wrote: Hello, We are currently spec'ing out hardware for our new ERP system. It is either going to be Peoplesoft or Oracle. We are also debating on

RE: remote / as sysdba

Title: RE: remote / as sysdba I forgot that you could do that. I never liked remote os authentication (is it still possible to easily fool a client into thinking you're someone else?), and I would like it even less if it allowed you to sign on as SYSDBA without a password. The best security

RE: System tablespace Oracle 9202

Actually, I think the reason it's not default is because we don't introduce something as a new default (generally!) without giving you a release notice e.g. in reverse, we warned people more than one release beforehand that SVRMGRL would be removed. Pete Controlling developers is like herding

Re: Oracle Internet File System -- Oracle Taketh Away?

An interesting feature of partition views in Oracle 9. If you create a thing that matches the requirement for an old v7 partition view, and set the parameter partition_views_enabled = FALSE You still find that partition elimination can occur, better than it used to in v7, and the execution

RE: remote / as sysdba

At one time you could set the 'ORACLE_USERNAME=SYSTEM' variable in your oracle.ini file, and log into any database as SYSTEM ( without a password ) as long as REMOTE_OS_AUTHEN=true. That was obviously some years ago, and I don't know if that is still possible. I would have hoped that such an

RE: remote / as sysdba

Title: RE: remote / as sysdba Thank you for the information. I thought the security issues were more fundamental. For example if my database has remote os authentication (with prefix OPS$), and I know that there is a user called OPS$JSTILL, then I can change the Windows Registry on my client

Re: System tablespace Oracle 9202

What platform is this? I can't be sure (because my laptop is miles away at the moment) but I think on 9.2 on NT when I used the creation assistant to generate scripts for me, SYSTEM was an lmt. hth connor --- Godlewski, Melissa [EMAIL PROTECTED] wrote: List, System tablespace for Oracle

Re: sql question ???

A ZERO length varchar is treated as NULL so your second query should be select count(*) from cli_clients where trim(client_company) is null and cli_id in (257, 396, 727); At 12:09 PM 3/6/2003 -0800, you wrote: Hi, I got a SQL question (9i on Red Hat), commands shown below. The first sql returns

Re: System tablespace Oracle 9202

mine on Redhat Linux is LMT as well and I am certain I didn't do anything special to create it that way. At 04:43 PM 3/6/2003 -0800, you wrote: What platform is this? I can't be sure (because my laptop is miles away at the moment) but I think on 9.2 on NT when I used the creation assistant to

RE: System tablespace Oracle 9202

DBCA, by default in 92 will create SYSTEM as LMT. There is an option to do dictionary if you prefer. CREATE DATABASE default is a dictionary managed SYSTEM tablespace with LMT optioinal. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 3/6/2003 6:43 PM What platform

Re: RMAN resync of catalog to controlfile

Joe, Thinking outside the box a little... How about if you query the recovery catalog views on RMAN repository database, using a technique of SQL-generating-RMAN? Connecting to the recovery catalog database, you could query the RC_BACKUP_CONTROLFILE view to generate a series of CATALOG

Re: RMAN resync of catalog to controlfile

Tim, I like the concept alot and will put it on my list to try out in the near future. thanks for the ideas, I've not tried any of the commands but will definitely try them. thanks, joe Tim Gorman wrote: Joe, Thinking outside the box a little... How about if you query the recovery catalog

Re[2]: Export data to dbf

Hello Jared, Friday, March 7, 2003, 2:09:33 AM, you wrote: JSrc What type of file is 'dbf'? I think I should use ODBC but I don't know how to do it. JSrc Hello, JSrc I can't find out how to export some data (selected results) from oracle to JSrc dbf file. -- Best regards, Sergey

RE: RMAN resync of catalog to controlfile

A facinating idea Tim no time this weekend, but I plan on playing with the idea if someone else dosen't. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 3/6/2003 9:23 PM Joe, Thinking outside the box a little... How about if you query the recovery catalog

RE: Fudging outlines

Title: RE: Fudging outlines You definitely can do it in 8i as well. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - RMOUG Training Days 2003, Mar 56 Denver - Hotsos Clinic101, Mar 2527 London -Original Message- From: [EMAIL PROTECTED]

RE: RMAN resync of catalog to controlfile

Sounds do-able and cool, don't have the time right now though... Maybe in 2 or 3 weeks though... Let me know what the outcome is... Clint -Original Message- Sent: Friday, March 07, 2003 6:09 AM To: Multiple recipients of list ORACLE-L A facinating idea Tim no time this weekend,