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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
') 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.net
--
Author: Arup Nanda
INET
Yes. As long as your KEY_STRING is same, the
encrypted value will be the same.
Consider:
SQL exec :i := rawtohex(utl_raw.cast_to_raw
(dbms_obfuscation_toolkit.DES3Encrypt (input_string='12345678',
key_string='123456789012345678901234')))
PL/SQL procedure successfully
completed.
SQL
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
it?
http://www.amazon.com/exec/obidos/ASIN/0972751394/qid%3D1073685823/sr%3D11-1/ref%3Dsr%5F11%5F1/104-5146136-6379164
Six months of hard work gotta deserve something
better than the recyclebin, I sincerely hope.
Regards,
Arup Nanda
- Original Message -
From:
A
You haven't specified the Oracle version. If it's
9i, you could use Fine Grained Auditing (FGA) to get the exact
SQLs.
Hope this helps.
Arup
- Original Message -
From:
Mauricio Vélez
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 29, 2003 1:39
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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network
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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Title: RMAN - the time has come
In addition to the Freeman book, I would also
suggest the RMAN Pocket Reference from O'Reilly. It predates the RF book and
certainly comes handy for learning - I learned from there.
HTH.
Arup Nanda
- Original Message -
From:
Jamadagni
sure you do the
same for any local indexes, too.
HTH.
Arup Nanda
- Original Message -
From:
NGUYEN Philippe (Cetelem)
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 22, 2003 10:34
AM
Subject: Exporting a partition with
transport tablespace
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
(or Standby, in 8i), IMHO.
HTH.
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 11:54 PM
Hello!
What do you think of additional backup method as multimaster replication?
Isn't it a way
-article,
or send email to [EMAIL PROTECTED] and
include the word subscribe in either the subject or body.
Friday, November 14, 2003, 1:04:25 AM, Arup Nanda ([EMAIL PROTECTED])
wrote:
AN Jonathan,
AN This is explained by a quark in the way partitioning works, especially
in the case of range
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
a feel for it? If you like it then you can think about
installing it in house.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 10:44 AM
List:
I have been asked by management to investigate HTML DB
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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
e time which partition to use; it uses a KEY
iterator.
I am not sure if the facility provided by
Oracle to query a partition directly is due to the above situation, but it helps
there, nevertheless.
HTH.
Arup Nanda
- Original Message -
From: "Jonathan Gennick" [EMAIL PROTECT
those will not get into SYSTEM
tablespace.
Perhaps I should mention here is that I also conduct database security
audits for corporations. But unlike your auditors, I tend to follow the
advice up with more detailed information :)
Arup Nanda
www.proligence.com
- Original Message
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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
') 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.net
--
Author: Arup Nanda
INET
or pointers will be
highly appreciated.
Thanks.
Arup Nanda
Use
pl/sql block with execute immediate 'create table as
...'
Number of rows should be in sql%rowcount (immediately after execute
immediate).
Waleed
-Original Message-From: Arup Nanda
[mailto:[EMAIL PROTECTED]Sent: Friday, November 07, 2003 3:34
PMTo
.
Thanks.
Arup Nanda
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
, November 07, 2003 4:20 PMTo:
Multiple recipients of list ORACLE-LSubject: Re: Getting Number
of Rows in CTAS across DBLinkArup,
Any chance there will be an index on the table?
Daniel
"Arup Nanda"
[EMAIL PROTE
?
Daniel
"Arup Nanda" [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/07/2003 12:34
PM Please respond to
ORACLE-L
To: Multiple recipients of
list ORACLE-L [EMAIL
.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 12:04 PM
refresh - for
Arup,
I really appreciate your answer in great details. I got on prebuilt
table
work. Thanks a lot for your help. Here is another
the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
of normal views
and hence you can create as many indexes as you like to improve access plan.
The only downside I can think of, and it is pretty minimal, is increased
time spent on index maintenance - be it in a fast refresh or complete one.
But the cost is marginal compared to the benefit.
HTH.
Arup
Another thing you can try is using PL/SQL native compilation. It's certainly
faster in CPU intensive operations and encryption is a great candidate for
it.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, October 26, 2003 12:29 PM
one.
Hope this helps.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 24, 2003 12:34 PM
refresh - for
Hi Arup,
This is a very good method. I would like to use it to modify some of my
data loading procedures. Here
download it from OTN or from my website (www.proligence.com/downloads.html).
Be sure to download both the paper and the presentation.
HTH.
Arup Nanda
- Original Message -
From:
Michael
Kline
To: Multiple recipients of list ORACLE-L
Sent: Friday, October 24, 2003 7:34
the ON PREBUILT
TABLE clause for Oracle to use QR.
HTH.
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 24, 2003 9:24 PM
refresh - for
did i read that correctly that create table as is superior to a
materialized
. This will eliminate the authentication of the user
by Windows. This model has been in use on a different app here and works
great; but on the other app, the manager insists on one authentication on
Windows and then another on the database, hence single signon.
HTH.
Arup Nanda
www.proligence.com
are used in such a way. One example is if you see some benefit from
Query
Rewrite, you may want to create the MVs on the tables using the ON
PREBUILT
TABLE clause for Oracle to use QR.
HTH.
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list
Could it have some special characters in the name?
Try "cat *" instead.
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Thursday, October 23, 2003 6:49
PM
Subject: how is it possible
This happening with me 3 rd time on this hp
Johan,
Perhaps Sean Hull's article on Oracle Technology Network will help. Awesome
article!
http://otn.oracle.com/oramag/webcolumns/2003/techarticles/hull_php.html
Hope this helps.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent
for
the
default 40 setting for the parameter. In DW, however, the chances of BBW
are
low, hence a higher setting may be possible.
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 5:19 AM
Tim
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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network
, when I restart the instance and want the hit
ratio to look good :)
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 3:39 AM
Hi all,
when you would consider to put a table a cache...
rgds
gb
are
low, hence a higher setting may be possible.
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 5:19 AM
Tim,
Can you sum up a few situations when the need *has* arisen to change these
values?
Cheers
Binley,The
cause of Buffer Busy Waits (BBW) is not exclusively the setting of PCTUSED and
PCTFREE; they just two of the causes. To understand the connection, let me
explain a little bit on the cause of BBWs.When a session requests some
data element from a table, the server process of the
Or just use NULL as a return predicate in FGAC; it will be the same effect,
but may be slightly better.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 9:49 AM
I'm using that predicate in FGAC functions so
the instance and want the hit
ratio to look good :)
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 3:39 AM
Hi all,
when you would consider to put a table a cache...
rgds
gb
: 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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services
Siddharth,I will offer a slightly out-of-the-box
solution. Please read it through till the end to determine its applicability in
your case.It seems yours refresh interval is once a day and you don't
mind stale data for a max of 24 hours. You also refresh is complete, not
incremental. So, I
and that can wait.
Increase the value of the timeout or, just use an exception handler on the
commit statement to retry.
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 11:49 AM
Hi List,
We have a job
://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from
sessions starts.
HTH.
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, September 13, 2003 3:09 AM
Dear Friends,
ed command in SQLPLUS( on UNIX ports )not working. I hope there is some
EDITOR setting to use VI
Standby which works on a mechanism Other than
Log-shipping?
Please give
detail
Thanks
-Original
Message-From: Arup Nanda
[mailto:[EMAIL PROTECTED] Sent: Thursday, September
04, 2003 12:35
AMTo: Multiple recipients of list
ORACLE-LSubject: R
=spfile sid='lahiri' ;
This properly set the value for the SID lahiri, not globally. That is why
the RESET operation was successful after the SET operation. The same is true
for any other parameters that is reset.
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list
/nanda2.html.
Hope you will find it useful.
Best reagrds,
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 03, 2003 12:29 PM
Okay, we have a request for quite a few of our customers for read-only
copies
: The listener has not recognized the password ,
which could mean as simple as a fat fingered DBA or repeated attempts to
break in. As a rule of thumb, I scan TNS-01169 errors and review them
periodically.
HTH.
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients
.
Is that always true ?
Can the spfile be opened ?
can you kindly explain me ?
Thanks Regards,
Prem Khanna J.
02-09-2003 04:14:26, Arup Nanda [EMAIL PROTECTED] wrote:
Does the entry even exist in the SPFILE? Open up the spfile in
notepad
and
check the existence of the parameter in there. Do
Title: Oracle Enhancement Request System
Raj,
The new enhancement system is inside Metalink now.
When you want to open an ER, just open an iTAR, but in the drop down field named
Type of TAR, choose "Enhancement Request".
Thanks.
Arup
- Original Message -
From:
Jamadagni,
Tom,
You should perform backups from the Standby
database, regular RMAN backups, no need to shutdown the database. Make sure you
backup the archived log files from there too. Contrary to what the docs might
_imply_, I use the word "imply" rather than "state", since the docs have been
kind
assuming
there will be felicatations for Arup and Mogens at this time... (and Thu
ends it all).
I have the following that have responded (in no particular order): Arup
Nanda, Jonathan Gennick, Matthew Adams, Brian McGraw, Ari Kaplan, Cary
Millsap (+ other Gurus - Cary brought along Tom Kyte
be opened ?
can you kindly explain me ?
Thanks Regards,
Prem Khanna J.
02-09-2003 04:14:26, Arup Nanda [EMAIL PROTECTED] wrote:
Does the entry even exist in the SPFILE? Open up the spfile in notepad
and
check the existence of the parameter in there. Do the following:
SQL alter system set
the kernel.
Regards
Pete
-Original Message-From: Arup Nanda
[mailto:[EMAIL PROTECTED]Sent: 30 August 2003
00:30To: Multiple recipients of list ORACLE-LSubject:
Re: get sid (session id) and serial#?
Oracle officially "desupported" the package in
8
') 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.net
--
Author: Arup Nanda
INET
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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
.
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 01, 2003 4:24 PM
mastered at ORC1.WORLD
Hi list
I am using Oracle 9.2.0.1.0 enterprise on windows.
I am going thru the examples provided in Replication
DBMS_REPCAT.CREATE_MASTER_REPOBJECT (
gname = 'hr_repg',
type = 'TABLE',
oname = 'departments',
sname = 'hr',
use_existing_object = TRUE,
copy_rows = FALSE);
END;
/
--- Arup Nanda [EMAIL PROTECTED] wrote:
Before you create the Materialized View Group, you
must create the REPGROUP
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
: 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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services
may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
Title: Message
Oracle officially "desupported" the package in 8i;
but then included (by mistake?) in 9i. In 8i, however, you could pester your
friendly neuighborhood Support Analyst to give you the package. You could try
from 9i sources, too; but not sure if they work.
Arup
-
Walter,
Unfortunately, there is no way. You can prevent
root from connecting as sysdba by removing the dba group from root userid; but
hey, root can "root" it again; he is root, remember, omnipotent.
Even if that is successful, he can connect
toany dba account, such as "oracle" using "su
Title: Message
Better yet, put the following lines
echo ORA-600 [kgfdjjks] [scdcsc] [dssdcdcsdc] [45]
[999] Unauthorized root access
then print some garbage into a file named like the
regular trace files in user_dump_dest directory. Open up a iTARand show
this "trace" file to your SA's
Tanel,
That's a cool tip! Thanks.
Arup
- Original Message -
From:
Tanel
Poder
To: Multiple recipients of list ORACLE-L
Sent: Thursday, August 28, 2003 4:54
PM
Subject: Re: How to keep "root"
out?
As an alternativefor setting
Sai,
You may want to check bug# 1188948; it sounds like your
case.
HTH.
Arup
- Original Message -
From:
Sai
Selvaganesan
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, August 26, 2003 9:04
PM
Subject: materialized views
hi
materialized
://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from
. By the way, it's Arup, not Arun :)
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 11:44 AM
Arun, thanks for suggesting this, this is what i did.
1. created a table to store table names
=
On Sun, 24 Aug 2003 16:24:36 -0800, Arup Nanda [EMAIL PROTECTED]
wrote :
This is a multi-part message in MIME format.
Rahul,
I'm not sure if this is too late; but here is a strategy you could
follow
to achieve what you want. True, VPD does not have a mechanism to suppress
columns
think it will work nice for your purpose. Please let us know the devlopment at
your side.
Hope this helps.
Arup Nanda
www.proligence.com
- Original Message -
From: "rahul" [EMAIL PROTECTED]
To: "Multiple recipients of list ORACLE-L"
[EMAIL PROTECTED]
Sent: Sunda
NO!
Never move a data dictionary table out of the
SYSTEM tablespace; or do any kind of operation on them. The only tables that can
be operated on - particularly DELETEs and TRUNCATEs, are AUD$ and FGA_LOG$ (in
9i).
Besides, how would moving SOURCE$ table from SYSTEM
tablespace help? The
Now that's one place M$ is way ahead of Oracle,
with easy do-it-yourself "become any user" privilege!
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Monday, August 25, 2003 1:55
PM
Subject: Re: Hey Jared
Wasn't from
Title: Re: system tablespace at 50 pct_increase in 9i?
Tim, WebIV? I must have skipped a generation; I
used the OraSupport forum on CompuServe before the MetaLink. You had to
subscribe to CompuServe; and it was accessible only through dial-up; so we had
dial-up lines at our desk, had to buy
? Are there known bugs/problems with one version
that are not present in the other?
Daniel Fink
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
don't
want to use SYSTEM for this, you could create a special user and grant only
that system privilege directly to it.
Hope this helps.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, August 17, 2003 9:09 PM
Tim / Peter
, 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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City
Prasad,
You can use SKIP_UNUSABLE_INDEXES=Y as an import parameter. But then again,
why do that? Why not just impirt with INDEXES=N and then rebuild the indexes
in parallel and with NOLOGGING?
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
You are welcome. Another role that has the CREATE ANY DIRECTORY system priv
is the IMP_FULL_DATABASE. In addition the users of Intermedial MDSYS,
CTXSYS, etc, have that privilege too. you should watch out for those roles
and users.
Arup Nanda
- Original Message -
To: Multiple recipients
; and be very cautious while granting CREATE DIRECTORY privilege,
too.
HTH.
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 10:59 AM
Resending this email, hoping for a reply this time.
Date
Two things to check immediately:
(1) Is the Oracle service defined as started automatically in the services?
(2) If yes, is there any error reported in alert log of the database?
Import does not shut the database down.
HTH
Arup Nanda
- Original Message -
To: Multiple recipients
n
context attribute you can use any way you want to use. Right now you can use it
for FGAC; but later when you are in 9i, you can use it in other cooler features
such as Fine Grained Auditing.
HTH.
Arup Nanda
www.proligence.com
- Original Message -
From:
[EMAIL PROTECTED]
To
Technically possible, but prpbably not practical.
You have to create several views for each of the users; possible - but may
become unmaintainable. FGAC may be a btter maintanable option, IMHO.
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list ORACLE
,
it is better from the performance point, too.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, July 27, 2003 4:19 PM
Hi!
This is probably too kludgy or simple-minded, or non-maintainable, but
is
it technically possible?
1
trigger will trigger
this role setting event; could you elaborate on that?
I really HTH.
Arup Nanda
www.proligence.com
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Sunday, July 27, 2003 8:59 PM
Subject: Re: Set Role in Tr
Joe,
You can certainly use the doamin account; we do it all the time.
I am not sure why the TAR said this - but I can take a guess - generally the
domain users are not privileged enough. Oracle recommends using the
Administrator account to install anything for that reason.
HTH.
Arup Nanda
Sure, just set the following (assuming 9i)
SET SQLNUMBER OFF
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 12:44 PM
Greetings all,
I've set up my login.sql so that my prompt shows my username the sid
I suggested using SET SQLNUMBER OFF. This sure works in SQL*Plus 8i and
above; not sure if it does in 8.0.6 and I don't have a test executable to
test it. But have you tried it?
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July
-- +++
SQL -- continuation of a SQL command
SQL select *
2 from dual where 1 = 2 ;
aucune ligne sélectionnée
SQL set sqlnumber off
SQL select *
SQL from dual where 1 = 2 ;
aucune ligne sélectionnée
-Original Message-
From: Arup Nanda [mailto:[EMAIL PROTECTED]
Sent: mardi, 22
the SPfile.
SQL create spfile from pfile;
(8) And, please let us know here if they worked. If any error occurs, copy
and paste the error here.
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 17, 2003 11:19 AM
Hi,
I really
Development.
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 17, 2003 10:24 AM
In an attempt to enhance security, we set up one role which is a default
and
has only select privileges on tables and another role
://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing
(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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
1 - 100 of 316 matches
Mail list logo