Hi List,
We are using Oracle 8.1.7 on Windows 2000. System RAM
is 3GB. We are using 1.5GB of SGA. System is 1GHz
processor.
We are getting sometimes problem with the error
ORA-04030. Our DBA says this is the problem because of
bug with Oracle 8.1.7 in Windows 2000 with CLOB
datatype. We have de
Hi Rao,
No, it is not running in MTS mode. It is running in
shared server mode.
Prasad BAV.
--- "Rao, Maheswara" <[EMAIL PROTECTED]>
wrote:
> Prasad,
>
> Is the database running on MTS mode?
>
> Rao
>
> -Original Message-
> Sent: Friday, November 09, 2001 9:00 AM
> To: Multiple recipi
we generally go for 50% tablesize for indexes .. works
for most of our medium sized game databases.
for very large tables .. i go with 20% sise of table
per index
Deepak
--- Ron Rogers <[EMAIL PROTECTED]> wrote:
> Greg,
> I usually insist on that information from the
> development group then I
Jared/Patrice,
We found that for its price, OEM was pretty good. I do agree that
Perl/Ksh/SQL*Plus scripts is still more solid than OEM and its agents, but
OEM 2.2 has come a long way since OEM 1.0. While there are many things that
I do NOT like about OEM (i.e. stuck 'deregistrations', cumbersome
Anyone out there have any experience running an Oracle Data Warehouse on
an IBM P660 (6M1) over a Shark/RAID-5/SAN environment?
Work great?
Any horror stories?
Any gotchas?
My concern in us potentially converting to this environment (from an
AIX-SP/mirrored environment) has mostly to do with the
Catherine - I passed your note along to our system administrator. One
difference is whether you are looking at software RAID or hardware RAID. We
use hardware RAID, and therefore our RAID5 experience applies only to that.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Messag
Check v$system_event to see what are the most waited for things in your
database.
You can also check v$session_wait for the wait events in sessions
coresponding to
CKPT, DBW, LGW & SMON. Find those events in Oracle reference (available
online)
and see if those guys are waiting for anything special
Sure, have one on me. :)
Jared
On Friday 09 November 2001 13:39, Grabowy, Chris wrote:
> Hmmm...doesn't that mean someone owes me a beer?
>
> -Original Message-
> From: Jared Still [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 09, 2001 4:27 PM
> To: [EMAIL PROTECTED]; Grabowy, C
My company is an Oracle Partner (from the Oracle Partnership Program, "OPP")
and damagement got an invite to a 1/2 day speel about OPP during OOW. Since
I'll be at OOW it's thought that maybe I could see if there's any OPP
opportunities we should know about. I'm skeptical that Oracle could actuall
Hmmm...doesn't that mean someone owes me a beer?
-Original Message-
Sent: Friday, November 09, 2001 4:27 PM
To: [EMAIL PROTECTED]; Grabowy, Chris
I must have been hallucinating, I can't find it now.
Here are some interesting links I came across while looking:
http://metalink.oracle.c
Thank you so much for your help. I was trying to pass 'yesterday's date'
from unix thru a cron to a package. I took Guy's advise and created a
procedure to call this pkg. It was easy and quick.
Thank you again.
-Original Message-
Sent: Friday, November 09, 2001 11:51 AM
To: Multip
I must have been hallucinating, I can't find it now.
Here are some interesting links I came across while looking:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=107487.1
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database
We have some Oracle 8.0.5 DBs on a RAID5 set on our OpenVMS server. It
works fine, but there is really not a lot of writes going to our DBs
(read-only "legacy" data). You don't mention the type of database
(OLTP/DW/Hybrid) or it's size, number of concurrent users, etc., so I'll be
generic. Writ
Jared Still wrote:
>
>
>One tool that I thought was impressive was BMC Patrol. Anything
>you could think of, it already did. Quite expensive and difficult
>to install I understand. Never got the opportunity to use it.
>
i've gotten OEM to work, mostly anyway. i never got Patrol going even
wi
Not familiar with BMC Patrol but I like I/Watch from
Quest Software. I believe they are pretty similar though,
especially in price.
-Original Message-
Sent: Friday, November 09, 2001 12:55 PM
To: Multiple recipients of list ORACLE-L
Patrice,
You're reinforcing my already low opinion
Patrice,
You're reinforcing my already low opinion of OEM.
At a previous job we had one very competent DBA that
spent quite a bit of time on OEM, and it would never
work properly.
I'm still sold on homebrew monitoring, in Perl, ksh, or
whatever you're comfortable with.
One tool that I thought
I still like the bit about the Tower Controller knowing Walt.
-Original Message-
Sent: Friday, November 09, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L
"pounder", "hell bore." & "report from hades"
sounds like an interesting place to work.
Tom Mercadante
Oracle Certified Pr
Greg,
I usually insist on that information from the development group then I can charge it
off to their budget when it expands beyond the original space.
Seriously, I build a table and indexes with init and next the DBBLOCK size and load
a controlled amount of data. That will give you a good
Hi,
We just install the custom 9i without the database option.
But Now when we want to create database using dbassist we are not
able to find the binary.
Did the location changes in 9i or there is some tool now.
Thanks
-Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
"pounder", "hell bore." & "report from hades"
sounds like an interesting place to work.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, November 09, 2001 3:05 PM
To: Multiple recipients of list ORACLE-L
Wait...so...you got the SDS stuff goingand it w
Workaround:
On the remote system (where the sequence exists) create a view:
create or replace view vSome_Seq as select some_seq.NEXTVAL from dual;
Then, you can query it remotely:
select nextval from vSome_Seq@db_link;
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To:
Hi All!
I need to calculate/estimate index size for database. In 8.0.5 I used formula from
Administrator Guide to calculate index size. Now this formula was removed because of
it accuracy (see Metalink).
Does some one has formula for 8i ?
Thanks.
Greg.
--
Please see the official ORACLE-L FA
Wait...so...you got the SDS stuff goingand it works...but
you can't tell if it's faster?
Aching for results,
etc.
-Original Message-
Sent: Friday, November 09, 2001 2:35 PM
To: Multiple recipients of list ORACLE-L
(Acually 4X10 is THE answer for us. Walt's on a 4X10-4-days-off
You just selected the next value from a local sequence called some_seq using
the dual table located on the link.
What you have to do is to select the next value from the sequence located on
the link using the dual table from the local database.
select some_seq.nextval@db_link from dual;
I tri
Title: How to get user lastname and first name when you have user logon id
Unix Guru, I'd like to get all the user lastname and first name, and I can get
the login id from the command "who /var/adm/wtmp"
Thanks
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
S
I have LOG_CHECKPOINTS_TO_ALERT set in my init.ora
file and according to my alert log they are generally
taking about 30 minutes to complete, sometimes only a
couple minutes. Does that sound right?
The database is about 20G and doesn't have much
transaction activity. It's a development database a
(Acually 4X10 is THE answer for us. Walt's on a 4X10-4-days-off weekend and
is probably flying around somewhere as I write. We have a 4X10 schedule and
we get to arrange the days to maximize our weekends. Hmmm... I was the one
who made out the schedule so how is it that Walt got the 4 day weekend?
We have been RAID 5 on Compaq Tru64 for many years now. Make sure you have a
good-sized battery-backed RAM cache. Is your system more toward the OLTP or
data warehousing type environment? We have never compared performance, but
it seems to work fine for our needs.
Dennis Williams
DBA
Lifetouch, In
There's no reason not to install the Oracle vendor software on RAID 5.
Now, where you put your database is another issue. Probably as long as
it's not an OLTP database the overhead shouldn't be an issue.
Let the RAID wars begin!!!
Is there any way to get the next value of a sequence via a db_link.
I tried
select some_seq.nextval from dual@db_link
but it told me the sequence didn't exist. I went to the database where the
sequence exists and, using the userid that is in the db_link, I was able to
get the next value, so it
NOTE.
According to Tony Jambu author of "Oracle's New Pricing, Oracle 9i Features and Some
Good Utilities" article in the 4qtr 2001 issue of Select. Page 42 (ironic about the
page number)
"The answer is 50 not 42 (for those HGTTG fans, you know what I mean)."
Just another spin in the galaxy
We use raid 5 for everything, haven't come across any problems yet.
As for performance, I am not sure, as we don't encounter the same loads
as most bigger organizations probably encounter.
We are running oracle 8.0.5, 8.1.7, on clustered tru64 4.0f connected to a
SAN (HSG80)
Darren
-Origin
-- Catherine LeBlanc <[EMAIL PROTECTED]>
> Anyone know of a reason
> why RAID 5 would not be OK for the software?
It works rather nicely if you tune the raid stripe to match
the system page (usually 4k or 8k). A 4k page works nicely
w/ 8 x 512byte chunks or 4 x 1K chunks, for example.
RAID5 w
Unfortunately, I don't think I can do that.. they query itself has a limiting
factor in the start with clause..
i.e.
start with key = (select something from
table_over_here,table_over_here2,table_over_here3,table_over_here4
where a bunch_of_stuff and x=:avaluethatchanges)
I can't make a
How about using the create_timer built-in and a when-timer-expired trigger?
Gary Kirsh
Next Extent, Inc
-Original Message-
Sent: Friday, November 09, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L
On occasion we'd like to be able to "broadcast" a message
to folks who are access
Not to mention
select this,that
:)
-Original Message-
Sent: Friday, November 09, 2001 8:36 AM
To: Multiple recipients of list ORACLE-L
I like your naming conventions :)
but shouldn't it be
from a_table_in_this_database ?
--- Jeffery Stevenson <[EMAIL PROTECTED]> wrote:
> ...and
We are in the process of reorganizing and reconfiguring of our
disk space in preparation for an Oracle 8.1.6 upgrade in production,
and my sys admin wants to use RAID 5 for the drive on which the
Oracle 8.1.6 software will be installed. Anyone know of a reason
why RAID 5 would not be OK for the s
well duh the answer to EVERYTHING is 42
--- "Orr, Steve" <[EMAIL PROTECTED]> wrote:
> OK... it's 42! Nice kitty...
>
>
>
> -Original Message-
> Sent: Friday, November 09, 2001 6:31 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Walt,
>
> but but but.. I didn't know the answer.
Hi Patrice,
For some time now we've been using RMAN, staging to disk, then using
Netbackup to backup to tape. Works fine.
Now, after a struggle, we've got RMAN backing up to tape directly via the
Veritas Netbackup MML API stuff. We have a Linux Netbackup client and a
Solaris Netbackup server an
Why not just call the stored procedure with SYSDATE - 1? I don't think
Unix's date command makes finding yesterday's date particularly easy.
g
-Original Message-
Sent: 09 November 2001 16:56
To: Multiple recipients of list ORACLE-L
Hey List,
I need to pass a value `date - 1` t
OOPS! Got the EVENT count and the SERVER count confused.
thx
-Original Message-
Sent: Friday, November 09, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L
Not 30, about half that.
That can't be a "big" setup!
What do banks and multinational coporations do, if 15 servers i
I'm sorry, I misunderstood. Were you trying to get Oracle to tell Unix what
yesterday was?
#!/bin/ksh
sqlplus << EOF
system/incredibly_secret_password_but_this_is_probably_overkill_why_not_use_
scott_tiger
select 'YESTERDAY="||sysdate-1||'"' from dual
set pages 0
set sqlprompt ""
spool date_def
I don't know about this one. A couple of months ago I would agree but
lately when I open a Metalink tar I always get a phone call. Even when I
don't really need one. I am rarely at my desk to get it but they leave
a very nice voice mail.
As much as I like to complain about Oracle Support (a
I've had no problems with TNS, dblinks, etc. The only thing to watch out for is some
monitoring
packages (can't remember which ones) read the SGA structures directly from memory.
They need to be
started from the correct memory window.
Never had the "pleasure" of MC ServiceGuard.
Ron Thomas
SET ORACLE-L NOMAIL
---
The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not c
Anyone using this combination to do their regular backups?
If yes, I would be interested in hearing your experiences.
Here we are doing colds and hots, doing incrementals would be nice.
It might make enough difference to justify the cost of purchasing those
Veritas agents.
Sorry, I am on an OE
Not 30, about half that.
That can't be a "big" setup!
What do banks and multinational coporations do, if 15 servers is a big
setup?
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent
Hi,
We r trying to install 9i on sun 2.8 and getting error :
error in writing to file
/opt/oracle/OraHome1/Apache.jdk/bin/java_wrapper
What might be the cause?
Thanks
-Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harvinder Singh
INET: [EMAIL PROTECTED
Rao ,
Thanks for taking time and the suggestion. But
obviously both Randy and you misinterpretted what I
was attempting to sayPerhaps mine was a wrong
choice of words...SO let me explainJared sorry if
I am gobbling bandwidthcyber spank me if you
want...
I have been working an a DBA for
Title: RE: session marked for kill
Could be a bunch of things. Here's one thing I noticed in a development database yesterday (8.1.7.1.1 on Windows 2000)
Stored procedure issues an "analyze table compute statistics". In the alert log there was an ORA-00600 caused by the analyze (and also a tra
Thank you so much for response to my email.
I know we can do: Date= `date` but not `date -1`.
-Original Message-
Sent: Friday, November 09, 2001 11:14 AM
To: Multiple recipients of list ORACLE-L
So long as you embed your call to Oracle within your program, the program
can pass variab
RS
It's very difficult to deal with people when you're kept s
busy and isolated! I know that I can get very focused and forget
about other people around me and their "menial" jobs when mine
is the important job since I'm the DBA!
Randy Kirkpatrick
(303)772-7467
-Original Message-
F
still, Patrice, "reboot the agents" is not the way this should be
handled.
That's very old-school Microsofty...
-Original Message-
Sent: Friday, November 09, 2001 11:53 AM
To: Multiple recipients of list ORACLE-L
Oracle Support called me, I resolved the events stuck in de-registra
KS -
what is the "size" of the environment that you are using
OEM to monitor?
Patrice has it on 30 odd servers, across several OSes, with
double digit events set...a biggish layout, methinks. Me, I'd
have a 'baby' install at first...a few instances under one
unix OS. I guess it would likely be
I agree. Too bad you have to pitch a fit these days to get that personal
communication.
"Boivin, Patrice J" wrote:
> Oracle Support called me, I resolved the events stuck in de-registration
> mode.
>
> There was a misunderstanding, they were telling me in writing that I had to
> shut down the a
So long as you embed your call to Oracle within your program, the program
can pass variables to Oracle all day long.
#!/bin/ksh
DATE=`date - 1`
DBA=`Anne Yu`
sqlplus << EOF
system/incredibly_secret_password
select $DATE,$DBA from dual;
exit
EOF
echo "Done!"
-Original Message-
Sent: Frida
Funny, I wrote a perl script to do this same thing the other day. It is a
perl script, runs under UNIX, and not only checks for defaults, but the
default Oracle passwords as well.
I was kinda proud of it, so I thought I'd pass it along. Not
Jared-Still-Perl-Evangelist quality, but I'm happy.
B
Hey List,
I need to pass a value `date - 1` to a store procedure from a shell
script.
Really appreciate if anyone can help.
Thanks,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anne Yu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-505
Oracle Support called me, I resolved the events stuck in de-registration
mode.
There was a misunderstanding, they were telling me in writing that I had to
shut down the agents on the nodes, and then remove the nodes.
I thought that meant I had to do it for ALL the nodes, not just the ones
with t
Deborah:
I don't have a script, but it should be fairly easy to create.
In pseudo-script:
For all Users
Loop
select current_password, current_profile into temp_var1, temp_var2;
alter user profile default;
alter user identified by username;
select current_password into temp_var3;
if te
Actually, I am not having any issues. My only issue
with the tool is I cannot page someone else if I don't
fix the problem but we are just going to direct the pages
to Unicenter and leave it at that. Also, you cannot
set a priority level. For example, there are times where
I just want an email
Boston, MA, Financial services company is looking for an Oracle Database
Group Manager
who MUST be a senior ORACLE database professional. The selected candidate
will report
to the Manager of Enterprise Technologies/Global Operations.
*Candidates who are in the Greater Boston area only can be con
For a second there I thought it was Cobol.
-Original Message-
Sent: Friday, November 09, 2001 5:36 AM
To: Multiple recipients of list ORACLE-L
I like your naming conventions :)
but shouldn't it be
from a_table_in_this_database ?
--- Jeffery Stevenson <[EMAIL PROTECTED]> wrote:
> ..
If you are running forms in client-server mode, then there is no easy
solution, but if you have web deployment, then you could use PJC and hook
into dbms_alert. This way, if you send a dbms_alert, you will be able to
capture it at forms and display appropriate message.
Now only if I could remembe
Bad RI? Unhandled, hanging events?
This is a tool that people use?
Boy, and i was *just* starting
to consider reviewing it again...
*sigh*..
Thanks, Patrice. Great post. Truly helpful.
ross
-Original Message-
Sent: Friday, November 09, 2001 10:10 AM
To: Multiple recipients of l
Hi Everyone,
Can anyone provide/share with me a script that will check the users
password against their username. We are trying to verify that no one is
using his/her username as the password.
Thanks for any help
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Ignore
this please. Another red herring. I give up.
I'm
off to the countryside to grow mushrooms organically
-Original Message-From: Robertson Lee - lerobe
[mailto:[EMAIL PROTECTED]]Sent: 09 November 2001
12:00To: Multiple recipients of list ORACLE-LSubject:
v$session_
Randy ,
I am sourly lacking in people's skills..thats the
point I was trying to make..(which didn't
work..Obviously..!!). When I am working 42 hours
continuously I don't have time to think about hurting
somebody's delicate feelings.
RS
--- Randy Kirkpatrick <[EMAIL PROTECTED]> wrote:
> RS
>
> Th
Rollback is one definite possibility, so is the Duhveloper shutting down the
process on his/her client machine. In either case, finding the process id and
killing that process at the Unix level will also release stuff a lot faster.
Dick Goulet
Reply Separator
On occasion we'd like to be able to "broadcast" a message
to folks who are accessing the database via a GUI forms
interface; either thick or thin client.
What are some possible ways of implementing this feature?
Since we own/write the application we are free to modify
it any way we desire.
--
OK... it's 42! Nice kitty...
-Original Message-
Sent: Friday, November 09, 2001 6:31 AM
To: Multiple recipients of list ORACLE-L
Walt,
but but but.. I didn't know the answer. I didn't even really understand
the question! PLEASE tell me the answer, please? Pretty please? Pretty
plea
Raj,
One small suggestion: If maintaining many db's leaves you with less time to
attend to the developer's questions or developers' requirements, bring up
this case to your boss. Put it to him in such a way that the company
requires another DBA. In that way, you would be doing two services in t
LOL..
What I *meant* to say was:
I must say, your posts have left me feeling kind of empty lately! :) :P
Ahh well.. It's Friday
-Original Message-
Sent: 09 November 2001 14:20
To: Multiple recipients of list ORACLE-L
I must your, your posts have left me feeling kind of empty lately
One more thing maybe it was a error on our side ...
We setup OEM to monitor all production, ACPT and development servers and
when all connections were specified, by mistake SYS user was used. Now OEM
wouldn't let me use TOP SESSIONS etc on my 9i databases saying that I must
connect as SYSDBA
FYI,
I just submitted feedback to Oracle re. their OEM 2.2. product.
So far I have had to rebuild the repository three times. With fifteen
servers, this is a major hassle. We have Oracle on NT, on Tru64 UNIX, and a
mix of versions: 7.3.4.4 (on Tru64 in the process of being upgraded) and
8.1.7
Prasad,
Is the database running on MTS mode?
Rao
-Original Message-
Sent: Friday, November 09, 2001 9:00 AM
To: Multiple recipients of list ORACLE-L
Hi,
All of us believe Oracle is the best database server.
We can keep our application data on Oracle and just
forget the rest. I strong
Huh? Jared, did your search reveal that OFS is available for platforms
other then Windows?
The white papers and doc that I read stated Windows only because it's tied
into Microsoft Cluster Server. IMHO, I think the Oracle folks took a look
at MS Cluster Server and realized that it wouldn't be
Follow up...
My SA says we you have Washington Univ version of FTP you can restrict the
users from navigating...
Is it the only way
Suren
-Original Message-
Sent: Thursday, November 08, 2001 8:30 AM
To: Multiple recipients of list ORACLE-L
Hi List,
I think, sometime back, there wa
I must your, your posts have left me feeling kind of empty lately! :)
-Original Message-
Sent: 09 November 2001 12:10
To: Multiple recipients of list ORACLE-L
__
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com
--
and chocolate obviously !!
-Original Message-
Sent: 09 November 2001 13:31
To: Multiple recipients of list ORACLE-L
Walt,
but but but.. I didn't know the answer. I didn't even really understand
the question! PLEASE tell me the answer, please? Pretty please? Pretty
please with whipped
I like your style, first it was the polar bear in the snowstorm
now we get the airline jet in the snowstorm.
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 messag
Now, that was very informative!
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 09, 2001 7:10 AM
>
>
>
> __
> Do You Yahoo!?
> Find
Hi,
All of us believe Oracle is the best database server.
We can keep our application data on Oracle and just
forget the rest. I strongly believe I can do anything
I want, with Oracle.
We have a problem with Oracle. Ours is a small
application with most hits. Lot of people will be
using our solu
Bunch of on-topic meanies, these guys are. ;-)
So, please tell the tale of the RAM disk,...what
happened...set up, surprises, percent improvements,
next steps...etc
-Original Message-
Sent: Thursday, November 08, 2001 9:45 PM
To: Multiple recipients of list ORACLE-L
Alright, I sen
Walt,
but but but.. I didn't know the answer. I didn't even really understand
the question! PLEASE tell me the answer, please? Pretty please? Pretty
please with whipped cream and TWO maraschino cherries on top?
Rachel
--- "Weaver, Walt" <[EMAIL PROTECTED]> wrote:
> Alright, I sent out a totall
Thank you Raj.
My point stands wwhether using the "old" GMT mnemonic
or the new UTC.
-Original Message-
Rajendra
Sent: 08 November 2001 19:04
To: Multiple recipients of list ORACLE-L
Actually one should use UTC ... instead of GMT for reference
Raj
_
I like your naming conventions :)
but shouldn't it be
from a_table_in_this_database ?
--- Jeffery Stevenson <[EMAIL PROTECTED]> wrote:
> ...and you created the view on the "other" side of the database link
> where
> none of the tables are remote tables? Basically, on the remote
> system you
good people skills -- you leave them smiling even when you tell them no
they can't have what they want. You are not arbitrary about decisions,
you explain WHY something won't work and offer an alternative that
will.
You smile at people, get to their work as quickly as you can, explain
delays when
__
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Prasad BAV
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
Title: RE: ORA-01720 while trying to grant select on a view
See the Metalink Note below
Subject: grant select on view with grant option
RDBMS Version: 81511
Operating System and Version: nt 4 sp 5
Error Number (if applicable): ora-1720
Product (i.e. SQL*Loader, Import, etc.):
Product Versi
__
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Prasad BAV
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
If you want the objects to end up in the same tablespaces, then the names
must be exactly the same (otherwise the default tablespace is used).
If the filesystem and layout on box x is the same as box y then the full
import will create the tablespaces using the datafile specs. in the dump file.
I have to agree - it was somewhat startling. Its the
only *ever* test I've seen where raw was not the
overall winner. Unfortunately I don't have Linux to
play with
Connor
--- Bill Buchan <[EMAIL PROTECTED]> wrote: >
> Did anyone read Bert Scalzo's article in Pipeline
> Newsletter this month
You need to:
grant select on sys.v_$instance to GCSS with grant option;
This will allow GCSS to grant select on views based on v_$instance to other
users.
- Bill.
At 01:35 09/11/01 -0800, you wrote:
>Hi DBA Gurus,
>
> I am getting the below error while trying to grant select privilege
Anyone any idea what
I am waiting for here. I know it seems obvious but I don;t know exactly
what it means. Anyone who knows about such things care to enlighten me on where
to dig next. This has been sitting like this for 2 days and I believe it maybe
at the root of the long running SQL prob
You must grant with grant option to give permission
for granting an object. I mean as sys you should:
grant select on v_$instance to gcss with grant option
And the other grant.
Regards.
--- "Ranganath, Krishnaswamy" <[EMAIL PROTECTED]>
wrote:
> Hi DBA Gurus,
>
> I am getting the below
Yes, it was because of rollback activity done it by
PMON. You needed to shutdown abort because an
immediate do rollback too.
Your case is an example of deferred transaction
recovery. After startup SMON will do the work that
PMON has left.
Regards.
--- "Daiminger, Helmut"
<[EMAIL PROTECTED]> w
Did anyone read Bert Scalzo's article in Pipeline Newsletter this month
(http://www.revealnet.com/newsletter-v2/linux2.html)? He was benchmarking
various filesystems under Linux (EXT2, EXT3, Reiser, IBM JFS and RAW). I
was suprised (and so was he) to see worst performance on RAW devices. I
Hi DBA Gurus,
I am getting the below error while trying to grant select privileges
on a view owned by a user by name GCSS to another user by name etldev:
ORA-01720: grant option does not exist for 'SYS.V_$INSTANCE'
I even granted select on sys.v_$instance to etldev. Sti
If you're using a volume manager (veritias, or disk
suite), then raw is pretty much just as easy as file
systems.
You could always do this incrementally - for example,
high io stuff (typically redo, temp, possibly
rollback) on raw, and all the rest of file systems
etc.
hth
connor
--- Vasu Ra
1 - 100 of 107 matches
Mail list logo