from:"orantdba"




Not directly, but you may have the owner of the table create a stored procedure
that performs a truncate and then grant execute on that procedure to whoever
he wants to run this procedure. by default a stored procedure runs under
the privilege of the compiler of the procedure.

Hope this helps,
John 

[EMAIL PROTECTED] wrote:

  no--- VIVEK_SHARMA [EMAIL PROTECTED] wrote:
  
For a Particular Table Created by a One Oracle User , Is it possibletoTRUNCATE the SAME Table by ANOTHER Oracle user by Giving SomeSuitablePriviliges Other than DBA  DROP ANY TABLE Priviliges ? 

__Do You Yahoo!?Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com

Re: OEM question


Hi John,

Have you bounced the IA since this instance was created.  My 
understanding is that upon discovery the IA looks in a file called 
services.ora and/or snmp_ro.ora to see which services have been 
discovered. On NT this file is created with the IA is started by 
checking listener.ora, services to see all services are running on the 
machine.  If the database is not in this file I would recommend bouncing 
the IA and checking again.  

good luck,
John

[EMAIL PROTECTED] wrote:

I have 2 8.1.6 instances running on a NT4 (sp6) server using the same
listener.
With Enterprise manager (oem server is a different machine), I can see -
discover one of the instances but not the other. If I use toad or sqlplus I
can connect to the other instance.
Any guesses as to what I need to do to see this other instance with
enterprise manager?



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  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: ALTER ROLLBACK SEGMENT rbs SHRINK


H,  if you are shrinking below optimal doesn't that mean optimal 
isn't :-).

John

[EMAIL PROTECTED] wrote:

Yes, Mohammad is right !!

I messed up by not seeing the correct column...

Oracle will not honor the size you asked for (to shrink), if there are other
transactions using up space more than what you asked for, but it can go
below the OPTSIZE... 

Thanks, Mohammad.


- Kirti 

-Original Message-
Sent: Wednesday, January 30, 2002 10:40 AM
To: Multiple recipients of list ORACLE-L


Yes, it can be shrinked below optimal as per following details specially R03

rollback segment
Regards
Rafiq


before:
NAME EXT  MB OPTSIZE ACTIVE   WATER  SHRINKSWRAPS  WAITS

STATUS
---  --- --- --- --- ---  --

---
SYSTEM 2 0.2 0.0 0.1   00  0

ONLINE
R04   57   115.8 200 0.0   115.8   00  0

ONLINE
R01   50   101.6 200 0.0   101.6   00  0

ONLINE
R02   50   101.6 200 0.0   101.6   00  0

ONLINE
R03   99   201.1 200 0.0   201.1   00  0

ONLINE


run script:
SQL alter rollback segment r03 shrink to 100M;

After:

NAME EXT  MB OPTSIZE ACTIVE   WATER  SHRINKSWRAPS  WAITS

STATUS
---  --- --- --- --- ---  --

---
SYSTEM 2 0.2 0.0 0.1   00  0

ONLINE
R04   57   115.8 200 0.0   115.8   00  0

ONLINE
R01   50   101.6 200 0.0   101.6   00  0

ONLINE
R02   50   101.6 200 0.0   101.6   00  0

ONLINE
R03   50   101.6 200 0.0   201.1   50  0

ONLINE




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 30 Jan 2002 07:25:30 -0800

no, you can't shrink a rollback segment below the optimal value

--- Sinard Xing [EMAIL PROTECTED] wrote:
  Hi,
 
 
  Assume
   INITIAL * MINEXTENT = 2M and also = OPTIMAL
 
  Do you think
   ALTER ROLLBACK SEGMENT rbs SHRINK TO 1M;
 
  will work ?
 
 
 
  Thanks,
 
  Sinardy
  --
  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).


__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
   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 world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  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: Rename a datafile


HI Joe,

Problem is in mount mode the database knows nothing about tablespaces.  I
believe you are going to have to say something like:

alter database rename file '/u01/xyz.dbf' to '/u02/xyz.dbf';

Hope this helps,
John

[EMAIL PROTECTED] wrote:

Okay, I don't have the manuals with me and can't for the life of me
remember the correct syntax to do this...

Is it:

shutdown database
startup no noumt  (or startup mount)
alter tablesapce evisions
rename datafile '/full_path/file_name' to '/full_path/new_name';

I'm on 8.1.6 and this complains saying the database isn't open.

It can't be open to rename a datafile...

Thanks,
Joe



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  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: INFORMIX 7.3 to ORACLE 8.1.7

2002-01-29 Thread orantdba


Hi Sonja,

I would recommend you look at the oracle migration workbench product.

John

[EMAIL PROTECTED] wrote:

Hi!
We inherited one Informix database, which we must put into our production
Oracle database (new schema). Both databases are on AIX UNIX machines. 
We can do this by writing a scripts, but I'm wondering does any of you have
some experiance in this, and could you suggest me some other (simpler) way?
Perhaps some Conversion tools?

TIA,
Sonja



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  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: RTFM questions (formally RE: PL/SQL)

2002-01-29 Thread orantdba




Hi JoJo,

This is incorrect. A truncate removes all data from the table and moves
the High Water Mark to the beginning of the table. Some internal's guru
might be able to tell you that the data is still there, but you can't get
to it, so it doesn't really matter. BTW , you can't issue a rollback of
the truncate command.

John 



[EMAIL PROTECTED] wrote:

  I'm a complete newbie, so I may be off-base here, but I believe thattruncating a table does not delete any data from the table.  It moves thecursor up, thereby closing up the "empty space" where data has previouslybeen deleted.--JoJo-Original Message-Sent: Tuesday, January 29, 2002 10:46 AMTo: Multiple recipients of list ORACLE-LTo our resident Oracle Expert who just 6 months (July 26 2001) ago postedthe following e-mailIf I remember rightly, deleting rows from the table does NOT free uptablespace. In order to do that you have to trunctate the table (althoughthis of course deletes all data from the table)...I can't for the life of meremember how you adjust the space the table is actually using after doing adelete...(to everyone else) would an analyze work?Kev."would and analyze work", leave it out kev(or thomas), my sides aresplitting Im laughing tha
t much""Dude you really are a sage"I agree dude, you tell them beginners how u became such an expert in 6months and didn't come out with stupid ** comments like above, and dude,explain more about this defrag,space adjusting tool "the analyze command":Unfortunately I only got dragged into this because I just saw one of yourrude replies and I was having a bad day and didn't like your attitude., Ihave no idea about the guy you were slagging off as I don't get time to readall the posts, but it looks like 6 months ago you were no better than him,and nobody on the list, I recall, treated you with the contempt that youactually deserved.As somebody on the list said "opinions are like arseholes, everybody's gotone and they all stink" (classic ,classic quote):Anyhow I rest my case Kev (or thomas):- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Tuesday, January 29, 2002 8:12 PM
  
And your point caller??TIC ;o)-Original Message-Sent: 29 January 2002 15:41To: Multiple recipients of list ORACLE-LNo offense to anybody, but I think this is rather arrogant.  The list is

for

  anybody (unless the list owner decides it's just for experienced dba's). Iam brand new to Oracle, having just started learning it this week.  I caneasily foresee having what some might consider stupid or RTFM questions,
  
  and
  
being possibly unable to find the answer or having problems deciphering

the

  manual.  I myself am somewhat of a Word pro (and my vba code samples page
  
  is
  
the #1 ranked site of its kind on most major search engines) and I help

all

  kinds of newbies out on a Word list of which I am a member, as do all theother members of the list.  Everybody on that list is extremely gracious
  
  and
  
nobody complains -- and the people with questions get the help they need,with nobody sitting back going "boy are you stupid / lazy".  I am hopingthat I can get the same kind of help here, when I am ready for it, that Iand others give on other lists.--JoJo-Original Message-Sent: Monday, January 28, 2002 10:20 PMTo: Multiple recipients of list ORACLE-LThe problem is that if you always ask the group for help, you never learnwhere the information is within the manuals or other reference

documentation

  and the group also gets cluttered with trivia.I agree with you that the list is here to help people and I personally donot mind the odd naive question from a new DBA, but it is the "...can't bebothered to look up the manual.." attitude that is most frustrating.  Whenyou ask the format of a command (for example) to the list, you arepotentionally asking 1000's of people the same question who will all have
  
  to
  
spend the time to filter these questions - we are all busy people and Ipersonally do not want to use my time in this way.  I'm sure you can seethat this is a much more expensive option than asking the person next toyou.Cheers,Craig.-Original Message-mailto:[EMAIL PROTECTED] ]Sent: Tuesday, 29 January 2002 2:55 PMTo: Multiple recipients of list ORACLE-LWhy do you bother being on this List: The list is here to help fellowDBA'S. Have you never said to one of your collegues , what is the format

of

  this command, or how can I do that, when you simply cant be bothered tolook it up in the manual (either your busy or just down

Re: OFF TOPIC: RE: PL/SQL

2002-01-29 Thread orantdba




Hi All,

Just a funny little story, one day I was interviewing some consultants that
had been recommended by a rather large (nameless) consultancy. The administrative
assistant indicated that my next interviewee was in the waiting room. As
I approached the waiting room I looked throught the blinds and they were
reading a DBA for Dummies book. When your resume' says you are "King of
the World" and your company wants to charge "Big Bucks" to use you, sitting
in the waiting room reading that particular book does not inspire confidence.

John

[EMAIL PROTECTED] wrote:

  LoL...So many opportunities for writing books for all these dummy DBAs !!! LoL.. -Original Message-Sent: Tuesday, January 29, 2002 1:15 PMTo: Multiple recipients of list ORACLE-LKirti,Good luck!.Does 'OCP for dummies!' come in different versions? Like, '8i', '9i Pro','9i Master' (sounds good '9i Dummy OCP' or '9i Dummy OCM', isn't it?:).I'd love to get '9i' to upgrade my '8i' to '9i' (company doesn't want to payfor oracle classes/tests:)Igor Neyman, OCP DBA[EMAIL PROTECTED]- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Tuesday, January 29, 2002 12:35 PM
  
Igor, It's a good night-cap :) However, I can use a sign like that, considering what we are going

through

  lately.. Implementing a HUGE system converted to access Oracle RDBMS.Converted from old IDMS COBOL code, to Pro*COBOL programs. Each table has
  
  4
  
copy-book routines that are called from the main program (PROCEDUREDIVISION) :-) Yes, you guessed it right. I am not joking.Today, IBM is on site to fix the performance problems. Hope they find

it

  in the H/W... because they did not code the App.Most DBAs are on the side line like dummies!!!Installation of this monster will proceed to meet dead lines and, of
  
  course,
  
the budget.Next book on my list -- 'OCP for dummies!'Cheers !- Kirti-Original Message-Sent: Tuesday, January 29, 2002 10:26 AMTo: Multiple recipients of list ORACLE-LKirti,Too much time on your hands?Does the one, who gets through it's last chapter, get 'Oracle Dummy DBA'sign?Igor Neyman, OCP DBA[EMAIL PROTECTED]- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Tuesday, January 29, 2002 11:05 AM

  Has anyone read 'Oracle8i for Dummies' ??I have checked it out from our local public libraryIt's not a bad read, I am still in chapter 1, though.. learning some new
  
  
  
  

  interesting analogies to this techie stuff..- Kirti
  
  --Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Deshpande, Kirti  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).

Re: Benchmark Myopia

2002-01-28 Thread orantdba

HI Steve,

A good example of why words ambiguous words like faster are dangerous. I

have often asked clients the question which is faster a Ferrari Roadster
or a
Mack Truck. Invariably the answer would be the Ferrari, I then answer that

it depends on what you are trying to do. If you are trying to drive to work,

definitely the ferrari, if you trying to move the contents of your house
across
country you would probably want to take the Mack truck, so the answer is
"It depends" again. Until you know the intended usage, faster, doesn't
mean
alot.

My .02,
John

[EMAIL PROTECTED] wrote:

It's faster than Oracle.

Oh... You hit a hot button!!!MySQL is faster at performing 1 query in 1 database session and not muchmore. But "comparing" the performance of a database engine withoutconsidering concurrent multi-user OLTP activity is very short-sighted. Ijust finished some benchmark tests of MySQL ISAM, MySQL InnoDB, and Oracleusing Perl DBD. MySQL was fast with individual queries, inserts or updatesbut it barfed as soon as I cranked up the number of sessions. Oracle flewthrough 30 concurrent sessions with each session performing many differentqueries. I was eager to further crank up the number of sessions (via a loopin Perl) but MySQL crapped out so there was no point going any further.MySQL ISAM does table level locking and one session would put all the othersin a wait state. MySQL InnoDB does row level locking but the InnoDBdeveloper (Heikki Tuuri) conceded that it InnoDB also barfs with multi-userselect, ins
erts, updates and deletes so he's still working on it. The opensource MySQL community still has a lot of work to do to catch up to Oracle'sperformance when it comes to any real world multi-user database activity.MySQL faster than Oracle? This is a pearlescent example of benchmark myopia.IMHO,Steve OrrBozeman, Montana-Original Message-Sent: Monday, January 28, 2002 6:35 AMTo: Multiple recipients of list ORACLE-LOn Monday 28 January 2002 03:45, Marin Dimitrov wrote:

maybe u could consider some free databases?of course the performance, functionality and the ease of use won't becomparable to MS SQL but many sites use such databases quite successfully

Actually, the most popular of the free databases is mySql, which is likely faster than MS Sql. It's faster than Oracle. Jared

Re: ROLLBACK SEGMENT?

2002-01-25 Thread orantdba




Hi Raj,

Interesting that you first agree with Jeremy and then argue with him. It
is precisely because
export does not generate rollback that the "gymnastics" of taking all of
the other rbs's offline
will not help anything. It might make you feel better, however :-).

John

[EMAIL PROTECTED] wrote:

  
  

  Export doesn't generate any rollback, right, so what is it supposed toaccomplish by doing this incantation?
  
  
  
  
Sorry to press the point, but could you elaborate on how that "COULD"possibly make any difference for 'snapshot too old'?

For the same reason, any other transaction could end up with a snapshot tooold error. Export does not generate any rollback, but there could be usersperforming DML operations on the table  that is being exported, and theexport needs to be redirected to read from the rollback segments. Thelikelihood of the error being thrown up especially if one uses theconsistent parameter could be very high, if you dont have a large enoughrollback segment without an optimal clause.RajJeremiah Wilton [EMAIL PROTECTED]@fatcity.com on 01/23/2002 11:20:40AMPlease respond to [EMAIL PROTECTED]Sent by:  [EMAIL PROTECTED]To:   Multiple recipien
ts of list ORACLE-L [EMAIL PROTECTED]cc:On Tue, 22 Jan 2002, [EMAIL PROTECTED] wrote:

  H ... "COULD" help in avoiding snapshot too old errors.
  
  Sorry to press the point, but could you elaborate on how that "COULD"possibly make any difference for 'snapshot too old'?--Jeremiah Wiltonhttp://www.speakeasy.net/~jwilton
  
Jeremiah Wilton [EMAIL PROTECTED] wrote:So what does it accomplish to "assign export [to] a particularrollback segment?"Export doesn't generate any rollback, right, so what is it supposed toaccomplish by doing this incantation?On Tue, 22 Jan 2002, Jason Rowski wrote:

  ... you can use the following trick to assign export aparticular rollback segment -1) Create a rollback segment tablespace with one largesegment and bring it online before export.2) Offline all existing rollback segments.3) Export the database4) Offline the large tablespace created earlier.5) Bring back the orginals rollback segments online.--- Seema Singh [EMAIL PROTECTED] wrote:
  
Can I use one rollback segment at time of export?Isyes,thenSET TRANSACTION USE ROLLBACK SEGMENTrollbacksegmentname;



--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Jeremiah Wilton  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).

Re: ROLLBACK SEGMENT?

2002-01-25 Thread orantdba


HI Raj,

I hope you feel better :-).

John

[EMAIL PROTECTED] wrote:

John,

I DISAGREE. The gymnastics of assigning a large rollback segment to an
export could avoid the snapshot too old error.

I agree with Jeremy when he says export does not generate rollback. But I
was trying to impress upon him that still an export could end up with the
snapshot too old message, particularly if there are plenty of active DML
transactions happening while the export is in progress, or if the export
uses the consistent parameter, or the rollback segments are not properly
sized.

To stress my point further, Note:22836.1 on Metalink. I rest my case ;-)

Raj





orantdba [EMAIL PROTECTED]@fatcity.com on 01/25/2002 08:20:25 AM

Please respond to [EMAIL PROTECTED]



Sent by:  [EMAIL PROTECTED]


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


Hi Raj,

Interesting that you first agree with Jeremy and then argue with him.  It
is precisely because
export does not generate rollback that the gymnastics of taking all of
the other rbs's offline
will not help anything.  It might make you feel better, however :-).

John

[EMAIL PROTECTED] wrote:




Export doesn't generate any rollback, right, so what is it supposed to
accomplish by doing this incantation?





Sorry to press the point, but could you elaborate on how that COULD
possibly make any difference for 'snapshot too old'?



For the same reason, any other transaction could end up with a snapshot too
old error. Export does not generate any rollback, but there could be users
performing DML operations on the table  that is being exported, and the
export needs to be redirected to read from the rollback segments. The
likelihood of the error being thrown up especially if one uses the
consistent parameter could be very high, if you dont have a large enough
rollback segment without an optimal clause.

Raj





Jeremiah Wilton [EMAIL PROTECTED]@fatcity.com on 01/23/2002 11:20:40
AM

Please respond to [EMAIL PROTECTED]



Sent by:  [EMAIL PROTECTED]


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


On Tue, 22 Jan 2002, [EMAIL PROTECTED] wrote:



H ... COULD help in avoiding snapshot too old errors.



Sorry to press the point, but could you elaborate on how that COULD
possibly make any difference for 'snapshot too old'?

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton



Jeremiah Wilton [EMAIL PROTECTED] wrote:

So what does it accomplish to assign export [to] a particular
rollback segment?

Export doesn't generate any rollback, right, so what is it supposed to
accomplish by doing this incantation?

On Tue, 22 Jan 2002, Jason Rowski wrote:



... you can use the following trick to assign export a
particular rollback segment -

1) Create a rollback segment tablespace with one large
segment and bring it online before export.
2) Offline all existing rollback segments.
3) Export the database
4) Offline the large tablespace created earlier.
5) Bring back the orginals rollback segments online.


--- Seema Singh [EMAIL PROTECTED] wrote:


Can I use one rollback segment at time of export?Is
yes,then
SET TRANSACTION USE ROLLBACK SEGMENT
rollbacksegmentname;



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeremiah Wilton
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: orantdba
  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: ROLLBACK SEGMENT?

2002-01-25 Thread orantdba


Sorry Jeremiah!

John

[EMAIL PROTECTED] wrote:

Guys, in the next round, please correct Mr. Wilton's first name to -
Jeremiah. 

Cut  paste is a wonderful thing ;-)
 

- Kirti 


-Original Message-
Sent: Friday, January 25, 2002 10:35 AM
To: Multiple recipients of list ORACLE-L



John,

I DISAGREE. The gymnastics of assigning a large rollback segment to an
export could avoid the snapshot too old error.

I agree with Jeremy when he says export does not generate rollback. But I
was trying to impress upon him that still an export could end up with the
snapshot too old message, particularly if there are plenty of active DML
transactions happening while the export is in progress, or if the export
uses the consistent parameter, or the rollback segments are not properly
sized.

To stress my point further, Note:22836.1 on Metalink. I rest my case ;-)

Raj

orantdba [EMAIL PROTECTED]@fatcity.com on 01/25/2002 08:20:25 AM
Please respond to [EMAIL PROTECTED]
Sent by:  [EMAIL PROTECTED]
To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:


Hi Raj,

Interesting that you first agree with Jeremy and then argue with him.  It
is precisely because
export does not generate rollback that the gymnastics of taking all of
the other rbs's offline
will not help anything.  It might make you feel better, however :-).

John

[EMAIL PROTECTED] wrote:




Export doesn't generate any rollback, right, so what is it supposed to
accomplish by doing this incantation?





Sorry to press the point, but could you elaborate on how that COULD
possibly make any difference for 'snapshot too old'?



For the same reason, any other transaction could end up with a snapshot too
old error. Export does not generate any rollback, but there could be users
performing DML operations on the table  that is being exported, and the
export needs to be redirected to read from the rollback segments. The
likelihood of the error being thrown up especially if one uses the
consistent parameter could be very high, if you dont have a large enough
rollback segment without an optimal clause.

Raj


Jeremiah Wilton [EMAIL PROTECTED]@fatcity.com on 01/23/2002 11:20:40
AM

Please respond to [EMAIL PROTECTED]
Sent by:  [EMAIL PROTECTED]
To:   Multiple recipien
ts of list ORACLE-L [EMAIL PROTECTED]
cc:

On Tue, 22 Jan 2002, [EMAIL PROTECTED] wrote:

H ... COULD help in avoiding snapshot too old errors.

Sorry to press the point, but could you elaborate on how that COULD
possibly make any difference for 'snapshot too old'?

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton


Jeremiah Wilton [EMAIL PROTECTED] wrote:

So what does it accomplish to assign export [to] a particular
rollback segment?

Export doesn't generate any rollback, right, so what is it supposed to
accomplish by doing this incantation?

On Tue, 22 Jan 2002, Jason Rowski wrote:

... you can use the following trick to assign export a
particular rollback segment -

1) Create a rollback segment tablespace with one large
segment and bring it online before export.
2) Offline all existing rollback segments.
3) Export the database
4) Offline the large tablespace created earlier.
5) Bring back the orginals rollback segments online.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  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: Limits on referential integrity

Hi Dennis,

Just my opinion but I tried to follow these rules as a DBA.

1. If the business rule can be implemented with pk, fk, unique or check
constraints I do it as such
2. If the business rule can be implemented as a trigger I code it as a
trigger
3. If none of the above, I implement as a stored procedure and try to
insure that every developer uses this procedure.

Occasionally I have heard the "performance discussion" in regards to
constraints. In 5 years of consulting I have never had constraints be
THE problem. But if I was a developer that had written some of the
awful SQL I have seen, I might have tried . Constraints do put a
premium on error checking by the application on inserts/updates.

Hope this helps,
John

[EMAIL PROTECTED] wrote:

Jared - I wasn't clear, but then again it is Monday. I have a team ofinexperienced developers starting a big, new Java application. They have agood, experienced data model consultant helping them create the data model.They are eager to include referential integrity. So eager it has me a littleworried. My question: "Is there too much of a good thing?". In Oracle 7,sometimes sites would remove RI to ensure good performance (we are startingthis project on Oracle9i). Has anyone encountered problems with too manyconstraints? Any guidelines you use with developers? Thanks.Dennis WilliamsDBALifetouch, Inc.[EMAIL PROTECTED]-Original Message-Sent: Monday, January 21, 2002 4:16 PMTo: Multiple recipients of list ORACLE-LI would be you lunch that what they are implementing in theircode is not actually R
I. They may be implementing code to ensure things get inserted in the right order, and that child rowshave a parent.This is a very weak form of RI. Oracle is very good at implementingRI, and it is not dependent on an application. RI in the databaseis the route to choose unless there is some good reason not to.RI in the database will prevent orphaned data created through updates, deletes or even ( gasp! ) bugs in the app.Programmers tend to dislike RI in the database because itforces them to maintain data integrity in a transaction. This isnot a bad thing, it just forces them to have a good understandingof their transactions.Point out to them that it is less code to write as well. :)JaredDENNIS WILLIAMS [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]01/21/02 01:35 PMPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]cc: Subject:Limits on referential integrityHow much referential integrity should be implemented in Oracle? We arestarting a large new Java project. Our current applications keep theirreferential integrity inside their own dictionary, so I haven't had to dealmuch with referential integrity recently. Can there be too much of a goodthing? What guidelines do you tend to use? At this point the developers aredesigning the data model so they are busily linking all the little boxes. Myattitude at this point is "implement what you've got and if there areperformance problems we'll deal with them when they arise". Can anyone giveme a better motto?
Thanks.Dennis WilliamsDBALifetouch, Inc.[EMAIL PROTECTED]

Re: Limits on referential integrity

Hi Dennis,

Agreed this was not the developers fault, it was the DBA's! I don't blame

this on RI being handled by constraints, but on a DBA that doesn't understand

the consequences, the resulting table level lock could have also been a problem
:-).
BTW, if RI had been handled via the application they would have had the same

problem.

John

[EMAIL PROTECTED] wrote:

John,I have only seen one situation where referential integrity has caused aproblem that the developer could not prevent. That case involved a foreign keywith the 'on delete cascade' option turned on and the key column in the childtable was NOT indexed. OH, BTW the child table was well lets just say VERYlarge (2 billion rows).Dick GouletReply SeparatorSubject:Re: Limits on referential integrityAuthor: orantdba [EMAIL PROTECTED]Date: 1/22/2002 5:40 AM--020102080806060304030001Content-Type: text/plain; charset=us-ascii; format=flowedContent-Transfer-Encoding: 7bitHi Dennis,Just my opinion but I tried to follow these rules as a DBA. 1. If the business rule can be implemented with pk, fk, unique or check constraint
s I do it as such2. If the business rule can be implemented as a trigger I code it as a trigger3. If none of the above, I implement as a stored procedure and try to insure that every developer uses this procedure.Occasionally I have heard the "performance discussion" in regards to constraints. In 5 years of consulting I have never had constraints be THE problem. But if I was a developer that had written some of the awful SQL I have seen, I might have tried [:-)] . Constraints do put a premium on error checking by the application on inserts/updates.Hope this helps,John[EMAIL PROTECTED] wrote:

Jared - I wasn't clear, but then again it is Monday. I have a team ofinexperienced developers starting a big, new Java application. They have agood, experienced data model consultant helping them create the data model.They are eager to include referential integrity. So eager it has me a littleworried. My question: "Is there too much of a good thing?". In Oracle 7,sometimes sites would remove RI to ensure good performance (we are startingthis project on Oracle9i). Has anyone encountered problems with too manyconstraints? Any guidelines you use with developers? Thanks.Dennis WilliamsDBALifetouch, Inc.[EMAIL PROTECTED]-Original Message-Sent: Monday, January 21, 2002 4:16 PMTo: Multiple recipients of list ORACLE-LI would be you lunch that what they are implementing in theircode is not actually
RI. They may be implementing code to ensure things get inserted in the right order, and that child rowshave a parent.This is a very weak form of RI. Oracle is very good at implementingRI, and it is not dependent on an application. RI in the databaseis the route to choose unless there is some good reason not to.RI in the database will prevent orphaned data created through updates, deletes or even ( gasp! ) bugs in the app.Programmers tend to dislike RI in the database because itforces them to maintain data integrity in a transaction. This isnot a bad thing, it just forces them to have a good understandingof their transactions.Point out to them that it is less code to write as well. :)JaredDENNIS WILLIAMS [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]01/21/02 01:35 PMPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:Subject:Limits on referential integrityHow much referential integrity should be implemented in Oracle? We arestarting a large new Java project. Our current applications keep theirreferential integrity inside their own dictionary, so I haven't had to dealmuch with referential integrity recently. Can there be too much of a goodthing? What guidelines do you tend to use? At this point the developers aredesigning the data model so they are busily linking all the little boxes. Myattitude at this point is "implement what you've got and if there areperformance problems we'll deal with them when they arise". Can anyone giveme a better motto? Thanks.Dennis WilliamsDBALifetouch, Inc.[EMAIL PROTECTED]

--020102080806060304030001Content-Type: multipart/related;boundary="InterScan_NT_MIME_Boundary"--InterScan_NT_MIME_BoundaryContent-Type: multipart/alternative;boundary="020102080806060304030001" boundary="070606010707000609020708"--070606010707000609020708Content-Type: text/html; charset=us-asciiContent-Transfer-Encoding: 7bithtmlhead/headbodypre wrap=""Hi Dennis,Just my opinion but I tried to follow these rules as a DBA. 1. If the business rule can be implemented with pk, fk, unique or check constraints I do it as such2. If the business rule can be implemented as a trigger I code it as a trigger3. If none of the above, I implement as a store

Re: Limits on referential integrity

 at implementing
RI, and it is not dependent on an application.  RI in the database
is the route to choose unless there is some good reason not to.

RI in the database will prevent orphaned data created through
updates, deletes or even ( gasp! ) bugs in the app.

Programmers tend to dislike RI in the database because it
forces them to maintain data integrity in a transaction.  This is
not a bad thing, it just forces them to have a good understanding
of their transactions.

Point out to them that it is less code to write as well. :)

Jared







DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/21/02 01:35 PM
Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Limits on referential integrity


How much referential integrity should be implemented in Oracle? We are
starting a large new Java project. Our current applications keep their
referential integrity inside their own dictionary, so I haven't had to
deal
much with referential integrity recently. Can there be too much of a good
thing? What guidelines do you tend to use? At this point the developers
are
designing the data model so they are busily linking all the little boxes.
My
attitude at this point is implement what you've got and if there are
performance problems we'll deal with them when they arise. Can anyone
give
me a better motto?
Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
  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: DENNIS WILLIAMS
  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: orantdba
  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: ROLLBACK SEGMENT?


HI Seema,

Export is reading the data from the oracle database and writing it to an 
associated binary file.  It only uses rollback segments to provide read 
consistency of data blocks being read.  This will need to use whatever 
rbs's have been assigned to the blocks we are reconstructing.  

Hope this helps,
John

[EMAIL PROTECTED] wrote:

 Hi
 Can I use one rollback segment at time of export?Is yes,then
 SET TRANSACTION USE ROLLBACK SEGMENT rollbacksegmentname;
 Thx
 -seema



 _
 Chat with friends online, try MSN Messenger: http://messenger.msn.com



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  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: SPACE FREE HOW?

2002-01-18 Thread orantdba


The dba_space package has routines that will tell you wherer the hwm 
mark. With
that infomration and  1.75 you can get a cup of coffee :-).  Knowing 
where the
HWM mark is, is not helpful.  The only way to move it, is to truncate 
the table.
I know this is difficult in a 24X7 system but frankly is unavoidable.  

BTW, you have a perfect situation for a partitioned table based on 
months.  Then
instead of deleting date you can drop the partition.

John
[EMAIL PROTECTED] wrote:

 Ethan
 The database is in production and users are accesing 24x7.What will be 
 best approach to do?
 DO u have any scripts how to find HWM?
 Thanks
 -Seema


 From: Post, Ethan [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: SPACE FREE HOW?
 Date: Thu, 17 Jan 2002 14:25:37 -0800

 Deleting records from a table does not free up space in the database.
 Search for high water mark in the concepts manual and you should find an
 explanation of how this works.  The statement below only frees up space
 above the high water mark on the table.

 You can...

 create table foo nologging as (select * from big_table);

 truncate table big_table;

 insert into big_table (select * from foo);

 drop table foo;


 -Ethan

 -Original Message-
 Sent: Thursday, January 17, 2002 3:27 PM
 To: Multiple recipients of list ORACLE-L


 ALTER TABLE table DEALLOCATE UNUSED KEEP integer;
 the keep clause is optional.

 -sunil

 -Original Message-
 Sent: Thursday, January 17, 2002 2:58 PM
 To: Multiple recipients of list ORACLE-L


 Hi
 I deleted millions of rows from diffrent tables and I have not seen any
 impact on database size.What I have to do to get that free space?
 Is it necessary to shutdown the database?
 Thx
 -Seema

 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Post, Ethan
   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).





 _
 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: orantdba
  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: Trouble with imp on 8.1.6

2002-01-18 Thread orantdba


HI Rick,

Could you share with us the export statement and the import statement 
you used.
 Tha will help figure out what went wrong.

John

[EMAIL PROTECTED] wrote:

Hi All,

I did a successfull export on 8.1.6 for user=
I am trying to import on same server into another user. I get following
message but no tables are created?
I have full privs.

Can someone help?

Connected to: Oracle8i Release 8.1.6.0.0 - Production
JServer Release 8.1.6.0.0 - Production

Export file created by EXPORT:V08.01.06 via conventional path
import done in WE8ISO8859P1 character set and US7ASCII NCHAR character set
import server uses US7ASCII character set (possible charset conversion)
Import terminated successfully without warnings.

Thanks
Rick




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  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: SPACE FREE HOW?

2002-01-18 Thread orantdba




Hi Seema,

In a word NO. From the documentation:

Use the deallocate_unused_clause to explicitly deallocate unused space
at the end of the table, partition or subpartition, overflow data segment,
LOB data segment, or LOB index and makes the space available for other segments
in the tablespace. Yo can free only unused space above the high water mark
(that is, the point beyound which database blocks have not yet been formatted
to receive data).

Another lister provided you with the best solution i know of:

1. copy data to a holding table
create table holding_table nologging as select * from my_table_that_is_too_big;

2. truncate the table 
truncate table my_table_that_is_too_big;

3. copy the data over
insert into my_table_that_is_too_big select * from holding_table;

4. drop the holding table
drop table holding_table;

John
[EMAIL PROTECTED] wrote:

Hi 
Can I use following command to recover the space. 
alter table tablename deallocate unused; 
I don't want to truncate and import. 
Thx 
-Seema 
  
  
  From: "Ron Rogers" [EMAIL PROTECTED] 

Reply-To: [EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 
Date: Thu, 17 Jan 2002 13:55:47 -0800 

Seema, 
The table has set it'd HWM where the old data resided. The easiest? 
method of recovering the space is to export the table and then truncate 
the table followed by importing the table data back into the table. The 
truncate function will remove all of the data and re-establish the size 
back to original. 
ROR mm 

 [EMAIL PROTECTED] 01/17/02 03:57PM  
Hi 
I deleted millions of rows from diffrent tables and I have not seen any 

impact on database size.What I have to do to get that free space? 
Is it necessary to shutdown the database? 
Thx 
-Seema 


_ 
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Seema Singh 
 INET: oracledbam@hotmReceived: from CONNECT-MTA by galotterail.com 

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





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

Re: designer6i vs. designer2000

2002-01-16 Thread orantdba


Hi Andrea,

Designer 6i is the latest release of the Designer products. I would
recommend you learn this release.  Designer 2000 is probably still
in use in a FEW places, but little new work should be done in this
release.

John

[EMAIL PROTECTED] wrote:

Hi,

Is Designer 2000 and Designer 6i similar?  They are
about data modeling, aren't they.  If I'd like to
learn one, which one do you recommended?  Thanks!

Andrea

__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  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: memory resource...

2002-01-16 Thread orantdba




Hi Shuan,

This has nothing to do with how your service is started and everything to
do with the 
value of the initiazation paramaters that are used to start the database.
The simple 
answer is that you can get oracle to use less memory by reducing the value
of these
parameters. The most likely culprits, db_block_buffers, shared_pool_size,
sort_area_size and log_buffer_size. However you didn't mentioned why you
want
them to be smaller. It is possible they were set by the previous dba at these
values
to maximize performance of the system. Setting them smaller could negatively

effect performance.

Why do you want to make these smaller?

JOhn

[EMAIL PROTECTED] wrote:

  
  
  hi, DBAs...
  
  i'm using Win2000 Advance Server,
  with Oracle Enterprise Edition 8.1.6.
  by using task manager,
  i found tat the ORACLE.EXE is using about
58,556K  memory for one db,
  which is start manually.
  and ORACLE.EXE for anotherdb is only about
 10,000K,
  which is start automatically when server
 start.
  
  is it that problem of manually start?
  how can i reduce the memory resource used
by  oracle?
  
  thanks...
  and hav a nice day.

Re: problem with 9i import

2002-01-15 Thread orantdba




Proof that there is more than one way to skin a cat :-). If new2orcl had
done
what you suggested they wouldn't have a problem either :-).

John

[EMAIL PROTECTED] wrote:

  Well, I never check or set the oracle_sid.I just use userid/password@database and the import always go to the rightDB.On NT and win clients.Yechiel Adar, Mehish Computer Services[EMAIL PROTECTED]
  
-Original Message-From: orantdba [SMTP:[EMAIL PROTECTED]]Sent: Mon, January 14, 2002 11:15 PMTo:   Multiple recipients of list ORACLE-LSubject:  Re: problem with 9i importHI New2orcl,My guess is that your $oracle_sid was set to point to oem when you did the import with is why it imported into that database.  The only way to get it out is to log on to the oem database and drop each table.To get it into the correct database set the oracle_sid and then do your import.Good luck,John[EMAIL PROTECTED] wrote:

  Hi,I have recently installed 9i on my computer and wanted to import my
  
  exdat.dmp 
  
file from my Oracel 8i. I got nowhere with the enterprise manager console

so 

  after trying with no success through Oracle support I decided to try
  
  doing 
  
the import from a command prompt. Well, I must have done something wrong because it imported the file but it put it in the  OEM database instead

of 

  the ORCL and so my developer 6.0 does not have access to any of the
  
  tables or 
  
data that I imported. Does anyone know the correct sintax to do the

import 

  that I want to do and also how do I get it out of the OEM now? Have I
  
  totally 
  
messed everything up?Thanks

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: orantdba  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).-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Re: tablespace default maxextents

2002-01-14 Thread orantdba


Hi Mitchell,

The maxextents on the tablespace are applied as defaults to tables or 
indexes that are created without an explicit maxextents value.  An 
explicit maxextents clause on the table or index level
will override the tablespace clause.

Hope this helps,
John

[EMAIL PROTECTED] wrote:

Hi Gurus.

Oracle  has tablespace maxextents and table or index maxextents. Which one
oracle depend on?

thanks
Mitchell



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  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: problem with 9i import

2002-01-14 Thread orantdba


HI New2orcl,

My guess is that your $oracle_sid was set to point to oem when you did 
the import with is why it imported into that database.  The only way to 
get it out is to log on to the oem database and drop each table.

To get it into the correct database set the oracle_sid and then do your 
import.

Good luck,
John

[EMAIL PROTECTED] wrote:

Hi,
I have recently installed 9i on my computer and wanted to import my exdat.dmp 
file from my Oracel 8i. I got nowhere with the enterprise manager console so 
after trying with no success through Oracle support I decided to try doing 
the import from a command prompt. Well, I must have done something wrong 
because it imported the file but it put it in the  OEM database instead of 
the ORCL and so my developer 6.0 does not have access to any of the tables or 
data that I imported. Does anyone know the correct sintax to do the import 
that I want to do and also how do I get it out of the OEM now? Have I totally 
messed everything up?
Thanks



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  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: RMAN

2002-01-12 Thread orantdba


Unfortunately NO.

John

[EMAIL PROTECTED] wrote:

Can RMAN be used to backup a V7.3.4.5 instance?
In addition to the obsolete version, which I'm forced to continue
to support, I'm supporting both 8i  9i instances.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  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: The OCP bar is being raised

2002-01-11 Thread orantdba




I'm thinking of changing my handle to obviousman? 

[EMAIL PROTECTED] wrote:

  Should we parse you handle, O,rant, DBA. That's it!  R- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Thursday, January 10, 2002 11:03 AM
  
Hi all,The oca exams are the same exams you would take on the way to being anOCP under the current program.  The only difference is along the way youcan get a designation of OCA.  Not unlike Microsofts MCP.John[EMAIL PROTECTED] wrote:

  From the website:--To become an Oracle Certified Professional, you must pass allrequired exams--in your selected job role, including those at the Associate level.The way I read that, you have to have the OCA exams before you can getthe OCP.  So if you take and pass the OCP, until you pay for and passthe OCA, you cannot get the OCP certificat and recognition and youcannot even take the OCM.--Chris-Original Message-From: SARKAR, Samir [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 10, 2002 10:28 AMTo: '[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject: RE: The OCP bar is b
eing raisedChris,Am not clear on  this. To b an OCP, we require to pass 5examsright ?? So, if we get theOCP Associate after passing 2 exams, we need to pass only another3 exams for getting OCPor do we have to go through all the 5 exams all over again ??I think we can directly sit for the OCP tests though instead ofgoing through the OCA. But to get theOCP Master, we will necessarily have to b a OCP.Do correct me if I am wrong though.Regards,SamirSamir SarkarOracle DBA - Lennon TeamSchlumberger SemaEmail :  [EMAIL PROTECTED][EMAIL PROTECTED]Phone : +44
 (0) 115 - 95 76217EPABX : +44 (0) 115 - 957 6418 Ext. 76217Fax : +44 (0) 115 - 957 6018-Original Message-From: Bowes, Chris [mailto:[EMAIL PROTECTED]]Sent: 10 January 2002 15:05To: Multiple recipients of list ORACLE-LSubject: RE: The OCP bar is being raisedI'd say the cost is being raised.  Look at the requirementsfor each.  You can't just take the OCM exam.  No we wouldfirst have to get the OCA.  Whether or not we need the entrylevel cert we have to have it.  Then, and only then, can wetake the OCP.  Then and only then, can we take the OCM andthat is after we take these REQUIRED classes from Oracle Ed.So someone the caliber of Steve Adams or Jared Still, has tospend money in a class that they could probably teach fr
ommemory before they can get certification and that is aftergetting 2 other certs that have no value to them.  Call me acynic, but to me, this is nothing but a money grab.From the website:--To become an Oracle Associate, you must pass the exams
  
  
  required
  

  -- for the Oracle Associate level of your selected job role.Typically,--two exams are required; the first one can be taken via theInternet,--while subsequent exams must be taken in a proctoredenvironment. By--completing your Oracle Associate, you are half-way towardachieving the-- Oracle Certified Professional credential.--To become an Oracle Certified Professional, you must passall required exams--in your selected job role, including those at the Associatelevel.--To become an Oracle Certified Master, you must first be anOracle--Certified Professional. Additionally, achieving your OCMcredential--requires attending two advanced level Oracle Universitycourses from--the list shown on this page as well as pas
sing the OCMPracticum exam.--Chris-Original Message-From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] ]Sent: Thursday, January 10, 2002 9:16 AMTo: Multiple recipients of list ORACLE-LSubject: The OCP bar is being raisedAnyone care to comment on the following, IMHO it's about time:
  
  

  

  ---Introducing two new levels of Oracle Certified Professional(OCP) AchievementA recent *IDC report on IT Education and Training Servicesquoted databaseprofessionals and network engineers as the fastest-growingareas of ProfessionalCertification. And in an October survey from *crn.com onCertification, 58% ofrespondents said that it is very difficult to find qualifiedOracle CertifiedProfessionals-Database Administrators.To meet this demand, we have recently introduced two newlevels of professionalachievement to DBAs (and soon

Re: The OCP bar is being raised

2002-01-11 Thread orantdba

Hi Rachel,

Now we are to the point, is it valuable? I say yes and I have studied for
and
passed the ocp for 7, upgraded to 8 and to 8i and will soon take the 9i upgrade
test. I also hold the Oracle 7 certification that was offered by Chauncey
before
the Oracle came out with the OCP. Others say it is not. It is their dollar,
and
they can spend it as they wish.

Ultimately the market decides value, I don't believe that any sane manager
of DBA's
would hire someone just because they are ocp's. Managers would tend to value
relevant experience, the interview process, and degrees well before looking
at ocp's.

So why do I think it is important? The first person who sees your resume
is usually
in the HR department. They cannot hire you but they can file your resume
in the
circular file. Cute little designations like OCA, OCP, OCM, MCP, MCSE, CNE,
etc
help get you past those people and on to the people who can actually understand
you
when you talke about performing block dumps and interrogating the itl. Those
people
can say yes and will because of my experience and interview presence. They
will
probably not care one bit about the cute little designations, but it is irrevelant
if I don't
get to talk to them.

I have had the discussion at oow, etc with more than a few people (perhaps
even you)
asking if you had two candidates with exactly the same criterias but one
had OCP and
one didn't which would you hire? This is a little like the "If god is all
powerful can he make
a rock so big that he himself cannot pick it up" question. In the case described
above I would
probably go to things like "Which is cheaper?", "Which had experience that
most matched my
project?", " Which had the best personality match for my group?". I don't
think OCP would
make that much of a difference.

John

[EMAIL PROTECTED] wrote:

John,I have no objection to Oracle trying to make money (heck, I own stock,I WANT and expect them to make money!)The problem is not that they are trying to make money, but that this isbecoming something you HAVE to do/have to get a job working withOracle. And they haven't convinced me of the value of that piece ofpaper. I know way too many certified DBAs who I wouldn't trust to evenquery my databases.Rachel--- orantdba [EMAIL PROTECTED] wrote:

Hmmm,Imagine that, a publicly traded company that it trying to makemoney, I am shockeddismayed, I don't believe I will be able to sleep tonight. Chris, could you provide me with the list of companies that are not trying to make money?I want to make sure that I don't go to work for them, or learn their products.John :-)[EMAIL PROTECTED] wrote:

I'd say the cost is being raised. Look at the requirements for

each.

You can't just take the OCM exam. No we would first have to get

the

OCA. Whether or not we need the entry level cert we have to have

it.

Then, and only then, can we take the OCP. Then and only then, can

take the OCM and that is after we take these REQUIRED classes from Oracle Ed. So someone the caliber of Steve Adams or Jared Still,

has

to spend money in a class that they could probably teach from

memory

before they can get certification and that is after getting 2 other

certs that have no value to them. Call me a cynic, but to me, this

nothing but a money grab.From the website:--To become an Oracle Associate, you must pass the exams required-- for the Oracle Associate level of your selected job role.

Typically,

--two exams are required; the first one can be taken via the

Internet,

--while subsequent exams must be taken in a proctored environment.

--completing your Oracle Associate, you are half-way toward

achieving the

-- Oracle Certified Professional credential.--To become an Oracle Certified Professional, you must pass all required exams--in your selected job role, including those at the Associate

level.

--To become an Oracle Certified Master, you must first be an Oracle--Certified Profes

Re: Management Server

2002-01-10 Thread orantdba




That is correct, you will need to run the enterprise Manager Configuration
Assistant. It will configure your oms to work with a OEM repository.

When you run the oms for the first time you will use username sysman password
oem_temp it
will prompt you to change this value.

John

[EMAIL PROTECTED] wrote:

  Hello ShuanIf I am not mistaken you need to run a configuration program before you canstart using OEM on 8.1.6.Yechiel Adar, Mehish Computer Services[EMAIL PROTECTED]
  
-Original Message-From: C.S.Venkata Subramanian [SMTP:[EMAIL PROTECTED]]Sent: Thu, January 10, 2002 6:55 AMTo:   Multiple recipients of list ORACLE-LSubject:  Re: Management ServerChk for the username and password. Or else try creating the repositoryafter dropping the same.Venkat --On Wed, 09 Jan 2002 15:56:26   shuan wrote:

  good day, DBA...i'm now self-learning Oracle 8.1.6 Enterprise Edition.using Oracle8.1.6 on Win2000 Advance Server,and the Oracle Management Server also in the same machine.after i faced the problem of ORA-12638 when attempt to login,the Management Server failed to run.(even the Service).now the error ORA-12638 is fixed by changing a line in sqlnet.ora.yet i still cant start the Management Server Service.when i check the "Event Viewer", it say,   The service has terminated abnormally.  See the fileD:\Oracle\PODB\sysman\log\OMS.log for details. and this:   No login credentials were provided.  The service cannot start. so, what's wrong with this?pls help.thanks and hav a nice day.
  
  -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: C.S.Venkata Subramanian  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).-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Re: The OCP bar is being raised

2002-01-10 Thread orantdba

Title: Message



Hi all,

The oca exams are the same exams you would take on the way to being an OCP
under the current program. The only difference is along the way you can
get a designation of OCA. Not unlike Microsofts MCP.

John

[EMAIL PROTECTED] wrote:

  
  
  
>From  the website:
  --To become an Oracle Certified Professional, you must
pass all  required exams 
  --in your selected job role, including  those at the Associate
level. 
  
  
  
The  way I read that, you have to have the OCA exams before you can get the
 OCP. So if you take and pass the OCP, until you pay for and pass the OCA,
 you cannot get the OCP certificat and recognitionand you cannot even take
 the OCM.
  
  
--Chris
  
  

-Original Message-
From: SARKAR, Samir[mailto:[EMAIL PROTECTED]]

Sent: Thursday,January 10, 2002 10:28 AM
To: '[EMAIL PROTECTED]'
Cc:'[EMAIL PROTECTED]'
Subject: RE: The OCP bar is beingraised


Chris,

Am not clear
onthis. To b an OCP, we require to pass 5 examsright ?? So, if we
getthe
OCP Associate
afterpassing 2 exams, we need to pass only another 3 exams for getting
   OCP
or do we have
to gothrough all the 5 exams all over again ??

I think we can
directlysit for the OCP tests though instead of going through the OCA.
But to getthe
OCP Master,
we willnecessarily have to b a OCP.

Do correct me
if I amwrong though.

Regards,
Samir

Samir Sarkar
Oracle DBA - Lennon
   Team
Schlumberger
Sema
Email :[EMAIL PROTECTED]
[EMAIL PROTECTED]

Phone : +44 (0) 115
- 95 76217
EPABX : +44 (0) 115
- 9576418 Ext. 76217
Fax : +44 (0) 115
- 9576018

  
-Original Message-
  From: Bowes, Chris  [mailto:[EMAIL PROTECTED]]
  Sent: 10 January 2002  15:05
  To: Multiple recipients of list ORACLE-L
  Subject:  RE: The OCP bar is being raised
  
  
  I'd say the cost is being raised. Look at the  
   requirements for each. You can't just take the OCM exam. No we 
would first have to get the OCA. Whether or not we need the entry  level
cert we have to have it. Then, and only then, can we take the  OCP.
Then and only then, can we take the OCM and that is after we take  these
REQUIRED classes from Oracle Ed. So someone the caliber of Steve  Adams
or Jared Still, has to spend money in a class that they could probably  
   teach from memory before they can get certification and that is after
 getting 2 other certs that have no value to them. Call me a cynic,
but  to me, this is nothing but a money grab.
  From the website:
  --To become an Oracle Associate, you must pass the
exams  required
  -- for the Oracle Associate level of your  selected
job role. Typically, 
  --two exams are  required; the first one can be
taken via the Internet, 
  --while subsequent exams must be taken in a proctored
environment. By  
  --completing your Oracle Associate, you are half-way
 toward achieving the
  -- Oracle Certified  Professional credential. 
  
  --To become an Oracle Certified Professional, you
must pass  all required exams 
  --in your selected job role,  including those at
the Associate level. 
  
  --To become an Oracle Certified Master, you must
first be an  Oracle 
  --Certified Professional. Additionally,  achieving
your OCM credential 
  --requires attending  two advanced level Oracle
University courses from 
  --the list shown on this page as well as passing the
OCM Practicum  exam. 
  
  --Chris
  
  -Original Message-
  From:  [EMAIL PROTECTED] [
mailto:[EMAIL PROTECTED]
] 
  Sent: Thursday, January 10, 2002 9:16 AM
  To:  Multiple recipients of list ORACLE-L
  Subject: The  OCP bar is being raised
  
  Anyone care to comment on the following, IMHO it's
about  time:
  
  ---
  Introducing two new levels of  Oracle Certified
Professional (OCP) Achievement 
  
  A recent *IDC report on IT Education  and Training
Services quoted database
  professionals  and network engineers as the fastest-growing
areas of Professional
  Certification. And in an October survey from *crn.com
on  Certification, 58% of
  respondents said that it is  very difficult to find
qualified Oracle Certified
  Professionals-Database Administrators. 
  To meet this demand, we have recently introduced
two new  levels of professional
  achievement to DBAs (and soon  to be released to
Application and Java Developers
  worldwide): 
  The Oracle Certified Associate (OCA) -- an entry-level
 Oracle qualification
  requiring successful completion

Re: SQL for top 100 values

2002-01-10 Thread orantdba




This was a new feature in Oracle8i. In 7.3 the best way would be to open
a cursor that sorted the data and return the first N rows.

Sorry,
John

[EMAIL PROTECTED] wrote:

  I tried to run it in Oracle 7.3.4, it comes up with a syntax errorHere is the SQLselect x.fein,x.open_balfrom (select sf_get_fein(employer_id) fein, nvl(total_open_balance_amt,0) open_bal  from employer  order by open_bal desc ) xwhere rownum  101Here is what I getSQLWKS select x.fein,x.open_bal 2 from (select sf_get_fein(employer_id) fein, nvl(total_open_balance_amt,0) open_bal 3   from employer 4   order by open_bal desc ) x 5 where rownum  101 6  order by open_bal desc ) x  *ORA-00907: missing right parenthesisIs it because I am on a lower versionThanksDeen-Original Message-FaroultSent: Thursday, January 10, 2002 11:26 AMTo: Multiple recipients of list ORACLE-LDeen Dayal wrote:
  
hi SQL wizards,Can any body help me with the tjis SQL. I need a SQL records with top 100 values of a table ( not rownum  101 ).ThanksDeen

rownum  101 is OK if you nest your query, ORDER BY included, as anin-line view,ieselect x.valfrom (select val  from my_table  order by val desc) xwhere rownum  101--Regards,Stephane FaroultOriole Ltd--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Stephane Faroult  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).

Re: Clone a database

2002-01-09 Thread orantdba




Hi,


If the backup was made using OEM, especially in later versions then the backup
is
a RMAN backup. Please look at your script contents to verify. The documentation
discusses how to use rman backups to clone a database.

John

[EMAIL PROTECTED] wrote:

  easier perhaps only if you have the exact same disk layouts and spaceavailable.and certainly MUCH more time to create -- an import takes anywhere from2-4 times as long as the export did.--- "Babich , Sergey" [EMAIL PROTECTED] wrote:
  
Hi, Beatriz,If you want to create an identical copy of your production (that's myunderstanding), it is a lot easier to export it (FULL=Y) and thenimport thedump file into your new database. Let me know if you need more info.Regards,Sergey Babich, Oracle DBA -Original Message-Sent: Wednesday, January 09, 2002 4:50 AMTo:   Multiple recipients of list ORACLE-LSubject:  Clone a databaseHello list,I new to clone a database for changing between test to production.The new database is going to be in a different host.I have the copy obtained through the enterprise manager (I supposeitsa cold backup).Which are the steps I should follow?A lot of thanks-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?=  INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051San Diego, California-- Public Internet access / MailingListsTo 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: Babich , Sergey  INET: SBabich@handexm
ail.comFat City Network Services-- (858) 538-5051  FAX: (858) 538-5051San Diego, California-- Public Internet access / MailingListsTo 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).

__Do You Yahoo!?Send FREE video emails in Yahoo! Mail!http://promo.yahoo.com/videomail/

Re: reading variables

2002-01-09 Thread orantdba


 variables work fine in sqlplus but not anywhere else,  In what tool 
are you programming?

[EMAIL PROTECTED] wrote:

If I use the following for to reference a variable in my code:
Update Primus_Temp_Dump set owner =(test) where secure_id = Secure;

I get this compile error:
PLS-00103: Encountered the symbol  when expecting one of the following:

This is how you are supposed to reference variables in a SQL Statement?

If I do this:
Update Primus_Temp_Dump set owner =('test') where secure_id = Secure;

I do not get the error but it passes test into my query and it fails

Please help



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  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: EXPORT WITH QUERY CLAUSE in win NT

2002-01-08 Thread orantdba


Hi All,

Export has supported queries since 8i

an example from the 817 documentation is:

exp scott/tiger tables=emp query=\where job=\'SALESMAN\' AND SAL \1600\


hope this helps,
John

[EMAIL PROTECTED] wrote:

I don't remember export supporting queries.  Why don't you create a temp
table or tables, eg. create table t_linemto as select * from linemto where
PROJ_CODE='CF-804', and then export the temp tables?


  
 
rpapnoi   
 
@chemtex.co.iTo: Multiple recipients of list ORACLE-L 
 
n[EMAIL PROTECTED]   
 
Sent by: rootcc:  
 
 Subject: EXPORT WITH QUERY CLAUSE in win 
NT   
  
 
01/08/2002
 
01:00 AM  
 
Please
 
respond to
 
ORACLE-L  
 
  
 
  
 




Hi list

I want to export few tables with a common column in all. My OS is WinNT and
db version is Oracle 8.1.6

I am using the folling command

exp username/password@nts7 tables=(linemto,specs,specmast,password)
file=c:\MTO.DMP QUERY=where PROJ_CODE='CF-804'

It gives me the following error:
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-0: Export terminated unsuccessfully


Where I am missing? Can someone correct me.
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:
  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: orantdba
  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 Future???

2002-01-08 Thread orantdba

Title: Oracle Future???



Hi Eva,

I believe you have intercepted one of Bill Gates Dreams :-).

Actually I believe this message, taken out of context is in reference to
Orcacle's express,
financial and sales analyzer products. Those products are being integreated
into the 9i 
database, and at least in the opinion of ORacle this will make these products
stronger and
more of a threat, not less. 

It doesn't suprise me that MS marketing disagrees.

John 

[EMAIL PROTECTED] wrote:

  
  
  Hi Folks,
  Wonder if anyone would like to comment,
my MSSQL DBA sent me a couple of emails from a MSSQL mailing list, they were
discussing the future of MSSQL.
  Some of the comments included comments
about our DB - Oracle.
  I've added two here... 
  ...With Hyperion been seriously challenged
and overrun by Analysis Services, oracle will completely die out as they
integrate their current offering into Oracle9i. 
  ...Oracle will become another Apple:
5% market share. ...
  Do you guys agree? Is Oracle doing
anything about the very serious threat that MSSQL is placing on their market
share? 
  No, plans of changing personally,
but wondering if cross education won't be beneficial:)
  Regards
  Denham
   This e-mail message has been scanned for Viruses and Content and cleared
by  MailMarshal -  For more
information please visit
www.marshalsoftware.com

Re: Using Import/Export thru DBA studio requires OMS

2002-01-07 Thread orantdba


Hi Rick,

In order to use the import/export utilities of OEM you must be connected 
to oem via the
Oracle Management Server.  This is configured by using the Enterprise 
Manager Configuration
Assistant,  ON my installation this is at
start -- programs -- Oracle-orahome817 --   Enterprise Manager -- 
Configration Assistant

This utility is used to create a repository and to configure the OMS.

Hope this helps,
John


[EMAIL PROTECTED] wrote:

Hi All,

Platform is Win Nt Oracle 8.1.6.  When I try to use import/export utilities
in DBA studio I get a message stating I
must access thru Oracle Management Server. I have search and cannot find a
step by step on how to set up OMS
so I can use import/export in DBA studios.  Can someone help or point me to
some links that will provide what
I need.

Thanks
Rick




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  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: Installing Extra Oracle Features After The Initial Install

2002-01-03 Thread orantdba


Hi Rod,

You should be able to create a test database by running the Database 
Configuration Assistant.  Not sure about Pro*C but I believe adding them 
shouldn't affect anything else.

John

[EMAIL PROTECTED] wrote:

I have installed Oracle 8.1.6 on a Windows 2000 system.  I would like to install the 
Test database and the Pro C++ wizards which were not installed in the original 
install.

If I do a customized install, is it going to fowl up the stuff that has already been 
installed?

What should I look out for?

Thanks,
Rod



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  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: stupid oracle on windoze question




HI Joe,

>From the documentation:


 TNS_ADMIN

 Oracle software looks for TNS_ADMIN in one location in the 
registry (depending upon the type of Oracle home installed). If you installed 
software into the default Oracle home, then any software running from that 
Oracle home will look in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE. If you installed 
a new-style (8.0.4 or later) multiple Oracle home, then the Oracle software 
looks in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID
. The ALL_HOMES key is used by the installer and plays no role when translating
variables. 

 The environment always overrides the registry, so if TNS_ADMIN 
is set in the environment, that takes precedence over the TNS_ADMIN setting 
in the registry. No variables should be set in the environment by the Oracle 
Home Selector except for the PATH. 
Hope this helps,
John

[EMAIL PROTECTED] wrote:

  
  ok in the unix world, we have .tnsnames.ora file which overrides a
 $HOME/network/admin/tnsnames.ora file.
  
  Is there such a thing in the windoze world. a registry entry  maybe?
  
  thanks, joe

Re: stupid oracle on windoze question




Hi Jared,

Sorry, I misunderstood the question.

Environment variables can, however be set locally instead of at the system
level

tns_admin=directory

inside of a .bat or a .cmd script, maybe even perl :-)


John

[EMAIL PROTECTED] wrote:

  Not only is it not in the flaming manuals, I don't think youcan even do that on Windoze.Sure, you can set the TNS_ADMIN var inControlPanel-System-EnvVars, but that is rather broadin scope and does not offer the granularity available on unix.Jared  RachelCarmichael   To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]  wisernet100@Y   cc:  AHOO.COMSubject: RE: stupid oracle on windoze question   Se
nt by:  [EMAIL PROTECTED]om01/02/02 07:50AMPlease respondto ORACLE-L
   well the thing is, he wasn't looking for TNS_ADMIN since that justre-sets the directory Oracle looks at but wanted something that workedmore like how login.sql works -- where if you have the file in yourlocal working directory, it is used and overrides any other file.In Unix, if you have a .tnsnames.ora file (please note the initial ".")in your own personal $HOME directory)  it will override the values inthe $ORACLE_HOME/network/admin/tnsnames.ora or the$TNS_ADMIN/tnsnames.ora fileTHAT is what Joe wanted for Windows.  It ain't in the flaming manuals.--- Kimberly Smith [EMAIL PROTECTED] wrote:
  
Damn, why don't people use the manuals.  TNS_ADMIN.  Actually, youcan setthe puppy on Unix as well.  -Original Message-  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOETESTA  Sent: Wednesday, January 02, 2002 6:15 AM  To: Multiple recipients of list ORACLE-L  Subject: stupid oracle on windoze question  ok in the unix world, we have .tnsnames.ora file which overrides a$HOME/network/admin/tnsnames.ora file.  Is there such a thing in the windoze world.  a registry entrymaybe?  thanks, joe

__Do You Yahoo!?Send your FREE holiday greetings online!http://greetings.yahoo.com--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Rachel Carmichael  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).

Re: stupid oracle on windoze question




HI All, 

It is in that useless documentation, from the Net8 Administrators Guide

  
Ensure that the client machine has the tnsnames.ora and the
sqlnet.ora files in $ORACLE_HOME/network/admin
 on UNIX and ORACLE_HOME\network\admin
 on Windows platforms.  


 The search order for sqlnet.ora and 
tnsnames.ora follows: 

  
Current working directory from where an application is executed 
  
TNS_ADMIN environment variable 


 If the TNS_ADMIN environment variable is not defined
as a variable on Windows NT, it may be in the registry. 
  
  
If TNS_ADMIN is not defined, $ORACLE_HOME/network/admin on UNIX
and ORACLE_HOME\network\admin on Windows
platforms 

  

The one that I haven't seen documented is the "dot tnsnames.ora" on unix

Hope this helps,
-- John 

[EMAIL PROTECTED] wrote:

  ah but you can do something similar, at least according to Joe -- hefound it on a thread on MetaLink.You put a tnsnames.ora file in your local directory (I would supposewithout setting TNS_ADMIN) and then it will use the local oneinteresting, veddy interesting--- [EMAIL PROTECTED] wrote:
  
Not only is it not in the flaming manuals, I don't think youcan even do that on Windoze.Sure, you can set the TNS_ADMIN var inControlPanel-System-EnvVars, but that is rather broadin scope and does not offer the granularity available on unix.Jared Rachel   Carmichael   To: Multiple recipientsof list ORACLE-L [EMAIL PROTECTED]  wisernet100@Y   cc: AHOO.COMSubject: RE: stupidoracle on windoze question
   Sent by: [EMAIL PROTECTED]   om 01/02/02 07:50   AM   Please respond 
  to ORACLE-Lwell the thing is, he wasn't looking for TNS_ADMIN since that justre-sets the directory Oracle looks at but wanted something thatworkedmore like how login.sql works -- where if you have the file in yourlocal working directory, it is used and overrides any other file.In Unix, if you have a .tnsnames.ora file (please note the initial".")in your own personal $HOME directory)  it will override the values inthe $ORACLE_HOME/network/admin/tnsnames.ora or the$TNS_ADMIN/tnsnames.ora fileTHAT is what Joe wanted for Windows.  It ain't in the flamingmanuals.
--- Kimberly Smith [EMAIL PROTECTED] wrote:

  Damn, why don't people use the manuals.  TNS_ADMIN.  Actually, youcan setthe puppy on Unix as well.  -Original Message-  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOETESTA  Sent: Wednesday, January 02, 2002 6:15 AM  To: Multiple recipients of list ORACLE-L  Subject: stupid oracle on windoze question  ok in the unix world, we have .tnsnames.ora file which overrides
  
  a
  
$HOME/network/admin/tnsnames.ora file.  Is there such a thing in the windoze world.  a registry entrymaybe?  thanks, joe

__Do You Yahoo!?Send your FREE holiday greetings online!http://greetings.yahoo.com--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Rachel Carmichael  INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051San Diego, California-- Public Internet access / MailingListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a l
ine containing: UNSUB ORACLE-L(or the name of mailing list you want to be

Re: Problem Setting Up User