Arup , the procedure you gave is correct and works fine.
I tried it out on win32 with 9.2.0.1.0.
But I had to set SQLNET.AUTHENTICATION_SERVICES= (none) in sqlnet.ora
My fundamentals are really weak , so please forgive the stupid
questions : These steps create a database user who will be
authentica
That is for encypting password while tranmitting over Oracle Net, the
password itself must be entered in clear text.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 20, 2003 10:34 PM
> What about
> SQLNET.ENCRYPTION_TYPES_CLIENT= (rc
Better call Oracle support for this one.
These are references to some internal deadlocks and enqueue problems not reported in
the v$ views.
I think Steve Adams discusses this in his Oracle8i Internal Services book. Search his
web site,
you may find some more information (www.ixora.com.au).
-
Hello list
sorry to trouble you all so much,
I tried all that I stated below on another database I created, and as
long as I don't use an spfile , no problem. As soon as I start using
an spfile , I always get my backup shown as obsolete , irrespective of
the number of days (the value of n) I speci
Thanks rafiq ,
will hope that the gurus of Oracle smile upon us mortals soon.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, June 21, 2003 03:14
: Sorry, I never used RMAN so far but this point came in my mind. I am
: surprised why Rob
What about
SQLNET.ENCRYPTION_TYPES_CLIENT= (rc4_256)
SQLNET.ENCRYPTION_SERVER = accepted
SQLNET.ENCRYPTION_CLIENT = requested
SQLNET.CRYPTO_SEED = "The quick brown fox jumps over the lazy dog."
in sqlnet.ora
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROT
Got a
bit more on what they were doing.
One
really gets "scared" when Oracle wants to know what you're
doing.
Maks.
-Original Message-From: Greg Subject: RE: Oracle 9i and streaming
technology
Actually streams is a
hybrid of several Oracle technologies: Log miner (used to ho
test - please ignore
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
I am seeing WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=12 in the
alert log file?
there are no blocking locks and at this time the weblogic connection pool
cannot get connections
to the database but the client connections from sql*client gets connected
(sqlplus or toad).
What could be the pr
I agree with Dennis Williams. To know what is the right answer for you,
first you should determine why you want the table partitioned in the first
place. Is it so that you can easily "archive" old data by using the "alter
table drop partition" command? Is it so that your queries will benefit
f
Title: Message
Hello
all,
Does
anyone know if the DBMS_OBFUSCATION toolkit works with CLOB's? I have
looked high and
low and
can't find a reference other than from a third party solutions web site and they
say it
can't be
done and have to use their product.
thanks
Steve Main
Ice
Hi Beth
OK, I get your point but Arup was talking about automatic connections by
setting remote_os_authent to true where you can either set the prefix to
OPS$ or use identified externally. For these connections the user should
not be prefixed by the domain name in the database. On the other hand
u
Got this when trying to connect, guess they are on MySQL. :)
--
Could not connect to DB on 130.94.122.197
Host 'larousse.wikipedia.org' is blocked because of many connection errors. Unblock
with 'mysqladmin flush-hosts'
If this error persists after reload
Ever heard of Sealand, the "country" formed by an ex-British radio station owner who
took over an abandoned World War II military platform built off the coast of the UK
and declared it a sovereign country?
http://wikipedia.com/w/wiki.phtml?search=sealand&go=Go
> -Original Message-
> From
Yes, you are misunderstanding it. A simple statement like your will result in only
the data required being sent over the network. But if you add in a second table
things change, especially if that table is a local access table.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Origi
I haven't worked with MSAccess to Oracle stuff lately, but
it used to be that the ODBC stuff pulled A LOT of background crap in
addition to what was needed for the query. And, yes, Access did a lot
of the processing locally. The way I got around this was that I either
used passthrough queries (Ac
Ishwar
One priority might be to get to 9.2. There are reasons Oracle has given
9.0.1 a short decommission date.
One idea would be to export with a SQL statement. This would reduce the
size of your exports. Also, if you are mostly just adding new data (few
updates), you may be mostly just inte
Sorry, I never used RMAN so far but this point came in my mind. I am
surprised why Robert is not giving you a reply.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 20 Jun 2003 09:45:11 -0800
Rafiq that is a good point , but I ha
Hi all:
I have been hearing from many people that MS Access is
bad as a front-end tool because it tends to do data
processing on the clien side instead of the DB side
thus moving way too much data over the network.
Assuming that this is correct, what is the mechanism
of this? If I execute a simple
Jacques, the version is 9.0.1.1.1.
Dennis, Thanks for the confidence I totally agree with you about designing
and everything else.
Could there be a temporary solution to get successful exports until we
embark on this project.
we are in a 24x 7 environment.
Rgds
Ishwar.
-Original Message-
Seriously though, I wondered years ago at what point multinationals are
going to pick a deserted island, declare it their country, and set up their
own tax laws.
Some companies have higher revenues than countries.
Patrice.
-Original Message-
Sent: Friday, June 20, 2003 3:20 PM
To: Multip
All,
Oracle has rounded all this discussion up in Note:207959.1 'All About
Security: User, Privilege, Role, SYSDBA, O/S Authentication, Audit,
Encryption, OLS' which is a jump off point to *lots* of other Notes.
John
> -Original Message-
> From: Arup Nanda [mailto:[EMAIL PROTECTED]
> Sen
ORA-GON? Daniel, you are a genius! He could also ammend the constitution to
read
We, the PeopleSoft
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 20, 2003 4:55 PM
To: Multiple recipients of list ORACLE-L
I figured he try
> -Original Message-
> From: mike mon [mailto:[EMAIL PROTECTED]
>
> Does anyone has script which can check "grant
> privilege" on a table and generate output for future
> usage?
If you're looking for a script to show existing grants on a table, you could modify
this one (that shows exist
Bill can HAVE Mississippi, for free!!
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, June 20, 2003 4:55 PM
To: Multiple recipients of list ORACLE-L
I figured he try for something closer to home...say Oragon?
Then Bill would want to buy Mississip
Jacques,
Based on what Matt sent, I'd say your in violation of their license. You've
distributed it internally.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, June 20, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L
Thank you for
I figured he try for something closer to home...say Oragon?
Then Bill would want to buy Mississippi (postal abreviation MS for our non-us listers).
"Jesse, Rich" wrote:
>
> Oracle Makes Bid to Buy State of Delaware
>
> Software giant willing to assume state's $225 million deficit in exchange
>
Ishwar
I am fairly new to partitions myself and must relearn the commands each
time I need to work with the partitions. So I will speak more to the
philosophy of a DBA that doesn't like to end up in a jam.
I get a bad feeling about hashing to get around an immediate problem. I
also question
Thank you for the research.
When they say "Distribution for MySQL would mean more than one "copy" installed in a
production environment", by production environment, they must mean a business.
For example I can use MySQL on my home computer to keep track of my record collection,
and I can also rec
When you say 9i, do you mean 9.0.1 or 9.2.0? In 9.2.0 You can have list subpartitions.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_73a.htm#2153058
> -Original Message-
> From: Ishwar Tewari [mailto:[EMAIL PROTECTED]
>
> I created a range partition table
The version is 9i.
-Original Message-
DENNIS WILLIAMS
Sent: Friday, June 20, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L
Ishwar - What Oracle version. Just off the top of my head, I think that 8i
only allows the subpartition to be hashed. What is your goal?
Dennis Williams
DB
> -Original Message-
> From: Goulet, Dick [mailto:[EMAIL PROTECTED]
>
> Well I like both of them. Nothing like a good chuckle
> to brighten up a day.
Yes, I thought it was funny, but especially with these "official" sounding articles
you never know if it will end up being spread
Carol,
We use a 7.1 Terabytes (double Yikes!) database -
Sun 15K server, Hitachi Storage Array, RAID-5 (all except redo logs which are
RADI 0+1), 8.1.74. Some of thetables are more than 100 GB in size. However, the
datafiles are smaller, just 4 GB each. This is done to facilitate the recove
Hey Dennis:
I created a range partition table with the last high_value being maxvalue.
The partition key is partner_id (an incremental sequence).
Now pmax (the last partition) has become very big and gives "snapshot too
old.." while exporting.
Ultimate Plan
=
I realize that the ultim
No, I was talking about on file system only.
-Original Message-
Sent: Friday, June 20, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L
Does this mean that if I dd the file onto a raw partition, it will be
scattered around the raw partition? Even though the dd-ing process is
unawa
Hello list
I was having problems with my controlfile backups being reported as
obsolete ;
I have narrowed down the problem to the number of days specified in
the recovery window .
1. My control_file_record_keep_time=7
2. Suppose I start rman and there are no backups yet. (This is
confirmed by th
Nah. LarryWorld.. Will charge you to enter and exit the state. Will
over count residents to get better tax subsidies and will never discount
products to government agencies. Oh yes. Everyone must own an Armani Suit.
Thank You
Stephen P. Karniotis
Strategic Alliance Manager
Compuware Corp
Beth,
You are right in stating that OPS$ accounts are not inherently insecure.
How is teh inclusion of domain name any more secure than using OPS$?
Granted, the hacker has to guess the domain name in addition to user name,
but so is using any other prefix other than OPS$.
Besides if the users ar
(my question follows)
> -Original Message-
> From: Seefelt, Beth [mailto:[EMAIL PROTECTED]
>
> I disagree. Remote OS authentication is not inherently insecure in
> Windows like it is in Unix. If you prefix the account names with the
> domain name, a user would not only have to spoof the
I heard that Gates has a deal in the works with McDonalds to sell MS
products there. He will rename his product suite to McWindows in honor of
the agreement.
Also heard that McWindows would now come with a free hard drive called the
McDrive with two all silicone disk platters, special fire wire ad
I think with LMT's now, it is irrelevant. I still think you need to know
approx. how big the table is going to be, and place it in the correct LMT.
By this I mean that you may have different LMT's with different uniform
extent sizes. A very large table should be placed in the largest LMT
tablespa
Jacques,
Well I like both of them. Nothing like a good chuckle to brighten up a day.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, June 20, 2003 3:30 PM
To: Multiple recipients of list ORACLE-L
I hate to be a spoilsport, but some peopl
Bummer! I've already started to hope that I'll
soon be living in Connecticut ver 10i. Even Red Sox
defeats would hurt less in the Oracleland.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 20, 2003 3:30 PM
To: Multiple recipie
David,
I do feel your pain. Sometimes the auditors just go overboard looking over
some set checklist and some items in their checklist just plain contradict
each other. Take example I just went through recently.
I am making the databases of a few healthcare companies HIPAA compliant. A
recent aud
I hate to be a spoilsport, but some people unfamiliar with the USA might be taking
this seriously. This is, of course, a humorous piece, in the same vein as the joke
about Microsoft purchasing the Catholic Church
http://www.spunk.org/library/humour/sp001526.html
> -Original Message-
> Fr
that's how we do it here. there is a Lan Administration group responsible
for installing software on all PC's.
thank goodness they stay out of the DBA area. we do our own installs.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, June 20, 2003 3:16 PM
To
Any plans for the crisis countries Larry :)
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 20, 2003 12:00 PM
> Cool. State of Connecticut also has a budget crisis..
>
> Mladen Gogala
> Oracle DBA
> Phone:(203) 459-6855
>
I just got a call from the S/A that the copy completed. After looking back
at Spotlight I asked "At 1:00, right?". Sure enough. So at least that
part's solved. As to why/how it started the same time as the DBMS_JOB? I'm
willing to let that be a mystery pondered on over beers for years and year
Excellent, but I really thought he meant to call it Larry Land! :)
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long term Oracle DBA.
-Original Message-
Jesse, Rich
Sent: Friday, J
Pete,
Apprciate your comments. You are right in stating that if the OPS$ accounts
have special privs they might be abused. But how it is any different than
any other user id with special privileges whose password is not guarded
well? The security hole does not come from the fact that remote_os_aut
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 20, 2003 9:44 AM
> This is an interesting one. I am currently going through (tortured)
another
> system audit. One of the many questions the auditors (I am being attacked
> from all sid
Joe
If your administration group controls the machines to this extent, I
would hand the administrators a CD with Oracle client on it and say "go for
it", your baby now.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 20, 2
ok, so should the number of extents in a table be considered in table design? there
are alot of .pdfs and people on this listserv that say it is irrelevant?
>
> From: Rachel Carmichael <[EMAIL PROTECTED]>
> Date: 2003/06/20 Fri PM 02:44:52 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PR
Title: RE: Look's like Larry's at it again...
Yeah ... but they have money to sue everyone in sight.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD
Jin
I cured this one with STATISTICS=NONE. Inelegant, but effective
nonetheless.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 20, 2003 10:21 AM
To: Multiple recipients of list ORACLE-L
Greetings,
When I export schema
Ishwar - What Oracle version. Just off the top of my head, I think that 8i
only allows the subpartition to be hashed. What is your goal?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 20, 2003 12:00 PM
To: Multiple recipient
Naveen
Advantages of single instance
- Easier to administer. I have multiple test instances and often have to
go around getting permission to bounce instances to re-jigger the memory
when one project needs more memory for some test.
- Easier to share data among projects.
Advantages of multip
i understand, but alot of people have posted here that its ok to have smaller extents
anyway.
who is correct? or am i missing something?
>
> From: "Richard Ji" <[EMAIL PROTECTED]>
> Date: 2003/06/20 Fri PM 02:00:11 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: R
makes sence to me... I've seen an analyze, if it takes a long time to run,
cause odd things to happen to SQL that starts running in the middle of the
analyze process.
The SAN rebuild certainly sounds like a likley suspect.
RF
-Original Message-
To: Jesse, Rich; Freeman Robert - IL; 'Mu
Cool. State of Connecticut also has a budget crisis..
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 20, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L
Oracle Makes Bid to Buy State of Delaware
Software giant wil
[deft backpedaling]
OK, now I think it IS the SAN. The S/A handling the SAN is helping us with
our backup scenario so he's reorganizing some drives on the SAN. At about
the same time he started the reorg (highly drive-intensive), my aggregate
PIO rate dropped from almost 10K/s to less than 2K/s.
or reasonable to WANT? if I'm running a data warehouse, maybe. If an
OLTP system, orders and customers etc then I'm not likely to WANT the
next block of data on disk for my transaction
--- Darrell Landrum <[EMAIL PROTECTED]> wrote:
> My favorite part is
> "and all of the table's data will be sto
Hi All,
I need some help in setting up ORACLE JMS to post and read messages from
queue.I am a newbie in this and I ave gone through
the Oracle application developers guide for Advanced queuing document but it
is too exhaustive.
Does anyone have any examples,web links to get started with Oracle JM
Only in part. It's an hourly complete rebuild of a mini-warehouse table
(don't ask -- not my idea). It does do a few index creates and accompanying
analyzes of those indexes and their table at the end of the procedure. I
think this accounts for the very high PIO spikes at the end of every
DBMS_J
Does this mean that if I dd the file onto a raw partition, it will be
scattered around the raw partition? Even though the dd-ing process is
unaware of the characteristics of the raw partition?
> -Original Message-
>
> Even without stripping you can't gaurantee it will be a contiguous
>
Title: RE: Development projects: Multiple databases v/s multiple schemas
That's why my question ... do schema cross-reference ...?
If you have schema that don't need to talk to each other, one DB is still
good. If you have enough resources, then give every team on db. But that is
costly in
Oracle Makes Bid to Buy State of Delaware
Software giant willing to assume state's $225 million deficit in exchange
for
legislative control, naming rights
Wilmington, DE - Oracle CEO Larry Ellison today announced his intention to
purchase the state of Delaware for $300 million in cash and Ora
Even without stripping you can't gaurantee it will be a contiguous
section of disk space. The file could be scattered across
the file system.
Richard Ji
-Original Message-
Sent: Friday, June 20, 2003 1:12 PM
To: Multiple recipients of list ORACLE-L
My favorite part is
"and all of the t
Thanks for the clearing that up. Did you happen to get a qoute as well? :)
Just curious, does MySQL also uses CPU based and named users license?
or it is just per server?
-Original Message-
Sent: Friday, June 20, 2003 1:12 PM
To: Multiple recipients of list ORACLE-L
Okay,
I figured th
Mladen , I do not get a problem if I use :
configure retention policy to redundancy n ;
(n=> integer)
However I am having my controlfile backup reported as obsolete when :
configure retention policy to recovery window of n days ;
(n=>integer , I use 4) and my control_file_record_keep_time=7
Please
Rafiq that is a good point , but I have set
my control_file_record_keep_time=7 (which is also the default , I
think )
and recovery window is 4 days
Anything else to check ?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: F
Title: Message
SET ORACLE-L
NOMAIL
My favorite part is
"and all of the table's data will be stored in a relatively contiguous
section of disk space".
Is this even reasonable to believe, especially with any kind of
striping implemented?
>>> [EMAIL PROTECTED] 06/20/03 12:00PM >>>
Two reasons:
a) if you go into extent map blocks the
Two reasons:
a) if you go into extent map blocks then you will
suffer an overhead of at least 1 billionth of a
percent :-)
b) more seriously, its generally easier to pick up a
"rogue" table if its run into thousands of extents and
you had not intended it to. Its not a performance
problem per se,
Okay,
I figured the time had come to stop speculating about MySQL's licensing
policy and get the answer straight from the horse's mouth, as it were.
So I contacted MySQL and posed a couple of scenarios to them. Here's my
questions and their responses (my stuff is the quoted part):
"
> in all of
What was this 5am job? It wasn't an analyze was it?
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/20/2003 11:29 AM
Hey all,
I'm testing out the max I/O thruput of an IBM FastT900 using a dual
2.4GHz
w/1GB RAM on Win2K server (not my choice but it's just for tes
Hey,
Can anyone say if there is a way to breakup an existing partition into
subpartitons. The partition contains data.
Thx
Ishwar.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ishwar Tewari
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 h
It is the old argument that was made to justify one or only a few
extents. Empirically the idea does not hold up. This idea is now
classified as a myth but the Oracle docs have not caught up yet.
Allan
-Original Message-
Sent: Friday, June 20, 2003 11:20 AM
To: Multiple recipients of li
Got it . Thanks Arup .
-ak
- Original Message -
From:
Arup Nanda
To: Multiple recipients of list ORACLE-L
Sent: Friday, June 20, 2003 8:54 AM
Subject: Re: oracle authentication from
windows
AK,
The issue is not creating an id called OPS$
SYSTEM o
I know we had to run utlirp.sql when moving from 32 to 64. Not sure if this
is covered by running catproc as part of the migration.
-Original Message-
Sent: 20 June 2003 15:50
To: Multiple recipients of list ORACLE-L
Hi all,
Has anyone done the upgrade from 8.1.7 32 bit to 9.2.0.3 64 bi
Title: RE: Development projects: Multiple databases v/s multiple schemas
I understand now, but in development?? I have 13 schema that form an
application, the development is an exact replica of production RAC instance and
no one in Devl complains (well most of the times).
Raj
---
Hey all,
I'm testing out the max I/O thruput of an IBM FastT900 using a dual 2.4GHz
w/1GB RAM on Win2K server (not my choice but it's just for testing) running
Oracle 8.1.7. For one of my tests, I created the following heirarchical
query:
SELECT *
FROM MYBIGTABLE GL1
START WITH GL1.TIME_STAMP LI
I just read a .pdf by a couple of people at oracle called Stop Fragmenting and start
living where it says not worry about the number of extents in a tablespace. However in
the administrators doc it says the following:
Estimate Table Size and Set Storage Parameters
Estimating the sizes of tables
We have users who need to install the oracle 9i client on their PCs but
who aren't administrators on their machines. How do people handle this
situation?
Thanks.
Joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Armstrong-Champ
INET: [EMAIL PROTECTED]
Fat City
Title: RE: Development projects: Multiple databases v/s multiple schemas
Hi Rajendra
...
For
Example ,
There is one instance and two project on this
instance.
ProjectA and ProjectB.
beetween 10:00 am and 11:30 am , ProjectA realized via
numerious sessions
30 times wait
I might have gotten something bass-ackwards here. Please correct as needed.
"Testing?! We don't need no stinkin' testing."
> -Original Message-
>
>
> select 'grant '||privilege||' to '|| grantee ||' on
> '||table_name||';' from
> dba_tab_privs where owner = 'BUBBA';
>
--
Please se
I have not done this yet, but I did look into it.
There is one thread in the Metalink forum that I printed the number is 337111.99
(I am not sure if that is the whole number or not, it looks cutoff on the
printout). It also references doc 169426.1, which has some good info in it.
The basic idea
Since I really don't have any performance issues [2 Nodes, 2CPUs each
@1GHz, 2GB, ES45 Tru64Cluster],
I haven't been runnning StatsPack.
However I just ran two snapshots and didn't see such a wait event.
I'm sure that other people have also implemented mcpd=0 successfuly
[my 9iRAC is an Export-Im
AK,
The issue is not creating an id called OPS$ SYSTEM
on XP, but on the database. Say, you created a user called OPS$SYSTEM
as
create user ops$system identified
externally;
The XP user should be SYSTEM, not OPS$SYSTEM, to
log on to this account.
Now suppose, your os_authent_prefix
Naveen,
It depends on the deployment method to be used. In general I try to limit the
number of instances. Sure not having each project in it's own instance diminishes
some of the capabilities that you have to monitor how they perform, but all of those
instances are competing on the s
select 'grant '||privilege||' to '|| grantee ||' on '||table_name||';' from
dba_tab_privs where owner = 'BUBBA';
Note that this will get everything owned by BUBBA: tables, procedures,
packages, views, sequences.
> -Original Message-
>
> Does anyone has script which can check "grant
> pr
Greetings,
When I export schema containing some tables, I got EXP-00091 warnings. The log
is saying:
"
..
JServer Release 9.2.0.1.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
. exporting
Jay,
Just make sure that ur OS is 64-bit as well and go ahead as per the
documentation. If ur OS is HP-UX,
do not forget to set ur SHLIB_PATH and CLASSPATH as well.
Cheers
Samir
Samir Sarkar
Oracle DBA
SchlumbergerSema
Email : [EMAIL PROTECTED]
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0)
Sorry, should have mentioned that I'm on Solaris 2.8.
Thanks,
Jay
-Original Message-
Sent: Friday, June 20, 2003 10:19 AM
To: '[EMAIL PROTECTED]'
Cc: Miller, Jay
Jay,
Just make sure that ur OS is 64-bit as well and go ahead as per the
documentation. If ur OS is HP-UX,
do not forget to
Stephen Lee scribbled on the wall in glitter crayon:
> The old simple snapshot replication is OK. It's just that some of
> this later stuff makes you think they rounded up all the guys who
> have tape on their glasses and wear suspenders with their pants that
> are too short, gave them a drug to
Title: RE: Development projects: Multiple databases v/s multiple schemas
Thanx
Raj and Bahar,
Raj I
think you misunderstood my question. Or I might be misunderstanding a part of
your reply :-)
I'll
try to make my question clearer
All
the developers of a project work on the same DB
Hi all,
Has anyone done the upgrade from 8.1.7 32 bit to 9.2.0.3 64 bit? I'm trying
to determine whether it's necessary to perform any other steps than the
regular upgrade process.
Note 62290.1 seems to imply that no other steps are required, but this is
contradicted elsewhere and it's proving a
The old simple snapshot replication is OK. It's just that some of this
later stuff makes you think they rounded up all the guys who have tape on
their glasses and wear suspenders with their pants that are too short, gave
them a drug to put them in an *extra* geeky mood, gave them unlimited
amount
O'Reilly is good. Also, get yourself comanche (http://www.comanche.org). That is a gooey
tool
for setting up Apache.
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-From: Sam Bootsma
[mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2
Hi,
We end up doing it both ways at the same time. We have multiple
development instances and multiple schemas in each instance. We do this
because we are running a large ERP system and each test instance has
specific testing requirements so we end up replicating multiple instances
on the same m
1 - 100 of 125 matches
Mail list logo