date:20020214


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
 partitioning. 
 
 thanks in advance,
 Sathish.
 
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Sathish Tatikonda
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

Some days you're the pigeon, some days you're the statue

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: View for Procedure/Function SQL Code

2002-02-14 Thread Ayyappan S


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!

Aleem
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Abdul Aleem
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinard Xing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

This communication contains information, which is confidential and may also
be privileged. It is for the exclusive use of the intended recipient(s). If
you are not the intended recipient(s), please note that any distribution,
printing, copying or use of this communication or the information in it is
strictly prohibited. If you have received this communication in error,
please notify the sender immediately and then destroy any copies of it.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ayyappan S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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 question being - why?

hth
connor

 --- Joan Hsieh [EMAIL PROTECTED] wrote:  Hi
listers,
 
 How to convert the locally management tablespace
 back to dictionary
 management tablespace? I used dbms_space_admin
 migrated all the
 tablespaces to LMT. Now I want convert back on some
 tablespaces, I
 remember I read the notes indicate step to step how
 to do this. Just
 can't find it anymore. Could you please give me some
 light on this?
 
 Another question I posted yesterday, but no replied
 so far. I post here
 again.  Thanks, 
 
 JOan
 
 
 I am looking for a solution to zip all the backup
 files into one
  backupset.zip file on NT. I have trouble to find
 the dos command
 line to
  do this.(pkzip or winzip command line? should
 executed in a batch
 file
  after backup) Can you share this info with us? This
 should be a
 very
 easy thing to do. NT comand compact /C is not what I
 want. Thanks,
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Joan Hsieh
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

Some days you're the pigeon, some days you're the statue

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Importing SQL 7.0 tables

2002-02-14 Thread Mark Leith


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
quotes around the table names (select empid from emp where...).

Regards

Mark

-Original Message-
Pather
Sent: 14 February 2002 05:43
To: Multiple recipients of list ORACLE-L


Ferry,

You could dump these tables to a flat file (csv) using SQL Server's DTS and
then use SQL Loader to upload the data into Oracle.

Or

You could use SQL Server's DTS to upload the data directly into Oracle.
You need to create an ODBC connection first to your Oracle DB.

Or

Create a database link using sp_linkedservers on SQL Server and copy the
data.

HTH
$uhen




I need to import into Oracle my SQL 7.0 tables.
How could I complete this?

Thanks,

Ferry Situmorang:
Using Oracle 8.1.7 Designer 6i R4
PT Perkebunan Nusantara XIII (Persero)
Pontianak-Indonesia
http://www.ptpn13.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ferry Situmorang
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suhen Pather
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: DB sizing - whitepaper

2002-02-14 Thread rpapnoi


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 something?
Seniors, please advice.

Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
(BrainBench  Brainbuzz Certified Oracle 8/8i DBA  Developer)
http://www22.Brinkster.com/rpapnoi

-- Original Text --

To: internet[Multiple recipients of list ORACLE-L [EMAIL PROTECTED]]

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 this case, such configuration guides are often more misleading
than guiding.  There have been attempts at making rules like this
application is like X tpc-c transactions, but they also fail to be of
any actual value.

Also, if what you really were looking for was something to tell you the
size (in GB) of the required disk to store schema with a certain
definition, you could create some rough estimates.  However, with todays
typical disksizes, you run out of spindles much before you run out of GB.

Thanks, Bjørn.

[EMAIL PROTECTED] wrote:

Hi Gurus,
Can anybody mail me the the whitepaper/policy document on database sizing?
Thanks in advance.

Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
(BrainBench  Brainbuzz Certified Oracle 8/8i DBA  Developer)
http://www22.Brinkster.com/rpapnoi



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?ISO-8859-1?Q?Bj=F8rn?= Engsig
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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 simply exporting/importing
 (whilst no users are
 online). If you have any triggers that fire on
 insert in to the tables, then
 you could also disable those..
 
 Any thing else list?
 
 HTH
 
 Mark
 
 -Original Message-
 Sent: 13 February 2002 23:20
 To: Multiple recipients of list ORACLE-L
 
 
 Hi
 How to make import fast except BUFFER size increase
 and big rollback segment
 if I am reorganising the database.
 Thanks
 -Seema
 
 
 

_
 Get your FREE download of MSN Explorer at
 http://explorer.msn.com/intl.asp.
 
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Seema Singh
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Mark Leith
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

Some days you're the pigeon, some days you're the statue

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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 don't know if
 there is any existing Oracle objects that I can use
 to retrieve information like
 Username, login time, logout time and the history.
 
 If you know some object like this, please email me
 back.  Thanks!
 
 TIA
 
 Matt
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

Some days you're the pigeon, some days you're the statue

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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; otherwise, they are 16 MB.

hth
connor

 --- Arul kumar [EMAIL PROTECTED] 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 application
 / database..., why
 should i have this space allocated.?
 
 Moreover, this space allocation seems to be
 affecting the PGA size!!
 
 Any suggestions to make it NULL or zero. ??
 
 Thank you.
 
 regards,
 Arul.
 

*
 Disclaimer
 
 This message (including any attachments) contains 
 confidential information intended for a specific 
 individual and purpose, and is protected by law. 
 If you are not the intended recipient, you should 
 delete this message and are hereby notified that 
 any disclosure, copying, or distribution of this
 message, or the taking of any action based on it, 
 is strictly prohibited.
 

*
 Visit us at http://www.mahindrabt.com 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

Some days you're the pigeon, some days you're the statue

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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
 
 __
 Do You Yahoo!?
 Send FREE Valentine eCards with Yahoo! Greetings!
 http://greetings.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: sarath kumar
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

Some days you're the pigeon, some days you're the statue

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

2002-02-14 Thread SubbaReddy M


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 = STDIN if ( defined STDIN);

die   perl $0  data.txt if (@data);

print User: $user \n;
foreach (@data){
print $_;
}

1;
### EOF #



I have a perl scripts, which expects the input file as redirection at
command line.
i.e.,
[user3@Linux] #  perl printFile.pl   data.txt

= This will display the inputed file content, if file name is piped as
redirection.
= Otherwise, program will wait to accept the file.
= So, I don't want program prompt for the file name,
= I would like to check the file name is given or not.
= But, becuase of STDIN statement in program to dump the content of the
file into Array, will cause to wait ifdata.txt is missing at command
line.
= It's very easy, if @ARGV checking, will have the command line parameters.
But, it 's not in command line paramenters list.
= It is input redirection.

= 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 proceed.

Thanks in advance.

Regards,

~ SubbaReddy .M
   Sr. Programmer, Frontlinesoft, Hyderabad
   http://www.frontlinesoft.com
   Ph: 91-40-3392147, 3391683 (O)
 91-40-3307980 ( R)
   w3page: http://www.geocities.com/msubbareddy/
   ICQ: 56093095
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: SubbaReddy M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Call PL/SQL from MsAccess

2002-02-14 Thread Roland . Skoldblom


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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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
 To:   Multiple recipients of list ORACLE-L
 Subject:  9i Installation error ora-01503, 00200, 00202
 
 Hi,
 
 In trying to install oracle 9i on a windows 2000 Server with General
 Purpose
 database option it gives the errors
 ORA-01503, ORA-00200 and then ORA-00202 while creating and configuring
 database. 
 
 After checking the disc space about 1.7 GB, I tried the database
 configuration wizard again. But the problem still persists. Is there
 anything else to check?
 
 TIA!
 
 Aleem
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Abdul Aleem
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Another doubt in 9.0.1.0.0 database..

2002-02-14 Thread Joe Testa


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 application / database..., why 
 should i have this space allocated.?
 
 Moreover, this space allocation seems to be affecting the PGA size!!
 
 Any suggestions to make it NULL or zero. ??
 
 Thank you.
 
 regards,
 Arul.
 *
 Disclaimer
 
 This message (including any attachments) contains
 confidential information intended for a specific
 individual and purpose, and is protected by law.
 If you are not the intended recipient, you should
 delete this message and are hereby notified that
 any disclosure, copying, or distribution of this
 message, or the taking of any action based on it,
 is strictly prohibited.
 
 *
 Visit us at http://www.mahindrabt.com
 


-- 
Joe Testa, Oracle DBA
Nothing new to put here, hmm






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: A doubt in 9.0.1.0.0 database..

2002-02-14 Thread Joe Testa


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
 undo_retention=900
 undo_suppress_errors=FALSE
 undo_tablespace=UNDOTBS
 
 While querying V$waitstat, got the foll. :
 
 CLASSCOUNT TIME
 system undo header00
 system undo block  00
 *undo header  312  64*
 undo block 1  32
 
 The entry for undo header indicates Undo Header contention for 
 rollback.. Right ?
 
 Since it is AUTO managed, how do i tune ??
 
 I have chk  the space usage of the tablespace, it is fairly enough free
 space...
 
 Any suggestions / tips ?
 
 Thank You.
 
 regards,
 Arul.
 *
 Disclaimer
 
 This message (including any attachments) contains
 confidential information intended for a specific
 individual and purpose, and is protected by law.
 If you are not the intended recipient, you should
 delete this message and are hereby notified that
 any disclosure, copying, or distribution of this
 message, or the taking of any action based on it,
 is strictly prohibited.
 
 *
 Visit us at http://www.mahindrabt.com
 


-- 
Joe Testa, Oracle DBA
Nothing new to put here, hmm






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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:   Multiple recipients of list ORACLE-L
 Subject:  Import error from 8.1.7.2.0 to 8.0.5
 
 
 Hi All, 
 
 I am trying to export a table from one Oracle db (Version 8.1.7.2.0)  and
 import into another Oracle db (Version 8.0.5) and I have got the following
 error during import- 
 
 IMP-00069: Could not convert to environment national character set's
 handle 
 IMP-00021: operating system error - error code (dec 2, hex 0x2) 
 IMP-0: Import terminated unsuccessfully 
 
 Request your help/suggestion on the above. 
 
 Thanks in advance. 
 
 PM 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Free dbs / Mysql Ver 2

2002-02-14 Thread Henrik Ekenberg [EMAIL PROTECTED]


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 good or bad history ?
-!-
-!-
-!-
-!-
-!-Regards
-!-HEnrik
-!-
-!-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Henrik Ekenber
  INET: [EMAIL PROTECTED] [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

2002-02-14 Thread Oberkofler, Dieter

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 try to bulk retrieve the data in
a collection and then to bulk insert it in the new table
but i would guess that the only real way to optimize your
statement might by to go for the insert into b select a
construct if this is an option in your case.


DO


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 22:05
To: Multiple recipients of list ORACLE-L
Subject: How to do a bulk bind to load data into a table



I'm looking at a way to speed up a huge insert (100K records at a time). In looking at FORALL, it looks like it could do what I want, but I'm not sure how to set it up correctly. What I currently do is:

set up a cursor, selecting the rows from table a
for cursor_rec in cursor_data loop
 insert into table b
 commit evey 2K rows
end loop


Is there a better way to do this?


Thank you for your help.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
 INET: [EMAIL PROTECTED]


Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Re:Oracle parallel server

2002-02-14 Thread dgoulet


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 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: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RedHat Linux 7.2 Oracle 9i Shutdown

2002-02-14 Thread James Manning


[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 like this:

#!/bin/sh
#
# pulse This script handles the starting and stopping of the various
#   clustering services in Red Hat Linux.
#
# chkconfig: - 60 10
# description:  pulse is the controlling daemon that spawns off the lvs \
#   daemon as well as heartbeating and monitoring of services \
#   on the real servers.
# processname: pulse
# pidfile: /var/run/pulse.pid
# config: /etc/lvs.cf

Then you can just use the chkconfig / ntsysv / etc. interface for turning
things on and off in various runlevels.  The 2 chkconfig numbers are
the symlink numbers (controlling order of execution) for startup and
shutdown respectively.  Much much easier, at least IMHO, than doing
symlinks by hand.

James
-- 
James Manning [EMAIL PROTECTED]
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7  9C8E A0BF B026 EEBB F6E4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James Manning
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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 database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

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

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas

begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
%;G0N#0H 
end

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

2002-02-14 Thread James Manning


[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 proceed.

Bit of an odd list for this, but... :)

Just use the  operator instead.  It'll use filename params that
are available or suck from stdin.  It's a Good Thing.  Just make
sure you've deleted anything from @ARGV that you don't want treated
as a filename before you first use it.

jmm@bp6:/tmp cat a

jmm@bp6:/tmp cat b

jmm@bp6:/tmp cat c

jmm@bp6:/tmp perl -e 'shift; print ' a b c


jmm@bp6:/tmp cat b c | perl -e 'shift; print ' a



James
-- 
James Manning [EMAIL PROTECTED]
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7  9C8E A0BF B026 EEBB F6E4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James Manning
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Free dbs / Mysql Ver 2

2002-02-14 Thread Marin Dimitrov



- 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 attempt to retain a little of the 
old life, end up torn apart by their own memories. 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marin Dimitrov
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: LMT to DMT

2002-02-14 Thread Joan Hsieh


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?
  --
 --- -- 
  TABLESPACE_NAMEVARCHAR2
  IN
 
 the obvious question being - why?
 
 hth
 connor
 
  --- Joan Hsieh [EMAIL PROTECTED] wrote:  Hi
 listers,
 
  How to convert the locally management tablespace
  back to dictionary
  management tablespace? I used dbms_space_admin
  migrated all the
  tablespaces to LMT. Now I want convert back on some
  tablespaces, I
  remember I read the notes indicate step to step how
  to do this. Just
  can't find it anymore. Could you please give me some
  light on this?
 
  Another question I posted yesterday, but no replied
  so far. I post here
  again.  Thanks,
 
  JOan
 
 
  I am looking for a solution to zip all the backup
  files into one
   backupset.zip file on NT. I have trouble to find
  the dos command
  line to
   do this.(pkzip or winzip command line? should
  executed in a batch
  file
   after backup) Can you share this info with us? This
  should be a
  very
  easy thing to do. NT comand compact /C is not what I
  want. Thanks,
  --
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  --
  Author: Joan Hsieh
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX:
  (858) 538-5051
  San Diego, California-- Public Internet
  access / Mailing Lists
 
 
  To REMOVE yourself from this mailing list, send an
  E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of
  'ListGuru') and in
  the message BODY, include a line containing: UNSUB
  ORACLE-L
  (or the name of mailing list you want to be removed
  from).  You may
  also send the HELP command for other information
  (like subscribing).
 
 =
 Connor McDonald
 http://www.oracledba.co.uk (mirrored at
 http://www.oradba.freeserve.co.uk)
 
 Some days you're the pigeon, some days you're the statue
 
 __
 Do You Yahoo!?
 Everything you'll ever need on one web page
 from News and Sport to Email and Music Charts
 http://uk.my.yahoo.com
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: =?iso-8859-1?q?Connor=20McDonald?=
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Import error from 8.1.7.2.0 to 8.0.5

2002-02-14 Thread Rick_Cale



Could you use the COPY command?

Rick


   

àãø éçéàì  

adary@mehishTo: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
.co.il  cc:   

Sent by: Subject: RE: Import error from 8.1.7.2.0 
to 8.0.5 
root@fatcity.  

com

   

   

02/14/2002 

07:58 AM   

Please 

respond to 

ORACLE-L   

   

   





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:   Multiple recipients of list ORACLE-L
 Subject:   Import error from 8.1.7.2.0 to 8.0.5


 Hi All,

 I am trying to export a table from one Oracle db (Version 8.1.7.2.0)  and
 import into another Oracle db (Version 8.0.5) and I have got the
following
 error during import-

 IMP-00069: Could not convert to environment national character set's
 handle
 IMP-00021: operating system error - error code (dec 2, hex 0x2)
 IMP-0: Import terminated unsuccessfully

 Request your help/suggestion on the above.

 Thanks in advance.

 PM
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


åy«±çê~'jSÄ,PÛiÿü0ÂÚ}ª¢`.¶+ ÑF'$ ©^µæ¦æ¥¶(V
+r5ëp¢¹z»âqëçÎwó9ÔPó9ßÎtçT8'è®xæåÂ'µêçzÖqë,üÆ¢)à.+-±:Ã*.®Ç¥}úèØb²f¢)à+-±éÝjq
+j)fzËëh.+-êî}«\Ü¢ièµá$ì¥éex(|¸¬´k«¹©Ý{azg¬±¨àØw%¹×)Þríj)â
+I@NDº+¶§jg¨~f¢)à+-Ê°j{m¡·«zj/y×ë¢f(ºf²j[(±éÝ¶³Ü¢i×è®az¸§~æjØ¨X¤zË±Êân)à

whitespaces

2002-02-14 Thread iashraf


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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: A doubt in 9.0.1.0.0 database..

2002-02-14 Thread Arul kumar

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 V$waitstat...inspite
of being allocated enough space for the underlying tablespace ( UNDOTBS
)??
I will appreciate , if u can really help me.
TIA
regards,
Arul.

Joe Testa wrote:
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
> 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 block
0
0
> *undo header
312
64*
> undo block
1
32
>
> The entry for "undo header" indicates Undo Header contention for
> rollback.. Right ?
>
> Since it is "AUTO" managed, how do i tune ??
>
> I have chk the space usage of the tablespace, it is fairly
enough free
> space...
>
> Any suggestions / tips ?
>
> Thank You.
>
> regards,
> Arul.
> *
> Disclaimer
>
> This message (including any attachments) contains
> confidential information intended for a specific
> individual and purpose, and is protected by law.
> If you are not the intended recipient, you should
> delete this message and are hereby notified that
> any disclosure, copying, or distribution of this
> message, or the taking of any action based on it,
> is strictly prohibited.
>
> *
> Visit us at http://www.mahindrabt.com
>
--
Joe Testa, Oracle DBA
Nothing new to put here, hmm
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
 INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051
FAX: (858) 538-5051
San Diego, California --
Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You
may
also send the HELP command for other information (like subscribing).

*
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*
Visit us at http://www.mahindrabt.com

Re: HOW TO MAKE FAST EXPORT

2002-02-14 Thread Joan Hsieh


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 [mailto:[EMAIL PROTECTED]]
 
  You could drop any indexes that are associated with the tables you
 are
  importing to - If you are simply exporting/importing (whilst
  no users are
  online). If you have any triggers that fire on insert in to
  the tables, then
  you could also disable those..
 
  Any thing else list?
 
  -Original Message-
  From: Seema Singh [mailto:[EMAIL PROTECTED]]
 
  How to make import fast except BUFFER size increase and big
  rollback segment
  if I am reorganising the database.
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Unidata DB

2002-02-14 Thread KENNETH JANUSZ




Has anyone heard of Unidata DB. It's relational and from 
IBM. 

Thanks,
Ken Janusz, CPIM

RE: Oracle parallel server

2002-02-14 Thread Sathish Tatikonda


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 aspect of implementation.

thanks in advance,
Sathish.

-Original Message-
Sent: Thursday, February 14, 2002 6:48 PM
To: Multiple recipients of list ORACLE-L


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 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: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sathish Tatikonda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Create Database ... really dumb question

2002-02-14 Thread Ron Rogers


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 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 database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cReceived: from CONNECT-MTA by galotterc1test/redo03.log' size 1m reuse
datafile '/data10/cc1test_system.dbf' size 100m reuse

WHAT is wrong with it.  I am really not this inept... really... but I
can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but
tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas

begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
%;G0N#0H 
end

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: April Wells
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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 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-
Sent: 14 February 2002 13:23
To: Multiple recipients of list ORACLE-L



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 database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

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

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas



___
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received
this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema
Helpdesk by telephone on +44 (0) 121 627 5600.
___


begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
M;G0N#0I4:4@:6YF;W)M871I;VX@8V]N=%I;F5D(EN('1H:7,@92UM86EL
M(ES('-TFEC=QY(-O;F9I95N=EA;!A;F0@9F]R('1H92!I;G1E;F1E
M9!UV4@;V8@=AE(%D9')EW-E92!O;FQY.R!I=!M87D@86QS;R!B92!L
M96=A;QY('!R:79I;5G960@86YD+V]R('!R:6-E('-E;G-I=EV92X@($YO
M=EC92!IR!H97)E8GD@9VEV96X@=AA=!A;GD@9ES8VQOW5R92P@=7-E
M(]R(-O'EI;F@;V8@=AE(EN9F]R;6%T:6]N()Y(%N6]N92!O=AE
MB!T:%N('1H92!I;G1E;F1E9!R96-IEE;G0@:7,@')O:EB:71E9!A
M;F0@;6%Y()E(EL;5G86PN(!)9B!Y;W4@:%V92!R96-E:79E9!T:ES
M(UEW-A9V4@:6X@97)R;W(L('!L96%S92!N;W1I9GD@=AE('-E;F1EB!I
M;6UE9EA=5L2!B2!R971UFX@92UM86EL+@H*0V]R]R871E(%-YW1E
M;7,L($EN8RX@:%S('1A:V5N(5V97)Y(')E87-O;F%B;4@')E8V%U=EO
M;B!T;R!E;G-UF4@=AA=!A;GD@871T86-H;65N=!T;R!T:ES(4M;6%I
M;!H87,@8F5E;B!S=V5P=!F;W(@=FER=7-ERX@(%=E(%C8V5P=!N;R!L
M:6%B:6QI='D@9F]R(%N2!D86UA9V4@W5S=%I;F5D(%S($@F5S=6QT
M(]F('-O9G1W87)E('9IG5S97,@86YD(%D=FES92!Y;W4@8V%RGD@;W5T
M('EO=7(@;W=N('9IG5S(-H96-KR!B969OF4@;W!E;FEN9R!A;GD@871T
,86-H;65N=X-@T*
end


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California

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

2002-02-14 Thread Jamadagni, Rajendra


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;
TYPE itt_PARTITION_NAMEIS TABLE OF
NCS_INDEX_STATS.partition_name%TYPE INDEX BY BINARY_INTEGER;
TYPE itt_HEIGHTIS TABLE OF NCS_INDEX_STATS.height%TYPE
INDEX BY BINARY_INTEGER;
TYPE itt_BLOCKSIS TABLE OF NCS_INDEX_STATS.blocks%TYPE
INDEX BY BINARY_INTEGER;
TYPE itt_LF_ROWS   IS TABLE OF NCS_INDEX_STATS.lf_rows%TYPE
INDEX BY BINARY_INTEGER;
TYPE itt_LF_BLKS   IS TABLE OF NCS_INDEX_STATS.lf_blks%TYPE
INDEX BY BINARY_INTEGER;
TYPE itt_LF_ROWS_LEN   IS TABLE OF
NCS_INDEX_STATS.lf_rows_len%TYPE INDEX BY BINARY_INTEGER;
TYPE itt_LF_BLK_LENIS TABLE OF
NCS_INDEX_STATS.lf_blk_len%TYPE INDEX BY BINARY_INTEGER;
TYPE itt_BR_ROWS   IS TABLE OF NCS_INDEX_STATS.br_rows%TYPE
INDEX BY BINARY_INTEGER;
TYPE itt_BR_BLKS   IS TABLE OF NCS_INDEX_STATS.br_blks%TYPE
INDEX BY BINARY_INTEGER;
TYPE itt_BR_ROWS_LEN   IS TABLE OF
NCS_INDEX_STATS.br_rows_len%TYPE INDEX BY BINARY_INTEGER;
TYPE itt_BR_BLK_LENIS TABLE OF
NCS_INDEX_STATS.br_blk_len%TYPE INDEX BY BINARY_INTEGER;
TYPE itt_DEL_LF_ROWS   IS TABLE OF
NCS_INDEX_STATS.del_lf_rows%TYPE INDEX BY BINARY_INTEGER;
TYPE itt_DEL_LF_ROWS_LEN   IS TABLE OF
NCS_INDEX_STATS.del_lf_rows_len%TYPE INDEX BY BINARY_INTEGER;
TYPE itt_DISTINCT_KEYS IS TABLE OF
NCS_INDEX_STATS.distinct_keys%TYPE INDEX BY BINARY_INTEGER;
TYPE itt_MOST_REPEATED_KEY IS TABLE OF
NCS_INDEX_STATS.most_repeated_key%TYPE INDEX BY BINARY_INTEGER;
TYPE itt_BTREE_SPACE   IS TABLE OF
NCS_INDEX_STATS.btree_space%TYPE INDEX BY BINARY_INTEGER;
TYPE itt_USED_SPACEIS TABLE OF
NCS_INDEX_STATS.used_space%TYPE INDEX BY BINARY_INTEGER;
TYPE itt_PCT_USED  IS TABLE OF NCS_INDEX_STATS.pct_used%TYPE
INDEX BY BINARY_INTEGER;
TYPE itt_ROWS_PER_KEY  IS TABLE OF
NCS_INDEX_STATS.rows_per_key%TYPE INDEX BY BINARY_INTEGER;
TYPE itt_BLKS_GETS_PER_ACCESS  IS TABLE OF
NCS_INDEX_STATS.blks_gets_per_access%TYPE INDEX BY BINARY_INTEGER;
TYPE itt_PRE_ROWS  IS TABLE OF NCS_INDEX_STATS.pre_rows%TYPE
INDEX BY BINARY_INTEGER;
TYPE itt_PRE_ROWS_LEN  IS TABLE OF
NCS_INDEX_STATS.pre_rows_len%TYPE INDEX BY BINARY_INTEGER;
TYPE itt_TIMESTAMP IS TABLE OF
NCS_INDEX_STATS.timestamp%TYPE INDEX BY BINARY_INTEGER;
TYPE itt_COLL_DURA IS TABLE OF
NCS_INDEX_STATS.coll_dura%TYPE INDEX BY BINARY_INTEGER;
--
-- Define a record of Table ...
TYPE typeRecStats IS RECORD
  ( OWNER  itt_OWNER
   ,NAME   itt_NAME
   ,PARTITION_NAME itt_PARTITION_NAME
   ,HEIGHT itt_HEIGHT
   ,BLOCKS itt_BLOCKS
   ,LF_ROWSitt_LF_ROWS
   ,LF_BLKSitt_LF_BLKS
   ,LF_ROWS_LENitt_LF_ROWS_LEN
   ,LF_BLK_LEN itt_LF_BLK_LEN
   ,BR_ROWSitt_BR_ROWS
   ,BR_BLKSitt_BR_BLKS
   ,BR_ROWS_LENitt_BR_ROWS_LEN
   ,BR_BLK_LEN itt_BR_BLK_LEN
   ,DEL_LF_ROWSitt_DEL_LF_ROWS
   ,DEL_LF_ROWS_LENitt_DEL_LF_ROWS_LEN
   ,DISTINCT_KEYS  itt_DISTINCT_KEYS
   ,MOST_REPEATED_KEY  itt_MOST_REPEATED_KEY
   ,BTREE_SPACEitt_BTREE_SPACE
   ,USED_SPACE itt_USED_SPACE
   ,PCT_USED   itt_PCT_USED
   ,ROWS_PER_KEY   itt_ROWS_PER_KEY
   ,BLKS_GETS_PER_ACCESS   itt_BLKS_GETS_PER_ACCESS
   ,PRE_ROWS   itt_PRE_ROWS
   ,PRE_ROWS_LEN   itt_PRE_ROWS_LEN
   ,TIMESTAMP  itt_TIMESTAMP
   ,COLL_DURA  itt_COLL_DURA);
--
-- Global table
recStats   typeRecStats;
..
PROCEDURE MOVE_STATS_TO_TABLE IS
--
BEGIN
FORALL i IN recStats.OWNER.first .. recStats.OWNER.last
INSERT INTO NCS_INDEX_STATS
( OWNER ,NAME
,PARTITION_NAME ,HEIGHT
,BLOCKS ,LF_ROWS
,LF_BLKS ,LF_ROWS_LEN
,LF_BLK_LEN ,BR_ROWS
,BR_BLKS ,BR_ROWS_LEN
,BR_BLK_LEN ,DEL_LF_ROWS
,DEL_LF_ROWS_LEN ,DISTINCT_KEYS
,MOST_REPEATED_KEY ,BTREE_SPACE
,USED_SPACE ,PCT_USED
,ROWS_PER_KEY ,BLKS_GETS_PER_ACCESS
,PRE_ROWS ,PRE_ROWS_LEN
,TIMESTAMP ,COLL_DURA )
VALUES
( recStats.OWNER(i) ,recStats.NAME(i)
,recStats.PARTITION_NAME(i) ,recStats.HEIGHT(i)
,recStats.BLOCKS(i) ,recStats.LF_ROWS(i)
,recStats.LF_BLKS(i) ,recStats.LF_ROWS_LEN(i)
,recStats.LF_BLK_LEN(i) ,recStats.BR_ROWS(i)
,recStats.BR_BLKS(i) ,recStats.BR_ROWS_LEN(i)
,recStats.BR_BLK_LEN(i)

RE: Create Database ... really dumb question

2002-02-14 Thread SARKAR, Samir


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-
Sent: 14 February 2002 13:23
To: Multiple recipients of list ORACLE-L



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 database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

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

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas



___
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk 
by telephone on +44 (0) 121 627 5600.
___

begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
%;G0N#0H 
end

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: SARKAR, Samir
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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 5:41 PM


Hi,
I have taken a incr backup using RMAN at location /ora/backup.Now I want to
change the location of the backup to /ora/backup1.
How do I change the backup location in the recovery catalog?

TIA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: View for Procedure/Function SQL Code

2002-02-14 Thread DBarbour

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 Code Hi!Is there a view to see the code written in the procedure/function code, theparameters, return types etc.TIA!Aleem--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Abdul Aleem INET: [EMAIL PROTECTED]Fat City Network Services  -- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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 capacity measured
in GB is easily fulfulled using just a few physical drives, but your I/O
requirements cannot be fulfilled with such a setup. Disks of 50 or even
100 Gb, which are getting common these days are simply too big as you end
up with too few of them, but it can be really hard to argue with your purchising
division that you need 1Tb of disk if you are only storing 100Gb. So you
need to argue that you need 500 I/O's per second and lie about the number
of GBs you get.

And again - you are back to the application, and the only real way to get
to a number of necessary I/O's is testing. If your application is very well
written, you should have good chance of extrapolating from a small test setup
to a large production environment, but unfortunately, applications are not
always well written...

Thanks, Bjrn.

[EMAIL PROTECTED] wrote:

BjrnWhat 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 something? Seniors, please advice.Regards,Ramesh D PapnoiOracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India(BrainBench Brainbuzz Certified Oracle 8/8i DBA Developer)http://www22.Brinkster.com/rpapnoi-- Original Text --To: internet["Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]]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 this case, such configuration guides are often more misleading than guiding. There have been attempts at making rules like "this application is like X tpc-c transactions", but they also fail to be of any actual value.Also, if what you really were looking for was something to tell you the size (in GB) of the required disk to store schema with a certain definition, you could create some rough estimates. However, with todays typical disksizes, you run out of spindles much before you run out of GB.Thanks, Bjrn.[EMAIL PROTECTED] wrote:

Hi Gurus,Can anybody mail me the the whitepaper/policy document on database sizing? Thanks in advance.Regards,Ramesh D PapnoiOracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India(BrainBench Brainbuzz Certified Oracle 8/8i DBA Developer)http://www22.Brinkster.com/rpapnoi

RE: Create Database ... really dumb question

2002-02-14 Thread Mercadante, Thomas F


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 Professional


-Original Message-
Sent: Thursday, February 14, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L



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 database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

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

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas

begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
%;G0N#0H 
end

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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 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 database testcc1
 *
 ERROR at line 1:
 ORA-01501: CREATE DATABASE failed
 ORA-02084: database name is missing a component

 THIS is my script...

 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

 WHAT is wrong with it.  I am really not this inept... really... but I
can't
 see what is wrong with the database name.

 Thanks in advance for there not being GAILS of laughter... but tiredness
is
 getting to me.

 April Wells
 Corporate Systems
 Amarillo Texas









 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: April Wells
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Skewed Wait Times

2002-02-14 Thread Mogens Nørgaard




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 v$filestat and IO
tuning, I think.
  Raj
  
  Connor McDonald [EMAIL PROTECTED]
  Sent by: [EMAIL PROTECTED]
  02/09/2002 10:28 AM PST
  Please respond to ORACLE-L
  
  To:Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
  cc:
  bcc:
  Subject:Re: Skewed Wait Times
  
  
  
  You're thinking of v$mystat, but v$session_event
is
available in 'vanilla' oracle.
  
  hth
connor
  
   --- [EMAIL PROTECTED] wrote: 
Hello All,

 After setting timed_statistics to true, I am finding
 something strange with
 the wait times in v$system_event for the event 'db
 file sequential read'.
 The wait times far exceed the uptime of the
 database. What I can think of
 is, say there are 10 sessions waiting for a single
 hot block for say 1 ms.
 The wait is actually for 1ms, but for the 10
 sessions it add to 10ms.

 Or that the times are skewed. I remember reading
 about this in 'Practical
 Oracle 8i' where Jonathan Lewis had addressed these
 issues. There was also
 a script in there to create your own version of
 v$system_event, reading
 from two x$ tables. I dont have the book handy with
 me now. Would someone
 be kind enough to forward the same to me?

 Thanks
 Raj

 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
  
 --
 Author:
  INET: [EMAIL PROTECTED]

 Fat City Network Services  -- (858) 538-5051 FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from). You may
 also send the HELP command for other information
 (like subscribing).
  
  =
Connor McDonald
  http://www.oracledba.co.uk
 (mirrored at
  http://www.oradba.freeserve.co.uk
)
  
  "Some days you're the pigeon, some days
you're the statue"
  
  __
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
  http://uk.my.yahoo.com
  
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
 INET: [EMAIL PROTECTED]
  
  Fat City Network Services  -- (858) 538-5051
FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--  Please see the official ORACLE-L FAQ: http://www.orafaq.com --  Author:
   INET: [EMAIL PROTECTED]  Fat City Network Services-- (858) 538-5051
 FAX: (858) 538-5051 San Diego, California-- Public Internet access
/ Mailing Lists  
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED]
(note EXACT spelling of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
from).  You may also send the HELP command for other information (like subscribing).

UNIX Performance Issues

2002-02-14 Thread Rahul Dandekar


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 actually plan to script these things and run these scripts at certain
intervals and put the data in database (Oracle 8i) and then do the
crunching...
Inputs are appreciated...

1. I/O
   What is current I/O status. Is there a lot of I/O going on?

2. Paging
   Is there lot of swapping / paging happening?
   Which processes are getting swapped in/out continuously?
   Are the I/O waits due to swapping / paging or regular stuff
   like DB waiting to read from DB files?

3. CPU
   What is the CPU utulization? Which processes are using lot of CPU?

4. Memory
   What is the current picture of Real and Virtual Memory?
   What processes are using how much memory? Which processes
   are in real memory and which are in virtual memory?
   Which processes are swapped in and out from/to real/virtual memory
   and how many times?

5. Network
   What is the percentage utilization of network pipe?
   What is the capacity (bandwidth) of the network device?
   What percentage of that bandwidth is getting used?
   Is the system waiting for data from outside network I/O?
   In short, is there any bandwidth problem with network device
   or network traffic.

Thanks,

  ___   ______   ___   ___
 /  /\ /  /\  /  /\ /  /\ /  /\
/  /::\   /  /::\/  /://  /://  /:/
   /  /:/\:\ /  /:/:|   /  /://  /://  /:/
  /  /::\ \:\   /  /:/|:|  /  /::\  __   /  /:/  ___   /  /:/
 /__/:/\:\_\:\ /__/::\|:| /__/:/\:\/ /\ /__/:/  /  /\ /__/:/
 \__\/~|::\/:/ \__\/\:\:| \__\/  \:\/:/ \  \:\ /  /:/ \  \:\
|  |:|::/ \__\::|  \__\::/   \  \:\  /:/   \  \:\
|  |:|\/   |  |:|  /  /:/ \  \:\/:/ \  \:\
|__|:| |__|:| /__/:/   \  \::/   \  \:\
 \__\|  \__\| \__\/ \__\/ \__\/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul Dandekar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Another doubt in 9.0.1.0.0 database..

2002-02-14 Thread Enrique Orbegozo






  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 9.0.1 symptom: ORA-00604: error 
  occurred at recursive SQL level 1 symptom: 
  ORA-04031: unable to allocate %n bytes of shared memory 
  (" shared 
  pool",%s,%s,%s) symptom: ORA-06512: at 
  "SYS.DBMS_CDC_PUBLISH", line 0 symptom: ORA-06512: 
  at line 4 change: Java_pool_size = 
  4M cause: 
  Bug:2084844: ERROR OCCURRED AT RECURSIVE 
  SQL LEVEL 1
  
  fix:
  
  Startup the database caused 
  following errors logged in the alert file:
  
  ORA-00604: error occurred 
  at recursive SQL level 1ORA-04031: unable to allocate 4032 bytes of shared 
  memory ("shared 
  poolquot;, 
  "unknown object","joxs heap init","ioc_allocate_pal")ORA-06512: at 
  "SYS.DBMS_CDC_PUBLISH", line 0ORA-06512: at line 4
  
  Afterwards, since the 
  database is open, the errors also occur when creating ordropping database 
  objects (tables, external tables, ...), neverthenless withslightly 
  different parameters in the ORA-4031 error message, like:
  
  ORA-04031: unable to 
  allocate 4032 bytes of shared memory ("shared 
  poolquot;, 
  "unknown object","joxs heap init","ioc_allocate_pal")
  
  or
  
  ORA-04031: unable to 
  allocate 4032 bytes of shared memory ("shared 
  poolquot;, 
  "sun/misc/URLClassPathSYS","joxlod: in 
  ehe",quot;ioc_allocate_pal")
  
  or
  
  ORA-04031: unable to 
  allocate 4032 bytes of shared memory ("shared 
  poolquot; 
  "oracle/CDC/ChangeTableSYS","joxlod: in 
  ehe",quot;ioc_allocate_pal")
  
  The size of the shared 
  pool doesn't influence the result. This means thatincreasing the 
  shared_pool_size will not solve the problem.
  
  The problem is fixed, 
  setting the java_pool_size greater then 4M. In fact avalue of 4194305 (4M 
  + 1 byte) would be sufficient, since the java_pool_size isadjusted to a 
  multiple of 4M. In this case the java_pool_size would be 8M.
  
  It seems that there is a 
  threshold of java_pool_size of 5M based on v$sgastat.
  
  Remark:--
  
  Bug:2084844 is 
  initially fixed in version 9.2.
  
  . 
  
  
  
  -Mensaje 
  original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En 
  nombre de Arul kumarEnviado el: Jueves, 14 de Febrero de 2002 
  03:08 a.m.Para: Multiple recipients of list 
  ORACLE-LAsunto: 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 allocated.? 
  Moreover, this space allocation seems to be affecting the PGA size!! 
  Any suggestions to make it NULL or zero. ?? 
  Thank you. 
  regards, Arul. 
  *DisclaimerThis 
  message (including any attachments) contains confidential information 
  intended for a specific individual and purpose, and is protected by law. 
  If you are not the intended recipient, you should delete this message 
  and are hereby notified that any disclosure, copying, or distribution of 
  thismessage, or the taking of any action based on it, is strictly 
  prohibited.*Visit 
  us at http://www.mahindrabt.com

  -Mensaje original-De: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]En nombre de Arul kumarEnviado el: 
  Jueves, 14 de Febrero de 2002 03:08 a.m.Para: Multiple recipients 
  of list ORACLE-LAsunto: 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 allocated.? 
  Moreover, this space allocation seems to be affecting the PGA size!! 
  Any suggestions to make it NULL or zero. ?? 
  Thank you. 
  regards, Arul. 
  *DisclaimerThis 
  message (including any attachments) contains confidential information 
  intended for a specific individual and purpose, and is protected by law. 
  If you are not the intended recipient, you should delete this message 
  and are hereby notified that any disclosure, copying, or distribution of 
  thismessage, or the taking of any action based on it, is strictly 
  prohibited.*Visit 
  us at http://www.mahindrabt.com

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

2002-02-14 Thread Stefan Jakobsson


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;

Well, the application (written in FoxPro) that tries to use the statement
goes
gaga on it and doesn't recieve a value from the statement apart from the
fact
that the SQL-statement succeded..

This is giving me grey(er) hair! :)

Oh well, thanks for the suggestions guys... I think I have to rethink the
entire thing :)

/Stefan

 -Ursprungligt meddelande-
 Från: Mercadante, Thomas F 
 [mailto:[EMAIL PROTECTED]]
 Skickat: den 13 februari 2002 15:58
 Till: Multiple recipients of list ORACLE-L
 Ämne: RE: Ok... this is driving me nuts!
 
 
 Stefan,
 
 You cannot execute functions in that manner.
 
 You can however, do :
 
 select RAKNAUPP.FAKTURANUMMER from dual;
 
 The problem is that the function is trying to return a value 
 to you.  When
 you try and CALL it, there is no place for the value to return to.
 
 Hope this helps
 
 Tom Mercadante
 Oracle Certified Professional
 
 
 -Original Message-
 Sent: Wednesday, February 13, 2002 9:23 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 I have the following package defined
 
 PACKAGE RAKNAUPP AS
 FUNCTION FAKTURANUMMER RETURN NUMBER;
 FUNCTION MEDLEMSNUMMER RETURN NUMBER;
 FUNCTION OCRNUMMER RETURN NUMBER;
 FUNCTION INBETNUMMER RETURN NUMBER;
 END RAKNAUPP;
 
 PACKAGE BODY RAKNAUPP AS
 FUNCTION FAKTURANUMMER
 RETURN NUMBER
 IS NFAKNR NUMBER(8);
 BEGIN
   SELECT medlfaktnr+1 INTO NFAKNR FROM parametrar FOR UPDATE;
   UPDATE parametrar SET medlfaktnr = medlfaktnr+1;
   COMMIT;
   RETURN (NFAKNR);
 END FAKTURANUMMER;
 FUNCTION OCRNUMMER
 RETURN NUMBER
 IS NOCRNR NUMBER(6);
 BEGIN
   SELECT ocrnr+1 INTO NOCRNR FROM parametrar FOR UPDATE;
   UPDATE parametrar SET ocrnr = ocrnr+1;
   COMMIT;
   RETURN (NOCRNR);
 END OCRNUMMER;
 FUNCTION MEDLEMSNUMMER
 RETURN NUMBER
 IS NMEDNR NUMBER(6);
 BEGIN
   SELECT medlnr+1 INTO NMEDNR FROM parametrar FOR UPDATE;
   UPDATE parametrar SET medlnr = medlnr+1;
   COMMIT;
   RETURN (NMEDNR);
 END MEDLEMSNUMMER;
 FUNCTION INBETNUMMER
 RETURN NUMBER
 IS NINBNR NUMBER(6);
 BEGIN
   SELECT inbetnr+1 INTO NINBNR FROM parametrar FOR UPDATE;
   UPDATE parametrar SET inbetnr = inbetnr+1;
   COMMIT;
   RETURN (NINBNR);
 END INBETNUMMER;
 END RAKNAUPP;
 
 It works fine, except when I try to run it with call:
 
 call RAKNAUPP.FAKTURANUMMER;
 
 Then I get:
 
 ORA-06576: not a valid function or procedure name
 call ERROR'raknaupp.fakturanummer'
 
 And I'm about at my wits end here... I can't for my life 
 figure out why this
 isn't working as it is suposed to!
 
 Could someone please figure out what I am doing wrong?
 
 Stefan Jakobsson
 [EMAIL PROTECTED]
 Telefon: 08-470 24 00
 Telefax: 08-470 24 24
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Stefan Jakobsson
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Mercadante, Thomas F
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stefan Jakobsson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like

RE: Unidata DB

2002-02-14 Thread Johnston, Tim




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
  Has anyone heard of Unidata DB. It's relational and 
  from IBM. 
  
  Thanks,
  Ken Janusz, CPIM

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 ('/admin04/cc1test/redo01.log' size 1m reuse,
   *
ERROR at line 3:
ORA-00907: missing right parenthesis


SQL 

-Original Message-
Sent: Thursday, February 14, 2002 8:21 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells


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 Professional


-Original Message-
Sent: Thursday, February 14, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L



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 database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

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

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas


begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
M;G0N#0I4:4@:6YF;W)M871I;VX@8V]N=%I;F5D(EN('1H:7,@92UM86EL
M(ES('-TFEC=QY(-O;F9I95N=EA;!A;F0@9F]R('1H92!I;G1E;F1E
M9!UV4@;V8@=AE(%D9')EW-E92!O;FQY.R!I=!M87D@86QS;R!B92!L
M96=A;QY('!R:79I;5G960@86YD+V]R('!R:6-E('-E;G-I=EV92X@($YO
M=EC92!IR!H97)E8GD@9VEV96X@=AA=!A;GD@9ES8VQOW5R92P@=7-E
M(]R(-O'EI;F@;V8@=AE(EN9F]R;6%T:6]N()Y(%N6]N92!O=AE
MB!T:%N('1H92!I;G1E;F1E9!R96-IEE;G0@:7,@')O:EB:71E9!A
M;F0@;6%Y()E(EL;5G86PN(!)9B!Y;W4@:%V92!R96-E:79E9!T:ES
M(UEW-A9V4@:6X@97)R;W(L('!L96%S92!N;W1I9GD@=AE('-E;F1EB!I
M;6UE9EA=5L2!B2!R971UFX@92UM86EL+@H*0V]R]R871E(%-YW1E
M;7,L($EN8RX@:%S('1A:V5N(5V97)Y(')E87-O;F%B;4@')E8V%U=EO
M;B!T;R!E;G-UF4@=AA=!A;GD@871T86-H;65N=!T;R!T:ES(4M;6%I
M;!H87,@8F5E;B!S=V5P=!F;W(@=FER=7-ERX@(%=E(%C8V5P=!N;R!L
M:6%B:6QI='D@9F]R(%N2!D86UA9V4@W5S=%I;F5D(%S($@F5S=6QT
M(]F('-O9G1W87)E('9IG5S97,@86YD(%D=FES92!Y;W4@8V%RGD@;W5T
M('EO=7(@;W=N('9IG5S(-H96-KR!B969OF4@;W!E;FEN9R!A;GD@871T
,86-H;65N=X-@T*
end


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

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...

 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 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-
 Sent: 14 February 2002 13:23
 To: Multiple recipients of list ORACLE-L



 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 database testcc1
 *
 ERROR at line 1:
 ORA-01501: CREATE DATABASE failed
 ORA-02084: database name is missing a component

 THIS is my script...

 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

 WHAT is wrong with it.  I am really not this inept... really... but I
can't
 see what is wrong with the database name.

 Thanks in advance for there not being GAILS of laughter... but tiredness
is
 getting to me.

 April Wells
 Corporate Systems
 Amarillo Texas




___
 This email is confidential and intended solely for the use of the
 individual to whom it is addressed. Any views or opinions presented are
 solely those of the author and do not necessarily represent those of
 SchlumbergerSema.
 If you are not the intended recipient, be advised that you have received
 this
 email in error and that any use, dissemination, forwarding, printing, or
 copying of this email is strictly prohibited.

 If you have received this email in error please notify the
SchlumbergerSema
 Helpdesk by telephone on +44 (0) 121 627 5600.

___











 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: April Wells
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: April Wells
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle and Apache Web server bottleneck

2002-02-14 Thread Vergara, Michael (TEM)


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 
stuff from the RAID 5 area to the RAID 0 area that it could 
not service the I/O requests from the database.  We went to 
a fiber array and most of the problems disappeared.

If you are using an AutoRAID, check your internal statistics
to see if you're swapping like mad in there.

HTH,
Mike

-Original Message-
Sent: Wednesday, February 13, 2002 6:38 PM
To: Multiple recipients of list ORACLE-L


We have a single HP 9000 with 2-360Mhz CPU, 4G ram and a 12 x 36G disk
array.

We were running Oracle Apps 11.0.3 on Oracle 8.0.5, but recently upgraded 
to Oracle 8.1.7.2 so that we could provide web access to purchasing 
(iProcurement) and later to HR (employee self service).

Oh, but do we have a problem.

In testing, with a single instance, we found that the Apache web server was 
able to service 1-10 users very well, 10 - 14 was poor with 1-3 minute 
response time, and above 16, the web browser sessions timed out after 10 
minutes.  The CPUs peg at 100% around the 12 user and stay there.  With 150 
Purchashing users, we have delayed go-live until we get this Apache 
bottleneck solved.

The boss is talking to HP about getting a second server.  Server A will 
have the DB and server B will have apps, Oracle web server and Apache web 
servers.

I'm a thinking that we need to get that Apache web server onto a different 
box of some kind.

Any ideas on dealing with the Apache server problem?


Thx.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Unidata DB

2002-02-14 Thread Rick_Cale



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

Rick


   

KENNETH   

JANUSZ  To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
kjanusz@att.cc:   

net Subject: Unidata DB   

Sent by:   

root@fatcity.  

com

   

   

02/14/2002 

08:43 AM   

Please 

respond to 

ORACLE-L   

   

   





Has anyone heard of Unidata DB.  It's relational and from IBM.

Thanks,
Ken Janusz, CPIM



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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 rc_backup_piece.handle.

 HTH,
 Ruth
 - Original Message -
 From: Sona [EMAIL PROTECTED]
 To: Ruth Gramolini [EMAIL PROTECTED]
 Sent: Wednesday, February 13, 2002 6:09 PM
 Subject: Re: Limiting RMAN backups-Please help


  Thanks Ruth.
  Can you tell me how to change the backup location.for e.g if I have
taken
  backup at location /ora/backup and it is recorded the recovery catalog.
 Now
  if I want to move the backup to /ora/backup1 .
  How should i change it in the recovery catalog?
 
  TIA
 
 
  - Original Message -
  From: Ruth Gramolini [EMAIL PROTECTED]
  To: Sona [EMAIL PROTECTED]
  Sent: Wednesday, February 13, 2002 5:33 AM
  Subject: Re: Limiting RMAN backups-Please help
 
 
   Exactly!  I doesn't create extra backupsets but it creates them
faster.
   HTH, Ruth
   - Original Message -
   From: Sona [EMAIL PROTECTED]
   To: Ruth Gramolini [EMAIL PROTECTED]
   Sent: Tuesday, February 12, 2002 4:19 PM
   Subject: Re: Limiting RMAN backups-Please help
  
  
Ruth,
Thanks for replying. Does using multiple channels but just one
backup
   space
parallelize the backup operation?
   
Thanks
Sona
   
   
   
- Original Message -
From: Ruth Gramolini [EMAIL PROTECTED]
To: Sona [EMAIL PROTECTED]
Sent: Thursday, February 07, 2002 11:32 AM
Subject: Re: Limiting RMAN backups-Please help
   
   
 I only have one backup space and use two channels.  It creates
files
  of
only
 2 gig on backup space.  Rman takes care of all the underlying
stuff.

 Ruth
 - Original Message -
 From: Sona [EMAIL PROTECTED]
 To: Ruth Gramolini [EMAIL PROTECTED]
 Sent: Thursday, February 07, 2002 2:19 PM
 Subject: Re: Limiting RMAN backups-Please help


  Ruth,
  Thanks fro your reply.
 
  This code will limit the size of each backup set to 2GB.Is there
 any
   way
 we
  can limit the backup size in each of the volumes depending on
how
  much
 space
  is available in those volumes.
 
  For e.g if i want to limit
  /disk1 to 40GB
  /disk2 to 10GB
  /disk3 to 10GB
  /disk4 to 10Gb
  I guess what i'm trying to do is the total size of the backup
 serts
going
 to
  a particaluar location for e.g. /disk1 should be limited to
40GB.
 
  Can we do this?
 
  Also how do I paralleilize backups if I have only 1 backup
   destination.
  For e.g if i have 2 channels with the same destination /disk1
then
   will
 the
  2 channels work in parallel or the paralllization happens only
if
  the
  destination is different.
 
  allocate channel c1 type disk format /disk1
  allocate channel c2 type disk format /disk1
  backup
  archivelog all;
 
 
  Will the backup happen in parallel or serial and will both the
   channels
do
  the stuff?
  The reason I'm asking this is because I did the backups of my
archivelogs
  yesterday (about 15 GB) and it took about 50 --55 mins for the
   backup.I
 used
  only one channel.
  How do I parallelize this operation?
 
  Appreciate your help.
 
  Sona
 
  - Original Message -
  From: Ruth Gramolini [EMAIL PROTECTED]
  To: Sona [EMAIL PROTECTED]
  Sent: Thursday, February 07, 2002 6:45 AM
  Subject: Re: Limiting RMAN backups-Please help
 
 
   Here is the code I use to set the limit for each backup set to
2
   gig.
 It
  is
   a limit on the channel(s). These code creates two channels for
   backups
 of
   our production database.
  
   replace script alloc_pa1_disk {
   #
   #  Modified  By   Reason
   #  981002rg   created
   #
 allocate channel diskprdar201 type disk;
 setlimit channel diskprdar201 kbytes 2097150 maxopenfiles 4;
 allocate channel diskprdar202 type disk;
 setlimit channel diskprdar202 kbytes 2097150 maxopenfiles 4;
   }
  
   HTH,
   Ruth
  
  
  
   - Original Message -
   From: Sona [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Wednesday, February 06, 2002 7:45 PM
   Subject: Limiting RMAN backups-Please help
  
  
Hi Ruth
I am doing RMAN incremental level 0 backup .The database
size
 is
about
   150GB
out of which used would be about 100GB.I don't have a single
   volume
 with
100GB of space.So I need to distribute the backup across
 several
 disks.
   
Also I need to limit the backup size in each of the volumes
depending
 on
   how
much

INFORMIX 7.3 to ORACLE 8.1.7 (New info)

2002-02-14 Thread Sonja ehovi


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 extensive
testing, we discovered that our scripts are the fastest way.

HTH,
Sonja

  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OT:looking for job

2002-02-14 Thread Tirumala, Surendra


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
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tirumala, Surendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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,   
 my problem is as follows:
 I want do determine the machine name (and other info) from pl/sql,of the
 client from which i have logged in
 e.g. suppose i have logged from  machine 'power_machine' as  user 'puser'
 my pl/sql has info. that  the current user 'puser'

 How do i retrive my sid for this session,
 which is in V_$SESSION.

 so basically i want the SID of the current session
 Thx
 Sameer

 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Ghadge,Sameer
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists

 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Extent grab ...

2002-02-14 Thread Anjan Thakuria


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
version:2.1
email;internet:[EMAIL PROTECTED]
title:Infrastructure Specialist
fn:Anjan Thakuria
end:vcard

ORA-600 [1158] on 8.1.7

2002-02-14 Thread Martin Vasas


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 
patch  levels.  This is something we are reluctant to do without specific patch
information addressing
our problem.  

Has anyone seen this error on 8.1.7 before?

Regards,

Martin
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Martin Vasas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SOLVED: URGENT: need help by point in time recovery

2002-02-14 Thread v . schoen


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. Everything works fine.

Thanks to all who replied

Regards

Volker Schoen
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de



-Ursprüngliche Nachricht-
Von: Ray Stell [mailto:[EMAIL PROTECTED]] 
Gesendet: Donnerstag, 14. Februar 2002 14:14
An: Multiple recipients of list ORACLE-L
Betreff: Re: URGENT: need help by point in time recovery



This reminds me of something I always wanted to try to work out.  It seems
like you should be able to rebuild part of a 
db, so that the recovery of a certain tables data would be faster.  That way
you don't spend the time reading all the datafiles for all the TS you don't
need to recover.  

Could you just edit the trace control file to change the structure of the
db, so that the only user TS is the one of interest?



On Wed, Feb 13, 2002 at 12:32:09PM -0800, [EMAIL PROTECTED] wrote:
 Hi list,
 
 I have a urgent problem. One of our developers has deleted all rows of 
 a table on production database (database of a customer from us). We 
 have a nightly cold backup and database is running in archivelog mode. 
 On same server we have a test instance which has same structure as 
 prod instance, only the folders are others. What I like to do is:
 
 1. go to production and backup controlfile to trace
 2. copy the cold backup (production) from last night into this test 
 instance folders (datafiles, controlfiles...) 3. copy archive logs of 
 production to archive log folders from test 4. startup testinstance 
 nomaount 5. create new controlfile with backuped controlfile from 
 trace 6. recover database until '-dd-mm hh:
 7. export deleted table and import it in production database
 
 My question is, if I make a clone of a database from a nightly cold 
 backup, can I recover the database with newer archivelogs. Or is there 
 any other method to get my data back (I don't have a actual export of 
 database)?
 
 TIA
 
 
 Volker Schoen
 E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 http://www.inplan.de http://www.inplan.de 
 
 

-- 
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: LMT to DMT

2002-02-14 Thread Joan Hsieh


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 [SMTP:[EMAIL PROTECTED]]
  Sent: Wed, February 13, 2002 10:32 PM
  To:   Multiple recipients of list ORACLE-L
  Subject:  LMT to DMT
 
  Hi listers,
 
  How to convert the locally management tablespace back to dictionary
  management tablespace? I used dbms_space_admin migrated all the
  tablespaces to LMT. Now I want convert back on some tablespaces, I
  remember I read the notes indicate step to step how to do this. Just
  can't find it anymore. Could you please give me some light on this?
 
  Another question I posted yesterday, but no replied so far. I post here
  again.  Thanks,
 
  JOan
 
 
  I am looking for a solution to zip all the backup files into one
   backupset.zip file on NT. I have trouble to find the dos command
  line to
   do this.(pkzip or winzip command line? should executed in a batch
  file
   after backup) Can you share this info with us? This should be a
  very
  easy thing to do. NT comand compact /C is not what I want. Thanks,
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Joan Hsieh
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
  -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
   This e-mail was scanned by the eSafe Mail Gateway
  -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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 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 database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

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

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas


begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
M;G0N#0I4:4@:6YF;W)M871I;VX@8V]N=%I;F5D(EN('1H:7,@92UM86EL
M(ES('-TFEC=QY(-O;F9I95N=EA;!A;F0@9F]R('1H92!I;G1E;F1E
M9!UV4@;V8@=AE(%D9')EW-E92!O;FQY.R!I=!M87D@86QS;R!B92!L
M96=A;QY('!R:79I;5G960@86YD+V]R('!R:6-E('-E;G-I=EV92X@($YO
M=EC92!IR!H97)E8GD@9VEV96X@=AA=!A;GD@9ES8VQOW5R92P@=7-E
M(]R(-O'EI;F@;V8@=AE(EN9F]R;6%T:6]N()Y(%N6]N92!O=AE
MB!T:%N('1H92!I;G1E;F1E9!R96-IEE;G0@:7,@')O:EB:71E9!A
M;F0@;6%Y()E(EL;5G86PN(!)9B!Y;W4@:%V92!R96-E:79E9!T:ES
M(UEW-A9V4@:6X@97)R;W(L('!L96%S92!N;W1I9GD@=AE('-E;F1EB!I
M;6UE9EA=5L2!B2!R971UFX@92UM86EL+@H*0V]R]R871E(%-YW1E
M;7,L($EN8RX@:%S('1A:V5N(5V97)Y(')E87-O;F%B;4@')E8V%U=EO
M;B!T;R!E;G-UF4@=AA=!A;GD@871T86-H;65N=!T;R!T:ES(4M;6%I
M;!H87,@8F5E;B!S=V5P=!F;W(@=FER=7-ERX@(%=E(%C8V5P=!N;R!L
M:6%B:6QI='D@9F]R(%N2!D86UA9V4@W5S=%I;F5D(%S($@F5S=6QT
M(]F('-O9G1W87)E('9IG5S97,@86YD(%D=FES92!Y;W4@8V%RGD@;W5T
M('EO=7(@;W=N('9IG5S(-H96-KR!B969OF4@;W!E;FEN9R!A;GD@871T
,86-H;65N=X-@T*
end


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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 = PROCEDURE
:OWNERE = SYS
14/02/2002 6:06:11 PM

select /*+ CHOOSE */ TEXT from ALL_SOURCE where OWNER= :lOWNER and
NAME=:NAME and type = :BTYPE order by LINE

:BTYPE = PROCEDURE
:LOWNER = SYS
:NAME = PSTUB
14/02/2002 6:06:11 PM

select PRIVILEGE, GRANTEE, GRANTABLE, GRANTOR  
 from all_tab_privs
 where table_name = :tname
 and table_schema=:lowner
 order by grantee

:LOWNER = SYS
:TNAME = PSTUB
14/02/2002 6:06:14 PM

Select  /*+ CHOOSE */ Line, Position, substr(text,1,200) text From
All_Errors where owner=:owner  and name=:ObjName and type=:objType order by
sequence

:OWNER = SYS
:OBJNAME = PSTUB
:OBJTYPE = PROCEDURE
14/02/2002 6:06:15 PM

Select /*+ CHOOSE */ distinct 
  owner uses_owner,
  name object_used, 
  type 
from ALL_DEPENDENCIES
where 
 referenced_owner=:owner and 
 referenced_name=:name and 
 ( referenced_type'NON-EXISTENT') and 
 ( referenced_type=:type 
 ) 

:NAME = PSTUB
:TYPE = PROCEDURE
:OWNER = SYS
14/02/2002 6:06:17 PM

Select /*+ CHOOSE */ distinct 
  referenced_owner uses_owner,
  referenced_name object_used, 
  referenced_type 
from ALL_DEPENDENCIES
where 
 owner=:owner and 
 name=:name and 
 ( type=:type 
 ) 

:NAME = PSTUB
:TYPE = PROCEDURE
:OWNER = SYS
14/02/2002 6:06:19 PM

select /*+ CHOOSE */ argument_name Argument, data_type,  in_out,
data_length, data_precision, default_value 
 from all_arguments where (owner=:lowner) and 
 (data_level=0) and 
 (object_name=:objName) 
 and (package_name is null) 
and object_id = ( 
 select object_id from 
 all_objects where (owner=:lowner) and 
 object_name =:objName
 andobject_type in ('PACKAGE', 'PROCEDURE', 'FUNCTION'))
 order by position

:LOWNER = SYS
:OBJNAME = PSTUB
14/02/2002 6:06:34 PM

select /*+ CHOOSE */ TEXT from ALL_SOURCE where OWNER= :lOWNER and
NAME=:NAME and type = :BTYPE order by LINE

:BTYPE = PROCEDURE
:LOWNER = SYS
:NAME = ODCISTATSOPTIONSDUMP


Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Abdul Aleem [SMTP:[EMAIL PROTECTED]]
 Sent: Thu, February 14, 2002 9:13 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  View for Procedure/Function SQL Code
 
 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 ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Abdul Aleem
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Create Database ... really dumb question

2002-02-14 Thread Robertson Lee - lerobe


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
'/oracle01/oradata/BRIT/system001.dbf'  size 100M
logfile
'/oracle03/oradata/BRIT/redoBRIT01.log' size 25M,
'/oracle03/oradata/BRIT/redoBRIT02.log' size 25M,
'/oracle03/oradata/BRIT/redoBRIT03.log' size 25M;

HTH

Lee


-Original Message-
Sent: 14 February 2002 16:23
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


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,
'/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 ('/admin04/cc1test/redo01.log' size 1m reuse,
   *
ERROR at line 3:
ORA-00907: missing right parenthesis


SQL 

-Original Message-
Sent: Thursday, February 14, 2002 8:21 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells


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 Professional


-Original Message-
Sent: Thursday, February 14, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L



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 database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

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

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas




The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
M;G0N#0I4:4@:6YF;W)M871I;VX@8V]N=%I;F5D(EN('1H:7,@92UM86EL
M(ES('-TFEC=QY(-O;F9I95N=EA;!A;F0@9F]R('1H92!I;G1E;F1E
M9!UV4@;V8@=AE(%D9')EW-E92!O;FQY.R!I=!M87D@86QS;R!B92!L
M96=A;QY('!R:79I;5G960@86YD+V]R('!R:6-E('-E;G-I=EV92X@($YO
M=EC92!IR!H97)E8GD@9VEV96X@=AA=!A;GD@9ES8VQOW5R92P@=7-E
M(]R(-O'EI;F@;V8@=AE(EN9F]R;6%T:6]N()Y(%N6]N92!O=AE
MB!T:%N('1H92!I;G1E;F1E9!R96-IEE;G0@:7,@')O:EB:71E9!A
M;F0@;6%Y()E(EL;5G86PN(!)9B!Y;W4@:%V92!R96-E:79E9!T:ES
M(UEW-A9V4@:6X@97)R;W(L('!L96%S92!N;W1I9GD@=AE('-E;F1EB!I
M;6UE9EA=5L2!B2!R971UFX@92UM86EL+@H*0V]R]R871E(%-YW1E
M;7,L($EN8RX@:%S('1A:V5N(5V97)Y(')E87-O;F%B;4@')E8V%U=EO
M;B!T;R!E;G-UF4@=AA=!A;GD@871T86-H;65N=!T;R!T:ES(4M;6%I
M;!H87,@8F5E;B!S=V5P=!F;W(@=FER=7-ERX@(%=E(%C8V5P=!N;R!L
M:6%B:6QI='D@9F]R(%N2!D86UA9V4@W5S=%I;F5D(%S($@F5S=6QT

RE: Create Database ... really dumb question

2002-02-14 Thread Robertson Lee - lerobe


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,
'/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 ('/admin04/cc1test/redo01.log' size 1m reuse,
   *
ERROR at line 3:
ORA-00907: missing right parenthesis


SQL 

-Original Message-
Sent: Thursday, February 14, 2002 8:21 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells


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 Professional


-Original Message-
Sent: Thursday, February 14, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L



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 database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

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

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas




The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
M;G0N#0I4:4@:6YF;W)M871I;VX@8V]N=%I;F5D(EN('1H:7,@92UM86EL
M(ES('-TFEC=QY(-O;F9I95N=EA;!A;F0@9F]R('1H92!I;G1E;F1E
M9!UV4@;V8@=AE(%D9')EW-E92!O;FQY.R!I=!M87D@86QS;R!B92!L
M96=A;QY('!R:79I;5G960@86YD+V]R('!R:6-E('-E;G-I=EV92X@($YO
M=EC92!IR!H97)E8GD@9VEV96X@=AA=!A;GD@9ES8VQOW5R92P@=7-E
M(]R(-O'EI;F@;V8@=AE(EN9F]R;6%T:6]N()Y(%N6]N92!O=AE
MB!T:%N('1H92!I;G1E;F1E9!R96-IEE;G0@:7,@')O:EB:71E9!A
M;F0@;6%Y()E(EL;5G86PN(!)9B!Y;W4@:%V92!R96-E:79E9!T:ES
M(UEW-A9V4@:6X@97)R;W(L('!L96%S92!N;W1I9GD@=AE('-E;F1EB!I
M;6UE9EA=5L2!B2!R971UFX@92UM86EL+@H*0V]R]R871E(%-YW1E
M;7,L($EN8RX@:%S('1A:V5N(5V97)Y(')E87-O;F%B;4@')E8V%U=EO
M;B!T;R!E;G-UF4@=AA=!A;GD@871T86-H;65N=!T;R!T:ES(4M;6%I
M;!H87,@8F5E;B!S=V5P=!F;W(@=FER=7-ERX@(%=E(%C8V5P=!N;R!L
M:6%B:6QI='D@9F]R(%N2!D86UA9V4@W5S=%I;F5D(%S($@F5S=6QT
M(]F('-O9G1W87)E('9IG5S97,@86YD(%D=FES92!Y;W4@8V%RGD@;W5T
M('EO=7(@;W=N('9IG5S(-H96-KR!B969OF4@;W!E;FEN9R!A;GD@871T
,86-H;65N=X-@T*
end


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name

RE: Create Database ... really dumb question

2002-02-14 Thread Kevin Bass


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 ORACLE-L



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 database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

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

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas

begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
%;G0N#0H 
end

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Bass
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Create Database ... really dumb question

2002-02-14 Thread Blake Wilson


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 until I had created the rollback segments and all was
fine.

Blake

April Wells wrote:
 
 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 database testcc1
 *
 ERROR at line 1:
 ORA-01501: CREATE DATABASE failed
 ORA-02084: database name is missing a component
 
 THIS is my script...
 
 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
 
 WHAT is wrong with it.  I am really not this inept... really... but I can't
 see what is wrong with the database name.
 
 Thanks in advance for there not being GAILS of laughter... but tiredness is
 getting to me.
 
 April Wells
 Corporate Systems
 Amarillo Texas
 
 begin 666 InterScan_Disclaimer.txt
 M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
 M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
 M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
 M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
 M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
 M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
 M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
 M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
 M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
 M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
 M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
 M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
 M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
 M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
 M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
 M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
 %;G0N#0H
 end
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: April Wells
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

begin:vcard 
n:Wilson;Blake
tel;fax:(519) 661-3486
tel;work:(519) 661-2111 ext 85549
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Blake Wilson
end:vcard

MsAccess calling PL/SQL

2002-02-14 Thread Roland . Skoldblom


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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Unidata DB

2002-02-14 Thread Glenn Stauffer


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, and a variety of others. Pick Systems has now bought back nearly 
all of its licencees and through various machinations is now a company called 
Raining Data.

The Microdata developers split up as well, leading to Revelation, Open
Insight, Prime Information, UniVerse, Unidata, ... IBM has now swallowed
up the last-named three as part of its takeover of Informix.

End Quote

You can take a look at the IBM website for more information on the Unidata 
database - the IBM U2 product family:

IBM UniData® is an extended relational database designed for embedding in 
vertical applications. This nested relational data model allows for rapid, 
intuitive data modeling and fewer resulting tables. UniData simplifies data 
management and query logic, providing more power for on-line, 
high-transaction applications.

--Glenn

On Thursday 14 February 2002 10:13 am, you wrote:
 Um...  Are you sure it's not Universal DB?  AFAIK, that's really just
 DB2... More a marketing thing...

 Tim

 -Original Message-
 Sent: Thursday, February 14, 2002 8:44 AM
 To: Multiple recipients of list ORACLE-L


 Has anyone heard of Unidata DB.  It's relational and from IBM.

 Thanks,
 Ken Janusz, CPIM
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Glenn Stauffer
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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]; April Wells



April,

Your script sure looks good, you already know that.  The only thing I can
suggest is to specify
character set.  Just guessing

Rick

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
character set charset;




 

April Wells

awells@csedgTo: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]   
e.com   cc:

Sent by: Subject: Create Database ...
really dumb question 
root@fatcity.

com

 

 

02/14/2002

08:23 AM

Please

respond to

ORACLE-L

 

 






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 database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

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

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas

(See attached file: InterScan_Disclaimer.txt)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
%;G0N#0H 
end

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: whitespaces

2002-02-14 Thread Jon Baker

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






-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L
Subject: 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: 
 INET: [EMAIL PROTECTED]


Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

RE: Unidata DB

2002-02-14 Thread Janke, Mark




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 Ardent, which then merged with Informix. Then 
Informix split itself in two, with the various Informix databases, including 
UniData, being bought by IBM while Data Stage and other data warehouse stuff 
remained with Informix, which was renamed Ascential 
Software.

Here's a link. 
UniData and UniVerse together are referred to as U2 by IBM.

http://www-3.ibm.com/software/data/u2/

Mark 
Janke
American Trans 
Air

-Original Message-From: KENNETH JANUSZ 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, February 14, 2002 8:44 
AMTo: Multiple recipients of list ORACLE-LSubject: Unidata 
DB
Has anyone heard of Unidata DB. It's relational and from 
IBM. 

Thanks,
Ken Janusz, CPIM

RE: whitespaces

2002-02-14 Thread Kevin Lange


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 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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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, February 14, 2002 10:29 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells


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
'/oracle01/oradata/BRIT/system001.dbf'  size 100M
logfile
'/oracle03/oradata/BRIT/redoBRIT01.log' size 25M,
'/oracle03/oradata/BRIT/redoBRIT02.log' size 25M,
'/oracle03/oradata/BRIT/redoBRIT03.log' size 25M;

HTH

Lee


-Original Message-
Sent: 14 February 2002 16:23
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


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,
'/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 ('/admin04/cc1test/redo01.log' size 1m reuse,
   *
ERROR at line 3:
ORA-00907: missing right parenthesis


SQL 

-Original Message-
Sent: Thursday, February 14, 2002 8:21 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells


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 Professional


-Original Message-
Sent: Thursday, February 14, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L



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 database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

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

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas




The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.

begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
M;G0N#0I4:4@:6YF;W)M871I;VX@8V]N=%I;F5D(EN('1H:7,@92UM86EL
M(ES('-TFEC=QY(-O;F9I95N=EA;!A;F0@9F]R('1H92!I;G1E;F1E
M9!UV4@;V8@=AE(%D9')EW-E92!O;FQY.R!I=!M87D@86QS;R!B92!L
M96=A;QY('!R:79I;5G960@86YD+V]R('!R:6-E('-E;G-I=EV92X@($YO
M=EC92!IR!H97)E8GD@9VEV96X@=AA=!A;GD@9ES8VQOW5R92P@=7-E
M(]R(-O'EI;F@;V8@=AE(EN9F]R;6%T:6]N()Y(%N6]N92!O=AE
MB!T:%N('1H92!I;G1E;F1E9!R96-IEE;G0@:7,@')O:EB:71E9!A
M;F0@;6%Y()E(EL;5G86PN(!)9B!Y;W4@:%V92!R96-E:79E9!T:ES

RE: whitespaces

2002-02-14 Thread Steven Monaghan


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 mails in the archive that address ways to do massive
updates in chunks.

HTH,
Steve
-
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
http://www.mscdirect.com
-

-Original Message-
Sent: Thursday, February 14, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L


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



This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you are not the intended recipient, please do not
read, copy, use or disclose the contents of this communication to others.
Please notify the sender that you have received this e-mail in error by
replying to the e-mail.  Please then delete the e-mail and destroy any
copies of it.  Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Monaghan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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-
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,
'/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 ('/admin04/cc1test/redo01.log' size 1m reuse,
   *
ERROR at line 3:
ORA-00907: missing right parenthesis


SQL 

-Original Message-
Sent: Thursday, February 14, 2002 8:21 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells


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 Professional


-Original Message-
Sent: Thursday, February 14, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L



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 database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

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

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas




The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.

begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
M;G0N#0I4:4@:6YF;W)M871I;VX@8V]N=%I;F5D(EN('1H:7,@92UM86EL
M(ES('-TFEC=QY(-O;F9I95N=EA;!A;F0@9F]R('1H92!I;G1E;F1E
M9!UV4@;V8@=AE(%D9')EW-E92!O;FQY.R!I=!M87D@86QS;R!B92!L
M96=A;QY('!R:79I;5G960@86YD+V]R('!R:6-E('-E;G-I=EV92X@($YO
M=EC92!IR!H97)E8GD@9VEV96X@=AA=!A;GD@9ES8VQOW5R92P@=7-E
M(]R(-O'EI;F@;V8@=AE(EN9F]R;6%T:6]N()Y(%N6]N92!O=AE
MB!T:%N('1H92!I;G1E;F1E9!R96-IEE;G0@:7,@')O:EB:71E9!A
M;F0@;6%Y()E(EL;5G86PN(!)9B!Y;W4@:%V92!R96-E:79E9!T:ES
M(UEW-A9V4@:6X@97)R;W(L('!L96%S92!N;W1I9GD@=AE('-E;F1EB!I
M;6UE9EA=5L2!B2!R971UFX@92UM86EL+@H*0V]R]R871E(%-YW1E
M;7,L($EN8RX@:%S('1A:V5N(5V97)Y(')E87-O;F%B;4@')E8V%U=EO
M;B!T;R!E;G-UF4@=AA=!A;GD@871T86-H;65N=!T;R!T:ES(4M;6%I
M;!H87,@8F5E;B!S=V5P=!F;W(@=FER=7-ERX@(%=E(%C8V5P=!N;R!L
M:6%B:6QI='D@9F]R(%N2!D86UA9V4@W5S=%I;F5D(%S($@F5S=6QT
M(]F('-O9G1W87)E('9IG5S97,@86YD(%D=FES92!Y;W4@8V%RGD@;W5T
M('EO=7(@;W=N('9IG5S(-H96-KR!B969OF4@;W!E;FEN9R!A;GD@871T
M86-H;65N=X-@T*5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES
M(4M;6%I;!IR!S=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@
M:6YT96YD960@=7-E(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%L
MV\@8F4@;5G86QL2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I
M=F4N(!.;W1I8V4@:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-U
MF4L('5S92!OB!C;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO

RE: HOW TO MAKE FAST EXPORT

2002-02-14 Thread Adams, Matthew (GEA, 088130)

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 Blazers


-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 6:20 PM
To: Multiple recipients of list ORACLE-L
Subject: HOW TO MAKE FAST EXPORT



Hi
How to make import fast except BUFFER size increase and big rollback segment 
if I am reorganising the database.
Thanks
-Seema




_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
 INET: [EMAIL PROTECTED]


Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Re: Importing SQL 7.0 tables

2002-02-14 Thread Jared . Still


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 work, 
especially
when the SQL Server database has not been managed properly.

Jared



use DBI;

my $dbh =  DBI-connect(dbi:ADO:SERVER NAME HERE,sa,SA PASSWORD 
HERE');

die could not connect to rsysweb\n unless $dbh;

my @tables = qw{
dtproperties EVENTS AdminLevel CATEGORIES CONTACTS ...
};

foreach my $table ( @tables ) {
print Table: $table\n;
my $filename = lc($table) . '.dmp';
open(FILE, $filename) || die could not create $filename - 
$!\n;
my $sql = select * from $table;
my $sth = $dbh-prepare($sql);
$sth-execute;
print FILE join('|', @{$sth-{NAME_uc}}), \n;
while ( my $ary = $sth-fetchrow_arrayref ) {
print FILE '' , join('|', @{$ary} ),\n;
}
 
close FILE;
}

$dbh-disconnect;






Ferry Situmorang [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/13/02 08:58 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Importing SQL 7.0 tables


I need to import into Oracle my SQL 7.0 tables.
How could I complete this?

Thanks,

Ferry Situmorang: 
Using Oracle 8.1.7 Designer 6i R4
PT Perkebunan Nusantara XIII (Persero)
Pontianak-Indonesia
http://www.ptpn13.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ferry Situmorang
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Call PL/SQL from MsAccess

2002-02-14 Thread Jared . Still


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: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject: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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Unidata DB

2002-02-14 Thread Johnston, Tim


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 industry
standard
interfaces such as ODBC, OLEDB, and HTTP.
UniData 6.0, targeted for 2H of 2002, will include enhancements to openness,
security, robustness and scalability. This release will provide a native
JDBC
driver as well as support for XML input and output from the database engine.
Security improvements come from the added support of Secure Socket Layer
(SSL) for the HTTP and Socket interfaces as well as encryption options for
the
U2 clients. UniData 6.0 will include real-time replication functionality as
part of
the core database features as well as SQL optimization and additional data
type
support for Microsoft tool access to UniVerse. Finally, an updated Java
applet-based
administration tool will allow administration of multiple U2 systems either
through the included client or any Java-enabled web browser.

IBM intends to continue to enhance, sell and support UniData and to fulfill
Informix's intention to deliver UniData 6.0 and beyond.

-Original Message-
Sent: Thursday, February 14, 2002 10:34 AM
To: Multiple recipients of list ORACLE-L



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

Rick


 

KENNETH

JANUSZ  To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]   
kjanusz@att.cc:

net Subject: Unidata DB

Sent by:

root@fatcity.

com

 

 

02/14/2002

08:43 AM

Please

respond to

ORACLE-L

 

 





Has anyone heard of Unidata DB.  It's relational and from IBM.

Thanks,
Ken Janusz, CPIM



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnston, Tim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Create Database ... really dumb question

2002-02-14 Thread James Manning


[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 F6E4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James Manning
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Create Database ... really dumb question

2002-02-14 Thread Babich , Sergey


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 encounters is the right parenthesis missing, and it shows you
where.
Best,
Sergey


/-Original Message-
Sent: Thursday, February 14, 2002 9:29 AM
To: Multiple recipients of list ORACLE-L

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 ('/admin04/cc1test/redo01.log' size 1m reuse,
   *
ERROR at line 3:
ORA-00907: missing right parenthesis


SQL 

-Original Message-
Sent: Thursday, February 14, 2002 8:21 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells


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 Professional


-Original Message-
Sent: Thursday, February 14, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L



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 database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

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

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas


begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
M;G0N#0I4:4@:6YF;W)M871I;VX@8V]N=%I;F5D(EN('1H:7,@92UM86EL
M(ES('-TFEC=QY(-O;F9I95N=EA;!A;F0@9F]R('1H92!I;G1E;F1E
M9!UV4@;V8@=AE(%D9')EW-E92!O;FQY.R!I=!M87D@86QS;R!B92!L
M96=A;QY('!R:79I;5G960@86YD+V]R('!R:6-E('-E;G-I=EV92X@($YO
M=EC92!IR!H97)E8GD@9VEV96X@=AA=!A;GD@9ES8VQOW5R92P@=7-E
M(]R(-O'EI;F@;V8@=AE(EN9F]R;6%T:6]N()Y(%N6]N92!O=AE
MB!T:%N('1H92!I;G1E;F1E9!R96-IEE;G0@:7,@')O:EB:71E9!A
M;F0@;6%Y()E(EL;5G86PN(!)9B!Y;W4@:%V92!R96-E:79E9!T:ES
M(UEW-A9V4@:6X@97)R;W(L('!L96%S92!N;W1I9GD@=AE('-E;F1EB!I
M;6UE9EA=5L2!B2!R971UFX@92UM86EL+@H*0V]R]R871E(%-YW1E
M;7,L($EN8RX@:%S('1A:V5N(5V97)Y(')E87-O;F%B;4@')E8V%U=EO
M;B!T;R!E;G-UF4@=AA=!A;GD@871T86-H;65N=!T;R!T:ES(4M;6%I
M;!H87,@8F5E;B!S=V5P=!F;W(@=FER=7-ERX@(%=E(%C8V5P=!N;R!L
M:6%B:6QI='D@9F]R(%N2!D86UA9V4@W5S=%I;F5D(%S($@F5S=6QT
M(]F('-O9G1W87)E('9IG5S97,@86YD(%D=FES92!Y;W4@8V%RGD@;W5T
M('EO=7(@;W=N('9IG5S(-H96-KR!B969OF4@;W!E;FEN9R!A;GD@871T
,86-H;65N=X-@T*
end


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  INET:

RE: Create Database ... really dumb question

2002-02-14 Thread Mercadante, Thomas F


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
'L:\u0002\WTWU\system\system_01.dbf'  size   100M
logfile
group 1 ('N:\u0010\WTWU\log\redo01a.log',
   'J:\u0011\WTWU\log\redo01b.log') size 10M,
group 2 ('N:\u0010\WTWU\log\redo02a.log',
   'J:\u0011\WTWU\log\redo02b.log') size 10M,
group 3 ('N:\u0010\WTWU\log\redo03a.log',
   'J:\u0011\WTWU\log\redo03b.log') size 10M;

I think you need the log file group 1 commands for multiple redo logs.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, February 14, 2002 9:29 AM
To: Multiple recipients of list ORACLE-L


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 ('/admin04/cc1test/redo01.log' size 1m reuse,
   *
ERROR at line 3:
ORA-00907: missing right parenthesis


SQL 

-Original Message-
Sent: Thursday, February 14, 2002 8:21 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells


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 Professional


-Original Message-
Sent: Thursday, February 14, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L



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 database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component

THIS is my script...

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

WHAT is wrong with it.  I am really not this inept... really... but I can't
see what is wrong with the database name.

Thanks in advance for there not being GAILS of laughter... but tiredness is
getting to me.

April Wells
Corporate Systems
Amarillo Texas


begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
M;G0N#0I4:4@:6YF;W)M871I;VX@8V]N=%I;F5D(EN('1H:7,@92UM86EL
M(ES('-TFEC=QY(-O;F9I95N=EA;!A;F0@9F]R('1H92!I;G1E;F1E
M9!UV4@;V8@=AE(%D9')EW-E92!O;FQY.R!I=!M87D@86QS;R!B92!L
M96=A;QY('!R:79I;5G960@86YD+V]R('!R:6-E('-E;G-I=EV92X@($YO
M=EC92!IR!H97)E8GD@9VEV96X@=AA=!A;GD@9ES8VQOW5R92P@=7-E
M(]R(-O'EI;F@;V8@=AE(EN9F]R;6%T:6]N()Y(%N6]N92!O=AE
MB!T:%N('1H92!I;G1E;F1E9!R96-IEE;G0@:7,@')O:EB:71E9!A
M;F0@;6%Y()E(EL;5G86PN(!)9B!Y;W4@:%V92!R96-E:79E9!T:ES
M(UEW-A9V4@:6X@97)R;W(L('!L96%S92!N;W1I9GD@=AE('-E;F1EB!I
M;6UE9EA=5L2!B2!R971UFX@92UM86EL+@H*0V]R]R871E(%-YW1E
M;7,L($EN8RX@:%S('1A:V5N(5V97)Y(')E87-O;F%B;4@')E8V%U=EO
M;B!T;R!E;G-UF4@=AA=!A;GD@871T86-H;65N=!T;R!T:ES(4M;6%I
M;!H87,@8F5E;B!S=V5P=!F;W(@=FER=7-ERX@(%=E(%C8V5P=!N;R!L
M:6%B:6QI='D@9F]R(%N2!D86UA9V4@W5S=%I;F5D(%S($@F5S=6QT
M(]F('-O9G1W87)E('9IG5S97,@86YD(%D=FES92!Y;W4@8V%RGD@;W5T
M('EO=7(@;W=N('9IG5S(-H96-KR!B969OF4@;W!E;FEN9R!A;GD@871T
,86-H;65N=X-@T*
end


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

Re: DB sizing - whitepaper

2002-02-14 Thread david . m . harris




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 support systems (mainly read only quering systems).  It appears to me 
the way they
phrased the question is that they are trying to find out your step-by-step process 
of deciding on the
required space for an application, so this may not be a direct answer such as 
referring to the tablespace syntax.
However, I agree with your logic, and Bjorn's reply because there are several 
factors and
I/O efficiency is one of them.  Just my 2 cents.

   HTH,

  David Harris
  Web Technology
  Verizon Communications






[EMAIL PROTECTED]@fatcity.com on 02/14/2002 04:58:21 AM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:


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 something?
Seniors, please advice.

Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
(BrainBench  Brainbuzz Certified Oracle 8/8i DBA  Developer)
http://www22.Brinkster.com/rpapnoi

-- Original Text --

To: internet[Multiple recipients of list ORACLE-L [EMAIL PROTECTED]]

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 this case, such configuration guides are often more misleading
than guiding.  There have been attempts at making rules like this
application is like X tpc-c transactions, but they also fail to be of
any actual value.

Also, if what you really were looking for was something to tell you the
size (in GB) of the required disk to store schema with a certain
definition, you could create some rough estimates.  However, with todays
typical disksizes, you run out of spindles much before you run out of GB.

Thanks, Bjørn.

[EMAIL PROTECTED] wrote:

Hi Gurus,
Can anybody mail me the the whitepaper/policy document on database sizing?
Thanks in advance.

Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
(BrainBench  Brainbuzz Certified Oracle 8/8i DBA  Developer)
http://www22.Brinkster.com/rpapnoi



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?ISO-8859-1?Q?Bj=F8rn?= Engsig
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Call PL/SQL from MsAccess

2002-02-14 Thread Pardee, Roy E


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 ADODB.Command
Set con = New ADODB.Connection

Set Network = CreateObject(WScript.Network)

   With con
  .ConnectionString = Provider=MSDAORA.1; _
 Password=***; _
 User ID=rpardee; _
 Data Source=devl; _
 Persist Security Info=False
  .Open
   End With

   With cmd
  Set .ActiveConnection = con
  .CommandType = adCmdStoredProc
  .CommandText = RPARDEE.LOGLOGIN
  Set prm = .CreateParameter(M_NAME _
  , adVarChar _
  , adParamInput _
  , 4000)
  .Parameters.Append prm
  Set prm = .CreateParameter(U_NAME _
  , adVarChar _
  , adParamInput _
  , 4000)
  .Parameters.Append prm
  .Parameters(M_NAME).Value = Network.ComputerName
  .Parameters(U_NAME).Value = Network.UserName
  .Execute , , adAsyncExecute
   End With

   Set Network = Nothing
   Set cmd = Nothing
   con.Close
   Set con = Nothing

End Sub
==

HTH,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Thursday, February 14, 2002 3:43 AM
To: Multiple recipients of list ORACLE-L


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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Pardee, Roy E
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Create Database ... really dumb question

2002-02-14 Thread Gogala, Mladen


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 : 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 F6E4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James Manning
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Create Database ... really dumb question

2002-02-14 Thread Lord, David - CSG


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 2002 16:33
 To: Multiple recipients of list ORACLE-L
 Subject: 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-
 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,
 '/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 ('/admin04/cc1test/redo01.log' size 1m reuse,
*
 ERROR at line 3:
 ORA-00907: missing right parenthesis


**
This message (including any attachments) is confidential and may be 
legally privileged.  If you are not the intended recipient, you should 
not disclose, copy or use any part of it - please delete all copies 
immediately and notify the Hays Group Email Helpdesk at
[EMAIL PROTECTED]
Any information, statements or opinions contained in this message
(including any attachments) are given by the author.  They are not 
given on behalf of Hays unless subsequently confirmed by an individual
other than the author who is duly authorised to represent Hays.
 
A member of the Hays plc group of companies.
Hays plc is registered in England and Wales number 2150950.
Registered Office Hays House Millmead Guildford Surrey GU2 4HJ.
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lord, David - CSG
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

2002-02-14 Thread dgoulet


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
Author: Joan Hsieh [EMAIL PROTECTED]
Date:   2/14/2002 7:48 AM

Hi Ray,

We use dbsnmp on the production server. How it will affect us? Our
system people sent us the same article to us and very concerned the
security.

Joan

Ray Stell wrote:
 
 Oracle does not seem to be listed, but you got to wonder what code
 they based their snmp stuff on.  You may want to nudge you sysadmin
 in the ribs, also.
 
 - Forwarded message from The SANS Institute [EMAIL PROTECTED] -
 
 Date: Tue, 12 Feb 2002 12:30:06 -0700 (MST)
 To: Ray Stell [EMAIL PROTECTED](SD569668)
 
 SANS FLASH ALERT: Widespread SNMP Vulnerability
 1:30 PM EST 12 February, 2002
 
 To: Ray Stell (SD569668)
 
 Note: This is preliminary data! If you have additional information,
 please send it to us at [EMAIL PROTECTED]
 
 In a few minutes wire services and other news sources will begin
 breaking a story about widespread vulnerabilities in SNMP (Simple
 Network Management Protocol).  Exploits of the vulnerability cause
 systems to fail or to be taken over.  The vulnerability can be found in
 more than a hundred manufacturers' systems and is very widespread -
 millions of routers and other systems are involved.
 
 As one of the SANS alumni, your leadership is needed in making sure that
 all systems for which you have any responsibility are protected. To do
 that, first ensure that SNMP is turned off. If you absolutely must run
 SNMP, get the patch from your hardware or software vendor. They are all
 working on patches right now. It also makes sense for you to filter
 traffic destined for SNMP ports (assuming the system doing the filtering
 is patched).
 
 To block SNMP access, block traffic to ports 161 and 162 for tcp and
 udp.  In addition, if you are using Cisco, block udp for port 1993.
 
 The problems were caused by programming errors that have been in the
 SNMP implementations for a long time, but only recently discovered.
 
 CERT/CC is taking the lead on the process of getting the vendors to get
 their patches out.  Additional information is posted at
 http://www.cert.org/advisories/CA-2002-03.html
 
 A final note.
 
 Turning off SNMP was one of the strong recommendations in the Top 20
 Internet Security Threats that the FBI's NIPC and SANS and the Federal
 CIO Council issued on October 1, 2001.  If you didn't take that action
 then, now might be a good time to correct the rest of the top 20 as well
 as the SNMP problem.  The Top 20 document is posted at
 http://www.sans.org/top20.htm
 
 - End forwarded message -
 
 --
 ===
 Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Ray Stell
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: ORA-600 [1158] on 8.1.7

2002-02-14 Thread Mohammad Rafiq


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]
Date: Thu, 14 Feb 2002 08:23:34 -0800

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
patch  levels.  This is something we are reluctant to do without specific 
patch
information addressing
our problem.

Has anyone seen this error on 8.1.7 before?

Regards,

Martin
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Martin Vasas
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




MOHAMMAD RAFIQ


_
Join the worlds largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: MsAccess calling PL/SQL

2002-02-14 Thread Seefelt, Beth



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 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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Unidata DB

2002-02-14 Thread Vergara, Michael (TEM)


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 processor be added to your 8088 or 8086
system.

I seem to recall the Stauffer name from Pick conventions of years
past.  Did you do work with Pick and it's variants?

Mike

-Original Message-
Sent: Thursday, February 14, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L


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, and a variety of others. Pick Systems has now bought back
nearly 
all of its licencees and through various machinations is now a company
called 
Raining Data.

The Microdata developers split up as well, leading to Revelation, Open
Insight, Prime Information, UniVerse, Unidata, ... IBM has now swallowed
up the last-named three as part of its takeover of Informix.

End Quote

You can take a look at the IBM website for more information on the Unidata 
database - the IBM U2 product family:

IBM UniData® is an extended relational database designed for embedding in 
vertical applications. This nested relational data model allows for rapid, 
intuitive data modeling and fewer resulting tables. UniData simplifies data 
management and query logic, providing more power for on-line, 
high-transaction applications.

--Glenn

On Thursday 14 February 2002 10:13 am, you wrote:
 Um...  Are you sure it's not Universal DB?  AFAIK, that's really just
 DB2... More a marketing thing...

 Tim

 -Original Message-
 Sent: Thursday, February 14, 2002 8:44 AM
 To: Multiple recipients of list ORACLE-L


 Has anyone heard of Unidata DB.  It's relational and from IBM.

 Thanks,
 Ken Janusz, CPIM
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Glenn Stauffer
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: LMT to DMT