RE: Comparing data between two tables in two schema

Rao, I have a simple WinNT command line tool that I wrote and I have the source code for it. It generates a txt based file of one schema or of a subset of it. Then you can let it compare to an other schema or part of it. The structure of data must be the same, though the tables and columns in

RE: RE: Meaning of V$WAITSTAT statistics

Nice one Cyril, Just what we need now, another religious argument. After the events of the other week I think you should lighten up, it was tongue in cheek I am sure. -Original Message- Sent: 02 October 2001 18:25 To: Multiple recipients of list ORACLE-L Hello Can you please

Dynamic Sql

Hi Lisits I would appreciate any feed back on this topic. dbms_sql.open_cursor dbms_sql.parse dbms_sql.define_column dbms_sql.execute_and_fetch dbms_sql.column_value dbms_sql.close_cursor Regrds NItheesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE: Log Buffers

Yes I did every time I set the initialization parameter. Regards Naveed -Original Message- Sent: Tuesday, October 02, 2001 8:36 PM To: Multiple recipients of list ORACLE-L Did you bounce (shutdown startup) your instance? If you set an initialisation parameter, you will need to cycle

RE: init.ora file and UTL_FILE package

Remember this has security implications however as anyone can read/write files from otherwise private directories. Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141

RE: Oravle vs. Informix

Is there even such a thing as Informix any more? http://www-4.ibm.com/software/data/informix/pr.html According to this press release, IBM intend to merge Informix into DB2. g -Original Message- Sent: Tuesday, October 02, 2001 8:56 PM To: Multiple recipients of list ORACLE-L Hi,

ORA-600 with no parameters

Hi, I have one query thats bugging my life...:-) In one my applications, I run a simple sqlplus command( infact just set commands and select 'CONNECTED' from dual; But, I'm getting ORA-00600: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s] (8

RE: Database Hangs -- System shows latch contentions

All I suggest to reduce the shared pool to a 25% or less and set the shared reversed area to a 20% of the pool considering the amount of packages and code of Applications. Then I implement the policy of pining packages. And certainly the most important to pin will be the STANDARD. Also I would

RE: Dynamic Sql

Hi, What exactly would you like to know about dynamic sql? Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original

RE: Oracle - SQL Server

Also, I believe there is JDBC for MSSQL now - previous there was some sort of JDBC-ODBC bridging thing, or something like that. So you could probably use Java stored procedures in Oracle, maybe with a PL/SQL wrapper, and get at your MSSQL data like that via stored procedure calls. Hmm. g

MAIL on insertion/updation of a record.

hi, I have a requirement as per which i have to send a mail on insertion/updation of a record. How this can be done using PL/SQL (i.e. triggers). Does mail server i.e. Lotus or Exchange server matters in this case. regards sunil s. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Monitoring CPU per session

Hello I'm trying to figure out which sessions use most CPU time. Oracle manual gave me this sql query: SELECT v.SID, SUBSTR(s.NAME,1,30) Statistic, v.VALUE FROM V$STATNAME s, V$SESSTAT v WHERE s.NAME = 'CPU used by this session' AND v.STATISTIC# = s.STATISTIC# .. but the value of 'CPU used by

RE: Monitoring CPU per session

Try setting timed_statistics to on (init.ora) Iain Nicoll -Original Message- Sent: 03 October 2001 11:41 To: Multiple recipients of list ORACLE-L Hello I'm trying to figure out which sessions use most CPU time. Oracle manual gave me this sql query: SELECT v.SID, SUBSTR(s.NAME,1,30)

RE: Monitoring CPU per session

Jonas, To monitor things such as CPU consumption per session you will need to make sure that TIMED_STATISTICS = TRUE in your instance. SQL show parameter timed_statistics; If it is false (which it WILL be in your case) then: SQL alter system set timed_statistics = true; HTH Mark

disable table lock ...cannot revert it

List, a while ago someone on this list suggested a DDL which was new to me so i tried it .. SQL alter table t disable table lock; the problem is ...i'm not able to alter it back to enable table lock !!! as it requires a lock to do it and cannot lock it because i disabled it already

RE: Background jobs inUnix

Is there a way to make pipes work with dbv? I get error 100, file not accessible when I do $ mknod /tmp/pipe p $ dbv file=/tmp/pipe blocksize=8192 When I'm doing $ bzcat system01.dbf.bz2 /tmp/pipe It's no big deal because I can just dbv before bzip2, just curious. Cheers, g -Original

RE: RE: Comparing data between two tables in two schema

Now now, GUI tools aren't all THAT bad! :P Mark (GUI tool sales critter) Leith === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED]

Please Help

Hi lists ... I got this error when I'm running procedure. - ORA-01555: snapshot too old (rollback segment too small) Rollback segments statistics: CLASS COUNT-- -system undo header 0system undo block 0undo header 3undo block 0 (db block gets + consistent

Repost: Problems installing Solaris for Intel patch required for

Help: I've tried the Sun web site but to no avail and I can't go no further, I am using patchadd to install 2 patches (107545-03 and 106542-17) to Solaris for Intel, these patches are required for Oracle 8.1.6. I keep getting the following message: Checking installed patches... One or more

RE: Meaning of V$WAITSTAT statistics

Can't remember where this came from but the following events can be safely ignored. Sorry it's just a starter but my understanding of this isn't what it should be. Iain Nicoll client message SQL*Net message from client SQL*Net more data from client rdbms ipc message pipe get Null event pmon

Re: Monitoring CPU per session

Do you have the timed_statistics parameter on ?. Answering your question: most of all, it helps to measure parsing and recursive calls. Regards. --- Jonas A Wetterberg [EMAIL PROTECTED] wrote: Hello I'm trying to figure out which sessions use most CPU time. Oracle manual gave me this

RE: Insert from text file

You couldn't use UTL_FILE, unless there is a mechanism for the Unix machine to see the filesystem of the NT machine - and if there was, it would be easier to run SQL*Loader on Unix. What do you have on your client machine? I assume that the Oracle client is installed. Therefore, you can write a

Query

PLease can some one give me some advice on tuning this query.. delete from olsr10.op_orders where xmas_id in (193,207,245,300) and order_total = 0 and status_timestamp to_date ('01-aug-2001','dd-mon-') / The explain plan for this is is quite costly as it does a full table scan: DELETE

RE: MAIL on insertion/updation of a record.

Title: RE: MAIL on insertion/updation of a record. I'm redirecting you to http://asktom.oracle.com/pls/ask/f?p=4950:8:162284::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:319216860351,%7Bsend%7D%20and%20%7Bmail%7D This link explains how to send email through developer2000 forms. Hope that using

RE: Query

Following on from this, instead of using the query below, I created a temporary table op_orders_arc which contained all the data I wanted deleted from the main table (op_orders). I then run the following, but the explain plan shows it doesn't use the index I have in the hint and it still does a

RE: Query

I would try the following DELETE /*+INDEX(a MORD_PK) */ FROM ... Ivo -Original Message- Sent: Wednesday, October 03, 2001 02:35 PM To: Multiple recipients of list ORACLE-L Following on from this, instead of using the query below, I created a temporary table op_orders_arc which

RE: Extents size.

The best documentation (and I use the term very loosely) is: 1) SQL.BSQ ($ORACLE_HOME/rdbms/admin) 2) select view_name, text from dba_views where view_name like 'DBA%' 3) select * from v$fixed_view_definition hth connor --- [EMAIL PROTECTED] wrote: This thread has been very interesting

comma_to_table cannot convert a list of numbers ??

List, i'v been trying out a simple use of dbms_utility.comma_to_table procedure the procedure takes a comma delimited string of values and returns the individual values in an array the procedure works fine when i pass a stirng like 'A,B' but error is returned when i pass '1,2' the OUT

RE: Oracle - SQL Server

What did you use for the generic connectivity? Merant? Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73

RE: MAIL on insertion/updation of a record.

I've actually got a piece of code that will allow you to use the unix mail facility, I think it was Rachel that passed this on to me and I kindof tweaked it a bit. If you want me to post it I can do. K. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation

RE: Background jobs inUnix

can you actually do dbv on a zipped file??? --- Guy Hammond [EMAIL PROTECTED] wrote: Is there a way to make pipes work with dbv? I get error 100, file not accessible when I do $ mknod /tmp/pipe p $ dbv file=/tmp/pipe blocksize=8192 When I'm doing $ bzcat system01.dbf.bz2 /tmp/pipe

RE: Query

Thankyou so much this actually worked...but why?? -Original Message- Sent: 03 October 2001 13:50 To: Multiple recipients of list ORACLE-L I would try the following DELETE /*+INDEX(a MORD_PK) */ FROM ... Ivo -Original Message- Sent: Wednesday, October 03, 2001 02:35 PM

RE: Oracle - SQL Server

Hmm, very interesting, that may be a good option. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton

RE: Dynamic Sql

I like all of them and since 8i, dislike them Seriously what kind of feedback you want? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't

RE: comma_to_table cannot convert a list of numbers ??

Probably your nls_numeric_characters are ., (look at the nls_session_parameters view) (comma will be for thousands parameter). You should be able to change it with an alter session but I can't see how yet. Iain Nicoll -Original Message- Sent: 03 October 2001 13:56 To: Multiple

RE: Please Help

This is covered very well and in detail in the manuals, but in short it means you had a transaction write to a rollback segment, then a long running query requested this information for read consistency before the transaction (cause it was already started before the transactions started)

RE: Query

Hi, If u are having a index on xmas_id then change the query as follows delete from olsr10.op_orders where (xmas_id = 193 or xmas_id = 207 or xmas_id = 245 or xmas_id = 300) and order_total = 0 and status_timestamp to_date ('01-aug-2001','dd-mon-') When u use in in where condition

RE: Dynamic Sql

Hi Rajendra Jamadagni, Can U explain about dbms_sql.open_cursor dbms_sql.parse dbms_sql.define_column dbms_sql.execute_and_fetch dbms_sql.column_value dbms_sql.close_cursor I tried in Oracle PLSQL Documents, but couldn't trace about these. Hope U can help me.

SqlPlus connection timeout

Is there a timeout parameter for connecting to Sqlplus? If yes, where can this be edited and configured? Please let me know. Thanks, Rohini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Krishnapura, Rohini INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Query

If you use alias for table (like select a.id from auto a; ) then you have to reference the table in a hint by this alias too (like select /*+index(a a_ind)*/ a.id from auto a; where a_ind is a name of valid index on the table) . Ivo -Original Message- Sent: Wednesday, October 03, 2001

RE: comma_to_table cannot convert a list of numbers ??

ALTER SESSION SET nls_numeric_characters = './' where / is the group separator. You could change this to something that you would never come across. -Original Message- Sent: 03 October 2001 13:56 To: Multiple recipients of list ORACLE-L List, i'v been trying out a simple use of

RE: MAIL on insertion/updation of a record.

It will be great... -Original Message- Sent: Wednesday, October 03, 2001 7:10 PM To: Multiple recipients of list ORACLE-L I've actually got a piece of code that will allow you to use the unix mail facility, I think it was Rachel that passed this on to me and I kindof tweaked it a bit.

RE: Background jobs inUnix

I wouldn't have thought so... bzcat will read a file compressed with bzip2 (which I have found gives superior compression and performance to gzip -9), uncompress it and write the uncompressed file out as a stream, rather than uncompressing the file all the way, reading it, then deleting the

RE: Extents size.

I have put together a summary of this thread as a tip on my website: http://www.vampired.net/forums/viewtopic.php?topic=47forum=150 For those who are interested in this. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and

RE: RE: Meaning of V$WAITSTAT statistics

I didn't mean to offend anyone and I apologize if i did so. By the way, it's spelled Mladen and not Maladen. -Original Message- Sent: Tuesday, October 02, 2001 4:25 PM To: Multiple recipients of list ORACLE-L Was that a joke, Maladen? -Original Message- Sent: Tuesday, October

RE: Extents size.

LMT's have their own problems as well though. Using LMT's, the bitmap on the tablespace is only used to manage free space, used space is in the segment header of the segment which represents the extents. Therefore, to do a query of DBA_EXTENTS you can hit all segment headers (of all tables and

RE: disable table lock ...cannot revert it

Rahul, Right, you can't drop or modify table after alter table t disable table lock; but alter table t enable table lock; still should work. Otherwise it could be a bug specific to you system. HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, October 03, 2001 7:05

RE: Query

Fawzia, In an index hint, you need to use the alias for the table, not the table name. Cherie Machler Oracle DBA Gelco Information Network Malik,

RE: MAIL on insertion/updation of a record.

yes, but it doesn't use utl_smtp to generate the mail. I do know a couple of people on the list have used it, I'll let them talk about the trials and tribulations of setting that up Rachel --- Thomas, Kevin [EMAIL PROTECTED] wrote: I've actually got a piece of code that will allow you to use

RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000

Title: RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000 I did 8.1.7.1 then did 8.1.7.5 Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone:

Re: init.ora file and UTL_FILE package

i prefer utl_file=/tmp/oracle/$sid. you don't want to give rights everywhere. also, developers can access their stuff in /tmp/... dir. [EMAIL PROTECTED] 10/03/01 12:50AM utl_file=* On the development server.. Steve - Original Message - To: Multiple recipients of list ORACLE-L

Disk layout

Could anyone please point me towards documentation which discusses optimum disk layouts for Oracle databases. Thanks in advcance. Steven. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Veritas Quickio and DB_BLOCK_SIZE

I disagree in the 2k for OLTP as well, for similar reasons Jonathan mentioned, as well as a few of the obvious. Most OLTP are not PERFECTLY tuned to only do indexes scans either. And indexes are much more efficient on the larger block sizes as well Do not criticize someone until you walked a

Re:RE: Oravle vs. Informix

I believe that IBM will slowly merge the two so that sooner or later Informix ceases to exist and DB2 becomes the sole product. I'm sure there will be a very sweet migration path from a to b. Then the world of four will be three: DB2, Oracle, and Sql*Server. Dick Goulet

Re: SqlPlus connection timeout

Rohini: I would take a look at the Oracle profiles. There is a setting for idle time and total connect time that you can set which will disconnect the session. Krishnapura, Rohini wrote: Is there a timeout parameter for connecting to Sqlplus? If yes, where can this be edited and configured?

RE: MAIL on insertion/updation of a record.

Here we go folksthis was originally sent to Christopher Spence... Hi Chrisopher, It's based around the fact that I don't have access to the UTL_SMTP package. Some of our DBs are still 7.3.4.2.0 and I'm not sure if we have access to this utility. I don't want to bother the DBAs with

RE: Extents size.

Christopher, Is the guideline 505 extents for the tablespace or each table in the tablespace? Tom Tom Terrian Oracle DBA WPAFB - DAASC [EMAIL PROTECTED] 937-656-3844 -Original Message- Sent: Wednesday, October 03, 2001 10:05 AM To: Multiple recipients of list ORACLE-L LMT's have

Re: please help me to unlock a table

On Tuesday 02 October 2001 21:31, Reardon, Bruce (CALBBAY) wrote: As for the locked table, what do you see in v$locked_object for the table (eg what type of lock). Lock type 'TM', lock mode 6 ( exclusive table lock ) It appears that disallowing table locks does not prevent all methods of

Export - Import from Oracle v8 to v731

Title: Export - Import from Oracle v8 to v731 Hi gurus, i need to transfer db design of a small application from oracle v8(winnt) to v731(vms=vax). I successfully completed the export process: c:\exp80 parfile=c:\exp_par.dat exp_par.dat --- userid=msalah/msalah@qtel

Re:RE: RE: Comparing data between two tables in two schema

GUI's are ok, I do use and appreciate then, but sometimes the older methods are 1) faster and 2) more rewarding. Especially for an old fossil, like me. Dick Goulet Reply Separator Author: Mark Leith [EMAIL PROTECTED] Date: 10/3/01 3:25 AM Now now,

running catlog,catproc

Hi lists Is it mandatory that catlog.sql, catproc.sql should be run while database is in restricted mode. should I run them while db is running in normal mode (users are logged in )? any problems!!! errors !!! regards, srinivas -- Please see the official ORACLE-L FAQ:

Re: Extents size.

Does the 505 extent limit apply to the whole of a partitioned table or to the number of extents per partition? For example if I had a table wth 371 partitions (53 weeks per year * 7 years) to hold invoice data for tax purposes, do the number of extents per partition need to be kept at 1 to avoid

RE: RE: Meaning of V$WAITSTAT statistics

LOL! Ross, you have a drink on me if we ever meet! -Original Message- From: Mohan, Ross [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 11:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: RE: Meaning of V$WAITSTAT statistics I didn't mean to offend

Meaning of V$WAITSTAT statistics

Hi Friends My v$waitstat shows like this..I think there is no time waited..Its okay, Or any thing Iam missing here?? SQL select * from v$waitstat; CLASS COUNT TIME -- -- -- data block 335274 0 sort block

Job queue in 8.1.7.2.1 on Win2k - dead

Hello, While I'm trying to get this resolved with Support, I wonder if anyone else encountered follow problem. Oracle EE 8.1.7.2.1 on Windows 2000 Advanced server. DBMS_JOBs don't run automatically. When executed manually, they are ok, when placed in a queue, they just sit there. SNPs

RE: Disk layout

DBA Handbook if I remember had a nice section on disk layouts starting out with preferred and scaled down. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978)

RE: Oracle - SQL Server

Or , =gulp= , you could use ASP/COM type objects too. and use the infamous ODBC... greg -Original Message- Sent: Wednesday, October 03, 2001 9:15 AM To: Multiple recipients of list ORACLE-L Hmm, very interesting, that may be a good option. Do not criticize someone until you

log file size change

Hi lists, I need to do a refresh of the database (different servers) in the source my logfile size is 25 Meg and I want to change it to 5 Meg in the target and recreate the db using controlfile. I copied all files to target server, what should I change in the trace dump of controlfile.

RE: log file size change

srinivas, I would suggest that you look at this as 2 seperate tasks. 1) Relocating/rehosting the database, then 2) Resizing the redologs. So leave the create controlfile script as is, then alter database to drop the 25M log groups and add your new 5M log groups. Mike Hand Polaroid Corp

RE: Extents size.

It depends on block size, but yes for each segment, which is for each index, table, partition, etc. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978)

Measure parsing calls...

Hello folks I'm trying to improve performance in our database, and the Oracle manual gave me some queries and tips, but I don't realy know to interpet the results. The query SELECT * FROM V$SYSSTAT WHERE NAME IN('parse time cpu', 'parse time elapsed', 'parse count (hard)') gives me the

RE: MAIL on insertion/updation of a record.

If we're talking about the NON-utl_smtp code, it works fine for me now. The only problem I had was making sure my unix mail server could connect with the outside world. We were on a development server that didn't have external mail facilities. ;o) K. -Original Message- Sent: 03

Unix Cron Job

Hi List, I am not a Unix person and want to scheduled a batch job to run on Unix machine every night at 1:00 AM, if you have any script for this or similar really appreciate. Thanks in Advance Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and

RE: Extents size.

See post which is similar, but per segment, each partition in a partition table is a different segment. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978)

Re: Problems with patchsets to 8.1.7.0.0 on Windows 2000

Title: RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000 I successfully patched 8.1.7.0.0 - 8.1.7.2.1 - 8.1.7.2.2 - with the help of a few here (thanks!). The 8.1.7.2.1 patchset readme says that the minimal baseline is 8.1.7.0.0 - and it worked. Out of curiosity, where did you get

RE: running catlog,catproc

Nope -Message d'origine- De : Tatireddy, Shrinivas (MED, Keane) [mailto:[EMAIL PROTECTED]] Envoyé : mercredi 3 octobre 2001 17:40 À : Multiple recipients of list ORACLE-L Objet : running catlog,catproc Hi lists Is it mandatory that catlog.sql, catproc.sql should be run while

intermediate table

Hi to all ! I have one small problem and i am sure many of u can reply .My problem is :i am storingdata from different tableinto intermediate table but the i want touse sql statements to filter data from that intermediate table, I can access it as array of user defined object . but i want

RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000

Title: RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000 Metadink. I believe it is under 8.1.7.1.0 product. It lists 2, 3, 4, 5. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes.

RE: running catlog,catproc

Either is fine. Although if users are logged in it can cause it to be very slow. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707)

RE: Export - Import from Oracle v8 to v731

Title: Export - Import from Oracle v8 to v731 You generally cannot export from a higher level database to a lower. Although you can probably change the compatible option to 7.3.4 and do it that way (from what I hear, never tried it). Do not criticize someone until you walked a mile

query flashback 9i

anyone had any success with query flashback in 9i? i'm testing it and keep getting an ora-1466 error(yes i looked it up and it really doesnt pertain based on the "sample" query from the 9i docs, guess i'm off to writing my own test(stupid example had like 10 errors in it). thanks, joe

Oracle application mailing list

Hi, All: Does anybody out there know a good mailing list about Oracle Applications, especially Oracle Financials? I would appreciate your help. Thanks, Michael This e-mail contains privileged attorney-client

RE: Unix Cron Job

man cron Regards Lee -Original Message- Sent: 03 October 2001 17:21 To: Multiple recipients of list ORACLE-L Hi List, I am not a Unix person and want to scheduled a batch job to run on Unix machine every night at 1:00 AM, if you have any script for this or similar really appreciate.

Re: Meaning of V$WAITSTAT statistics

Hi all Sorry for interrupting this thread ! I'm sorry to say that it is not possible to answer since time_statistics = false and there for the time column is zero. So we know that this db has waited on (data block 335274, segment header 52,undo header 322 and undo block 419) these different

STATSPACK snap_id and time generated...

Hi, Can some one pl help find the relation between the snap_id and the time it was taken. I want ot generate a report for a period of time but having a hard time trying to figure out the starting snap_id and the end snap_id for the period. Thanks in advance. Anjan -- Please see the official

Re:Export - Import from Oracle v8 to v731

Two problems here, one is the password which you can fix by enclosing it in double quotes not the whole connect string, but since it's a 'OPS$' account, can't you run it without the password? As I recall on VMS with an OPS$ account all you needed was 'imp / file='. Anyway, that's the least of

RE: running catlog,catproc

Title: RE: running catlog,catproc You don't want anyone in the database when you are recreating the data dictionary. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Tatireddy, Shrinivas (MED, Keane) [SMTP:[EMAIL PROTECTED]]

RE: RE: Oravle vs. Informix

Likewise don't forget Progress. Ken Janusz, CPIM -Original Message- Sent: Wednesday, October 03, 2001 10:31 AM To: Multiple recipients of list ORACLE-L Subject:RE: RE: Oravle vs. Informix Don't forget Ingres (CA). It still rocks, even though it doesn't have the client

RE: RE: Oravle vs. Informix

Don't forget Ingres (CA). It still rocks, even though it doesn't have the client base the others do. It runs on all the big boxes though... -Original Message- Sent: Wednesday, October 03, 2001 11:05 AM To: Multiple recipients of list ORACLE-L I believe that IBM will slowly merge the

RE: optimizer function based indexes

Joe, There are certainly some situations where it is advantageous to use an index in conjunction with LIKE and criteria containing a leading %. On a tuning gig not too long ago, I had the need, like you, to use a function based index where criteria was similar to yours -- upper(col1) like

Re:running catlog,catproc

I asked that question of OWS some time ago since we appeared to have a problem with the database that pointed in that area. Now they did agree with my diagnoses of the problem and told me that it was possible to run those scripts without the DB being in restricted mode, BUT it could cause some

Partitioning

IIRC, last week or so the question was raised about whether or not partitioning is an extra cost option. My reading of the URL below is that it appears that partitioning is included in 9i Standard. Plus, now I'm not sure exactly what the differences are between Standard Enterprise WRT to 9i.

RE: Unix Cron Job

Title: RE: Unix Cron Job * 1 * * * file_to_run see 'man crontab' for detail. Rivaldi -Original Message- From: Hamid Alavi [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Subject: Unix Cron Job Hi List, I am not a

Re: init.ora file and UTL_FILE package

Yep, as long as they have OS level authority. That's why I said 'development server'.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 2:30 AM Remember this has security implications however as anyone can

problem with sql client 3.3

Title: RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000 Hi, We have a table with column defined as datatype nvarchar(2).. and wgen we describe the table from console(having NET8) it show column as nvarchar2.. but when we describe it from client having sql client version 3.3 it

RE: Unix Cron Job

$crontab -- Press enter 0 1 * * * /blah/blah/blah.sh -- Press {CTRL}+D -Original Message- Sent: 03 October 2001 17:21 To: Multiple recipients of list ORACLE-L Hi List, I am not a Unix person and want to scheduled a batch job to run on Unix machine every night at 1:00 AM, if you have

How to use a ref cursor inside a procedure ???

All, I have s sp, which return a refcursor. If I used in the following way, it looks fine: SQL var k refcursor; SQL exec lp_tagetversion (:k); SQL print k; 4000 -- 4000 But how to use it inside a procedure? The following block compiles fine, I'd like the value in the

RE: Export - Import from Oracle v8 to v731

Don't know if this would work, but here's a thought. Go to the 731 box, set up a connect string to the v8 box. Using the 731 exp, export the v8 database (after you set its compatible option to 7 and bounce it). See if it will import using the 731 imp. I don't have any environment to test this

RE: Veritas Quickio and DB_BLOCK_SIZE

Christofer, maybe it is not black and white, though. Bigger block size means more latch contention on cache buffers chains, for example. That's why one may play around with minimize record_per_block or artifically high pctfree. Both mean waste disk space and _memory_. Many of larger block

Backup Strategy

Hi listers, I was wondering how do you decide your backup strategy. I do daily full exports and weekly full backups with database in archivelog mode. Plus weekly Operating System Backup. Is this all I can do to ensure fast recovery of the database or server when it is needed? Any input on

  1   2   >