A doubt in 9.0.1.0.0 database..

Hi DBAs, I got a problem in Rollback Segments.. This is the setting for UNDO ( Rollback ) in my init file... undo_management=AUTO undo_retention=900 undo_suppress_errors=FALSE undo_tablespace=UNDOTBS While querying V$waitstat, got the foll. : CLASS COUNT TIME system undo header 0 0 system undo

RE: The use of schemas

Ha hah, brilliant. -Original Message- Sent: 14 February 2002 03:58 To: Multiple recipients of list ORACLE-L On Consultant Topic Interesting one === It's all about an intelligent consultant... Once upon a time there was a shepherd looking after his sheep

Another doubt in 9.0.1.0.0 database..

Hi DBAs, While reducing the JAVA_POOL_SIZE in initfile , i observed that minimum it takes 8M and not less than that. If we dont specify this parameter, default value it takes as 20 M !!. If there is no JAVA related stuff in my application / database..., why should i have this space

RE: View for Procedure/Function SQL Code

Hi, DBA_SOURCE can help you Sinardy Happy CNY 14 Feb -Original Message- Sent: 14 February 2002 15:13 To: Multiple recipients of list ORACLE-L Hi! Is there a view to see the code written in the procedure/function code, the parameters, return types etc. TIA! Aleem -- Please see

Oracle parallel server

Hi all, Have you implemented or worked with oracle parallel server. If yes could you please point or me some resources about application planning and partitioning. thanks in advance, Sathish. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sathish Tatikonda INET:

RE: View for Procedure/Function SQL Code

Hi, DBA_SOURCE can help you Sinardy -Original Message- Sent: 14 February 2002 15:13 To: Multiple recipients of list ORACLE-L Hi! Is there a view to see the code written in the procedure/function code, the parameters, return types etc. TIA! Aleem -- Please see the official

RE: View for Procedure/Function SQL Code

Hi Aleem, You can view this info in DBA_SOURCE view. Best way is to query like this . SET PAGES 100 select text from dba_source where name = 'EUL$GET_FOLDER_NAME' and OWNER = 'TEST ; why Try selecting all columns and see the diff ;-) HTH, Rajesh -Original

Re: DB sizing - whitepaper

Ramesh, I presume you are looking for something to tell you how to configure a database server, and such a thing does not exist. Period. The real answer is, that this is far too application dependent, and that only the application developers can provide anything of this kind. And even in

Re: Oracle parallel server

The Oracle parallel server (or RAC in 9i) manuals a good source of info. hth connor --- Sathish Tatikonda [EMAIL PROTECTED] wrote: Hi all, Have you implemented or worked with oracle parallel server. If yes could you please point or me some resources about application planning and

RE: View for Procedure/Function SQL Code

Hi The text field of the DBA_SOURCE or USER_SOURCE can help u. Ayyappan.S -Original Message- Sent: 14 February 2002 15:13 To: Multiple recipients of list ORACLE-L Hi! Is there a view to see the code written in the procedure/function code, the parameters, return types etc. TIA!

Re: LMT to DMT

sys@cust9 desc dbms_space_admin ... PROCEDURE TABLESPACE_MIGRATE_FROM_LOCAL Argument Name Type In/Out Default? -- --- -- TABLESPACE_NAMEVARCHAR2 IN the obvious

RE: Importing SQL 7.0 tables

One addition to Suhen's mail below - if you are going to be using DTS to push the data directly to Oracle, be sure to create the destination tables first, and not let DTS do this. DTS will create the table names in lower case, so every time you want to select/update.. .. you have to use double

Re: DB sizing - whitepaper

Bjørn What you say is true. Now my question is What should be the answer to the question How you plan the Database sizing for a given application?. I faced it in a DBA interview. I did mention about the requied tablespaces, storage parameters etc depending on Application size. Am I missing

RE: HOW TO MAKE FAST EXPORT

There's a (somewhat dated) tip on my site under the Tuning link about things you can do to make imports faster hth connor --- Mark Leith [EMAIL PROTECTED] wrote: _make_import_faster = true ;) You could drop any indexes that are associated with the tables you are importing to - If you are

Re: User Access Log

Check out the AUDIT command. a) set audit_trail = db in init.ora b SQL audit session and then use the DBA_AUD... views (and truncate SYS.AUD$ from time to time) hth connor --- [EMAIL PROTECTED] wrote: Hi, everyone, I am trying to create usage report for one of our applications. I

Re: Another doubt in 9.0.1.0.0 database..

From the performance guide: Memory for the shared pool and buffer cache is allocated in units of granules. A granule can be 4 MB or 16 MB, depending on the total size of your SGA at the time of instance startup. If the size of your SGA is less than 128 MB, then the granules are 4 MB in size;

Re: patches for 8.1.7

8.1.7.3 is the latest patch. hth connor --- sarath kumar [EMAIL PROTECTED] wrote: Hai, i have to move my 7.3.4 database to 8.1.7. what are the patches i need to apply once i move to 8.1.7. The OS is SUN SPARC 2.6 TIA Srinivas __

How to step over the STDIN, while input redirection is not given at commandline

Hello Gurus, Source code: of printFile.pl # File: printFile.pl ## #! /usr/bin/perl -w my (@data, $user); # Input rediretion file $user = (defined @ARGV) ? shift @ARGV : Anonymous; # I don't wish to prompt by program, but it's still waiting how to Step Over here @data

Call PL/SQL from MsAccess

Hallo, anyone whom can give me an example onhow to write an MsAccess procedure which make a call to a pl/sqlprocedure. I want the MsAccess procedure send 5 parametsrs through to pl/sql. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE: 9i Installation error ora-01503, 00200, 00202

Hi Been there, done that, got errors. Ask support for CD pack V2. It solved my problems, on NT, and demo 9i DB now working. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Abdul Aleem [SMTP:[EMAIL PROTECTED]] Sent: Mon, February 11, 2002 4:03 PM

Re: Another doubt in 9.0.1.0.0 database..

read admin guide. joe Arul kumar wrote: Hi DBAs, While reducing the JAVA_POOL_SIZE in initfile , i observed that minimum it takes *8M* and not less than that. If we dont specify this parameter, default value it takes as *20 M *!!. If there is no JAVA related stuff in my

Re: A doubt in 9.0.1.0.0 database..

its not a doubt and you're not using rollback, your using automatic undo management. read up on it in the admin guide,. joe Arul kumar wrote: Hi DBAs, I got a problem in Rollback Segments.. This is the setting for UNDO ( Rollback ) in my init file... undo_management=AUTO

RE: Import error from 8.1.7.2.0 to 8.0.5

If you can, try to do the export with the 8.0.5 export. This should eliminate the incompatibility between versions. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 13, 2002 10:38 AM To:

Free dbs / Mysql Ver 2

Hi, Is some using Frontbase ? ( http://www.frontbase.com/ ) Best Regards Henrik E. -!-Hello, -!- -!-We are working with Oracle 8.1.7.2 on Sun Solaris. -!-We want to check if a free db can replace some of our Oracle databases. -!- -!-Is someone using a free database in production ? -!-Any

RE: How to do a bulk bind to load data into a table

Title: RE: How to do a bulk bind to load data into a table from my understanding the FORALL statement only helps you when processing data in collections or with BULK when retrieving rows into collections. the bulk bind functionality is btw only available starting with 9i. you might want to

Re:Oracle parallel server

Sathish, Under Oracle's RAC in 9i you don't need to do any of this. Dick Goulet Reply Separator Author: Sathish Tatikonda [EMAIL PROTECTED] Date: 2/14/2002 12:33 AM Hi all, Have you implemented or worked with oracle parallel server. If yes

Re: RedHat Linux 7.2 Oracle 9i Shutdown

[Gene Sais] Thank you. Not sure if it will work, but I was missing an K00... entry in rc2.d. I just linked it, lets see what happens on next bounce. FWIW, the right way to deal with these symlinks under RHL 7.2 is to have an /etc/init.d/whatever wrapper script that includes a comment section

Create Database ... really dumb question

Okay... I am at a loss. There is SOMETHING wrong, and I can not for the life of me see it. I know there is something REALLY simple wrong with this, but I can't find it... ANYWHERE... and the error manual is ever so helpful on the errors... :\ THESE are my errors.. create

Re: How to step over the STDIN, while input redirection is not given at commandline

[SubbaReddy M] = How to check the input direction is given or not in perl, @ = STDIN; = like @ = STDIN if ( defined STDIN ); But this will not full fill the requirement, because, it's prompting for input, if redirection missing at commandline. Please, kindly give me suggestions to

Re: Free dbs / Mysql Ver 2

- Original Message - Is some using Frontbase ? ( http://www.frontbase.com/ ) it's not free ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who

Re: LMT to DMT

Thanks a lot. I know it is very easy. Just can't remember how to do it. Joan Connor McDonald wrote: sys@cust9 desc dbms_space_admin ... PROCEDURE TABLESPACE_MIGRATE_FROM_LOCAL Argument Name Type In/Out Default? -- ---

RE: Import error from 8.1.7.2.0 to 8.0.5

Could you use the COPY command? Rick àãø éçéàì

whitespaces

Hi, What query can i run to to eliminate trailing whitespaces. e.g. i have 'abc ' and want to update the table so any such data is set without the whitespace, in this case 'abc' the fiels is varchar2 8.1.7. cheers -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Re: A doubt in 9.0.1.0.0 database..

Hi Joe, Thanks for the prompt reply in the forum. btw, When we use AUTO value for UNDO Management, it is supposed to be handled by oracle AUTOmatically. I have read the docs. there is not much info reg. this.. My question is : If Oracle is handling it, then why contention for UNDO HEADER in

Re: HOW TO MAKE FAST EXPORT

Hi Jacques, I used transportable tablespace to do this. It is fast, however, it didn't serve the reorg purpose. It rebuild all the objects exactly as same structure as original. Joan Jacques Kilchoer wrote: Use transportable tablespaces? -Original Message- From: Mark Leith

Unidata DB

Has anyone heard of Unidata DB. It's relational and from IBM. Thanks, Ken Janusz, CPIM

RE: Oracle parallel server

hi all, we are using oracle 8i as our database server. So we have to user OPS and not RAC version which comes with 9i. So in light of the above could you please give me any pointers for application planning and data partitioning. I have some documents on OPS which says this is the most important

Re: Create Database ... really dumb question

April, could quite possible be that you are missing the GROUP # clause for the logfiles, You list 3 files but not define a group for each of them. ROR mª¿ªm [EMAIL PROTECTED] 02/14/02 08:23AM Okay... I am at a loss. There is SOMETHING wrong, and I can not for the life of me see it. I know

RE: Create Database ... really dumb question

db_domain = .world same error db_domain = .worldsame error db_domain = world same error... Oracle Version 8.1.7.0 -Original Message- Sent: Thursday, February 14, 2002 7:45 AM To: '[EMAIL PROTECTED]' Cc: April Wells Check Metalink Note : 56016.999 Samir Samir

RE: How to do a bulk bind to load data into a table

You can do it in 8i as well ... CREATE OR REPLACE PACKAGE BODY Admin_Index AS -- -- Define types TYPE itt_OWNER IS TABLE OF NCS_INDEX_STATS.owner%TYPE INDEX BY BINARY_INTEGER; TYPE itt_NAME IS TABLE OF NCS_INDEX_STATS.name%TYPE INDEX BY BINARY_INTEGER;

RE: Create Database ... really dumb question

Check Metalink Note : 56016.999 Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message-

Re: Changing backup locations in RMAN

You set this in the fornat statement in your backup script. E.g, format '/ora/backup1/backupsetstring' Make sure you put the single quotes aroung the destination. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 13, 2002

Re: View for Procedure/Function SQL Code

user_source? all_source? dba_source?David A. BarbourOracle DBA, OCPAISD512-414-1002Abdul Aleem [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]02/13/2002 11:13 PM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: bcc: Subject: View for Procedure/Function SQL

Re: DB sizing - whitepaper

Ramesh, I still don't know exactly what you mean by 'database sizing'. If what you really mean is 'disk capacity', the most important factor today is the number of I/O's available on your most active tablespaces and the redo log files. Frequently, you end up with a situation, that your disk

RE: Create Database ... really dumb question

April, I think you need parens around the logfiles like: logfile ('/admin04/cc1test/redo01.log' size 1m reuse, '/admin05/cc1test/redo02.log' size 1m reuse, '/admin06/cc1test/redo03.log' size 1m reuse) Your syntax is correct for one log file. Tom Mercadante Oracle Certified

Re: Create Database ... really dumb question

Have you set the ORACLE_SID before running the script? Just a thot... Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 8:23 AM Okay... I am at a loss. There is SOMETHING wrong, and I can not for the life of me

Re: Skewed Wait Times

Well, why not ask the man himself? Jonathan - are you there? Mogens [EMAIL PROTECTED] wrote: Nope. That version of v$system_event would also show me the max wait that was done on an event, and not just the total time waited. Its there in his book, somewhere in a chapter that also talks of

UNIX Performance Issues

DBAs, This might be littlebit (or completely!) UNIX related... But I am told to do the performance analysis of some 10-15 machines and generate some statistical data to find out bottlenecks and identify areas of tuning... Operating System : Solaris 2.6 I have been using sar, iostat, top... I

RE: Another doubt in 9.0.1.0.0 database..

Hi, There is a bug when you asign java_pool_size=0, it happened to me. ORA-04031: no se han podido asignar 4032 bytes de memoria compartida ("shared pool","unknown object","joxs heap init","ioc_allocate_pal") Metalink: fact: Oracle Server - Enterprise Edition

SV: Ok... this is driving me nuts!

Good suggestion... About the only problem is that if I try to select on the package.function name, I get an error stating that I'm not allowed to perform DML on a select statement. Ad the problem with declaring a variable such as: declare x number; begin x := raknaupp.fakturanummer; end;

RE: Unidata DB

Um...Are you sure it's notUniversal DB? AFAIK, that's really just DB2... More a marketing thing... Tim -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 14, 2002 8:44 AMTo: Multiple recipients of list ORACLE-LSubject: Unidata DB

RE: Create Database ... really dumb question

create database testcc1 controlfile reuse logfile ('/admin04/cc1test/redo01.log' size 1m reuse, '/admin05/cc1test/redo02.log' size 1m reuse, '/admin06/cc1test/redo03.log' size 1m reuse) datafile '/data10/cc1test_system.dbf' size 100m reuse / SQL @afiedt.buf logfile

Re: Create Database ... really dumb question

The db_domain=world should be in the init.ora. $0.02 more,Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 8:53 AM db_domain = .world same error db_domain = .world same error db_domain = world same error...

RE: Oracle and Apache Web server bottleneck

Hm...a 12x36 disk array. Is that an AutoRAID? I had one of those hooked up to a 6-way K570 running PeopleSoft over Oracle 8.0.5. Yuck. P**s-poor performance all the way around. Especially when the disks started to fill up. The problem was that the array got so busy internally swapping

Re: Unidata DB

I have not heard of it but for info you can start at http://www-4.ibm.com/software/data/u2/unidata/ Rick KENNETH

Fw: Limiting RMAN backups-Please help

- Original Message - To: Sona [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 9:20 AM You could move the file and change the entry in the recovery catalog, I quesss. I have never tried this so I'm not sure if it would work. The directory and name of the backupset piece is in

INFORMIX 7.3 to ORACLE 8.1.7 (New info)

Since I said I'll tell you how it went here it is. We used Oracle Migration Workbench, and it really works but...(there is always at least one but). In our case, it was amount of tables (more than 800) and data which we had to put into Oracle. Time effect was also very important. After

OT:looking for job

Hi List, I am sorry to post this OT request.But considering the job market outside, I am tempted to give a try. I will be coming out of my project by the end of this month. Please mail me at [EMAIL PROTECTED], if you have any Oracle DBA openings. Thanks, Surendra Consultant DBA Sony, NJ-USA --

RE: V_$SESSION question

SELECT NAME FROM SYS.GV_$DATABASE; Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Ghadge,Sameer [SMTP:[EMAIL PROTECTED]] Sent: Tue, February 12, 2002 11:53 AM To: Multiple recipients of list ORACLE-L Subject: V_$SESSION question Hi,

Extent grab ...

Gurus, Is there any way to fond out the rate of extent grab by a segment from the data dictionary. Thanks in advance. Anjan begin:vcard n:Thakuria;Anjan tel;work:817-963-3291 x-mozilla-html:TRUE url:www.eds.com org:EDS;Midrange Database Engineering adr:;;;Fort Worth;Texas;76155;U.S.A

ORA-600 [1158] on 8.1.7

Hi, We have a database running version 8.1.7.0 on AIX 4.3.3 that intermittently crashes with an ORA-600 [1158] error. Oracle's ORA-600 lookup tool did not have any hits. There was no specific resolution from Oracle support for this error - just a general suggestion to upgrade to the latest

SOLVED: URGENT: need help by point in time recovery

Hi Ray, the instance has only one data and one index tablespace. Hole database is only 1.5 gig. I solved my problem. I restored a cold backup to another instance and then I recreated my controlfile and recoverd my database in time. Then I've exported my lost table and imported it to production.

Re: LMT to DMT

Thanks, I don't have pkzip, just winzip. Don't worry, I got it from http://www.winzip.com/xcmdline.htm Joan àãø éçéàì wrote: Hello Joan Try : pkzip -add zipfilename *.txt Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Joan Hsieh

RE: Create Database ... really dumb question

Okay... so it wasn't such a dumb question... there is bad block on the disk where the contolfile is... changing where I put it fixed the problem... Thank you all. -Original Message- Sent: Thursday, February 14, 2002 7:23 AM To: Multiple recipients of list ORACLE-L Okay... I am at a

RE: View for Procedure/Function SQL Code

Hello Aleem I did a trace from toad and here are the results: 14/02/2002 6:06:10 PM select /*+ CHOOSE */ CREATED, LAST_DDL_TIME, OBJECT_ID, STATUS, TIMESTAMP from ALL_OBJECTS where object_name = :objname and object_type = :objtype and owner = :ownere :OBJNAME = PSTUB :OBJTYPE =

RE: Create Database ... really dumb question

erm... highly embarrassed, slinks off into the corner. That was a total brain fart... Here is one of mine that works OK create database BRIT maxdatafiles 5000 maxinstances 8 maxlogfiles 32 character set US7ASCII national character set US7ASCII datafile

RE: Create Database ... really dumb question

Shouldn't your dbname be in double quotes create database testcc1 etc. etc... HTH Lee -Original Message- Sent: 14 February 2002 14:29 To: Multiple recipients of list ORACLE-L create database testcc1 controlfile reuse logfile ('/admin04/cc1test/redo01.log' size 1m reuse,

RE: Create Database ... really dumb question

I would think that the database name of testccl would need to be in double quotes. Kevin Bass Senior Manager, I.D.E. Americal Corporation Phone: (252) 762-2144 E-mail: [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 14, 2002 8:23 AM To: Multiple recipients of list

Re: Create Database ... really dumb question

I had a similar error to this. What my error turned out to be was the rollback_segments parameter was not commented out in the initdb.ora parameter file. The private rollback segments had not been created yet and oracle could not find them to start the database. I commented out this parameter

MsAccess calling PL/SQL

Hallo, anyone whom can give me an example onhow to write an MsAccess procedure which make a call to a pl/sqlprocedure. I want the MsAccess procedure send 5 parametsrs through to pl/sql. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Re: Unidata DB

Different product: From a posting on comp.databases: it actually started life as a system called GIRLS. Meant for tracking helicopter parts. It then split into two - owned by two companies called Pick Systems and Microdata. Pick Systems then licenced their version which became Reality, D3,

RE: Create Database ... really dumb question

Rick It was similar to two manuals, a book, and metalink... thus the TREMENDOUS frustration... I moved the first control file... and it worked... corrupt block... I AM NOT AN idiot!!! Thank you! April -Original Message- Sent: Thursday, February 14, 2002 9:21 AM To: [EMAIL PROTECTED];

RE: whitespaces

Title: RE: whitespaces use the rtrim function. rtrim(char[,set]) - char, with final characters removed after the last character not in set. set defaults to ' '. i.e.: update table set field=rtrim(field); Jon Baker Database Architect [EMAIL PROTECTED] www.netsec.net

RE: Unidata DB

UniData and UniVerse are extended relational databases that were acquired as part of the Informix buyout. UniData was originally developed by the UniData Company and UniVerse was developed by VMark; VMark also developed Data Stage, using the UniVerse DB. The two companies merged to form

RE: whitespaces

Try update table_name set field_name = rtrim(field_name); I think the Right Trim should clear off the trailing spaces. -Original Message- Sent: Thursday, February 14, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Hi, What query can i run to to eliminate trailing

RE: Create Database ... really dumb question

Sorry... really bad day... another script is eating huge amounts of paging space on prod server... turns out that there was corrupt blocks on disk where control file was... move control file... rerun script... runs fine. Thank you! 8-) April -Original Message- Sent: Thursday,

RE: whitespaces

update mytable set myfield = rtrim(myfield) ; That's the simple answer. If most of your fields do not have trailing spaces, then: update mytable set myfield = rtrim(myfield) where myfield like '% ' ; If your table is large, you'll need to watch out for rollback issues, etc. I'm sure there are

RE: Create Database ... really dumb question

Not per the LESS than Friendly manuals... Admin guide, 2-12 -Original Message- Sent: Thursday, February 14, 2002 10:23 AM To: '[EMAIL PROTECTED]' Cc: April Wells Shouldn't your dbname be in double quotes create database testcc1 etc. etc... HTH Lee -Original Message-

RE: HOW TO MAKE FAST EXPORT

Title: RE: HOW TO MAKE FAST EXPORT Check the Utilities manual for the DIRECT=Y parameter Matt Adams - GE Appliances - [EMAIL PROTECTED] I've been so downhearted ever since the day we met. You're love ain't nothin' but the blues. Baby how blue can you get? - Jonny Moore and the

Re: Importing SQL 7.0 tables

If you know the table names already, this Perl script will dump the tables into CSV format for you. From there you can build SQL*Loader scripts to load the data. For anyone wondering why I didn't just suggest using the Oracle utilities for migrating from SQL Server to Oracle, it doesn't always

Re: Call PL/SQL from MsAccess

Roland, Believe it or not, the best place to find this is at support.microsoft.com. There are a number of papers there detailing how to use Oracle with MS products. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/14/02 03:43 AM Please respond to ORACLE-L To:

RE: Unidata DB

Ah... It looks like it related to the IBM takeover of Informix... UniData UniData is an extended-relational, ODBC-compliant database that supports repeating groups, hierarchies, and arrays. UniData offers both best-of-breed native interfaces with ActiveX, Java and C interfaces as well as

Re: Create Database ... really dumb question

[SARKAR, Samir] Check Metalink Note : 56016.999 Is there any way to get access to metalink for those of us not fortunate enough to have an Oracle support contract? (Startup life is fun!) -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB

RE: Create Database ... really dumb question

Try this: create database testcc1 controlfile reuse logfile ('/admin04/cc1test/redo01.log') size 1m reuse, ('/admin05/cc1test/redo02.log') size 1m reuse, ('/admin06/cc1test/redo03.log') size 1m reuse datafile '/data10/cc1test_system.dbf' size 100m reuse / First thing it

RE: Create Database ... really dumb question

April, Sorry about that - I looked at the docs again, and I don't think you can do it the way you had it originally. I created my last db like so: create database WTWU maxinstances 1 maxlogfiles 32 maxdatafiles 99 noarchivelog character set WE8ISO8859P1 datafile

Re: DB sizing - whitepaper

How you plan the Database sizing for a given application? Ramesh, They may have been looking for a more obvious response, like starting with the type of application rather than its size; I'm familiar with transaction processing systems (ie, an ATM) and decision

Call PL/SQL from MsAccess

Here's some code that sends two parameters--you should be able to adapt it to your needs. I'm using ADO 2.6. == S u b RunOracleSP() Dim cmd As ADODB.Command Dim con As ADODB.Connection Dim prm As ADODB.Parameter Dim Network As Object Set cmd = New

RE: Create Database ... really dumb question

Yes. You call your local oracle office and get yourself a support contract. WARNING: YOU MAY BE REQUIRED TO SIGN A CHECK IN THE PROCESS -Original Message- Sent: Thursday, February 14, 2002 12:28 PM To: Multiple recipients of list ORACLE-L [SARKAR, Samir] Check Metalink Note

RE: Create Database ... really dumb question

April, The 'size 1m reuse' should be outside the parentheses: - logfile ('/admin04/cc1test/redo01.log', '/admin05/cc1test/redo02.log', '/admin06/cc1test/redo03.log') size 1m reuse HTH -- David Lord -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] Sent: 14 February

Re[2]: [sans@sans.org: SANS FLASH ALERT: Widespread SNMP Vul

Joan, The Oracle intelligent agent which uses dbsnmp is not the problem here. The real problem is the snmp agent that is running on the computer and owned by root. Therefore your SA needs to do something, not you. Dick Goulet Reply Separator

Re: ORA-600 [1158] on 8.1.7

With every parchset they provide list of fixes in readme file. You can check it before downloading or applying patches...However, it is better to go to 8.1.7.2 which has lot of fixes... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

RE: MsAccess calling PL/SQL

Check Microsoft's web site for documents on using ADO to call stored procedures from VBA. There will be alot of examples there. Beth -Original Message- Sent: Thursday, February 14, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Hallo, anyone whom can give me an example

RE: Unidata DB

Yeah...I forgot about GIRLS! There was also a series of companies called Ultimate (used DEC LSI and Honeywell hardware), General Automation (the Zebra line), and others. Revelation was a PC-based product initially published by Cognos if I remember correctly. It required the 8087 numeric

RE: LMT to DMT

Command Line Support Add-On Note: at the time of this writing, the command line support add-on has still not been officially released, but a pre-release beta test version is available as a free download from the web page http://www.winzip.com/wzcline.cgi . The WinZip Command Line

Re: Performance Tuning

Okay, I'll plug my own list of recommendations on Amazon. It should come up from this URL: http://www.amazon.com/exec/obidos/tg/listmania/list-browse/- /VL8CI2YJANX1/qid=1013704150/sr=5-1/ref=sr_5_1/103-8633316- 6595843 If it doesn't, just enter 'Oracle performance tuning' in a search on

ora -01122

Hi list, I have an urgent problem for startup database when I try to stratup database I get this error: ora-01122 database file 29 failed verification check ora-01110 data file 29 databaseQDX.dbf ora-01251 unknown file header version read for file 29 Please if any body have any idea is very

Re: Extent grab ...

I guess I should be more specific. I am trying to find out the growth rate of a table on a 7.3.4 database. I did not get any info from the previous DBA. Can somebody tell me if there is a was to find out from the data dictionary how many extents by which this table has extended and when; the

RE: Extent grab ...

you'll have to capture that information manually. Of course if you need a shortcut, use DBA module of TOAD, when you view tablespaces, it can create scripts and dbms_job to activate space monitoring. It can then show you space usage in a graphical manner for tablespaces and datafiles. It doesn't

RE: RE: Rollback Segment Problem

Hi G_DBA , The transaction id (which is recorded in the ITL) consists of 3 components. Undo Segment Number, Slot Number and Wrap Number. THe max value of the wrap number is limited by UB4MAXVAL. (Approx 4G in numbers) and once it reaches the MAXVAL the rollback segment is considered as DEAD.

Re: ora -01122

Well, looks like you have a recovery scenario on your hands. What version of Oracle are you on? What is your Operating System/platform? In what manner did the database stop that now requires you to start it up? Are you in archivelog mode? When was you last backup? Was it hot or cold?

  1   2   >