You can have range scan with equality search (=) as well, if your index is
non-unique and there is no unique constraint on column.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 30, 2003 3:24 PM
> put in a "between cla
put in a "between clause" in "where clause" on appropriate columns for a range scan.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have fa
It's possible on Unix I think. But there are so many things you need to
consider.
o You won't able to use your oratab file and therefore all the scripts
Oracle
supplied, dbhome, oraenv, dbshut, dbstart etc.
o You might need to use two listeners.
But why would you want to do this? Are you tryin
On earlier (Unix) versions the SID was used to hash a value
for the shared memory segment identifier. If this still is
the case then what you are asking is _NOT_ possible. V7 even
had a length of SID restriction...but that is long gone. There
were even cases of 2 different SID's hashing to the sa
> -Original Message-
> Is it possible For 2 Databases to be Brought up on the SAME
> machine with the SAME ORACLE_SID
> from Different ORACLE_HOMEs ?
>
> If so , how ?
It would seem so. Listener setup might be a bit dicey. I might have to try
this. It seems that as long as you had se
EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 5:34 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Is it possible to copy one db to another
if the SID is different
Dear New Bee:
We do this all the
Dear New Bee:
We do this all the time, and the problem you're having is
the one that I tripped over my first time, too.
There is an important word missing from your command.
It's not...
CREATE CONTROLFILE REUSE DATABASE "TEST" RESETLOGS ARCHIVELOG
...it is ...
CREATE CONTROLFILE REUSE SET DATABA
"CHAN Chor Ling Catherine (CSC)" wrote:
>
> Hi,
>
> Qn : Is it possible to copy one database to another if the source database
> name is different from the target database name ?
>
> I need to clone Oracle Applications 11I from one machine (source
> instance:PROD) to another (target instance:TE
"Fascinating." (attrib. Spock)
Didn't know about that one.
While we're on the subject, I don't recall if anyone mentioned this, but
don't forget about updating the global_name table.
-Original Message-
Sent: Wednesday, October 09, 2002 10:40 AM
To: Multiple recipients of list ORACLE-L
Title: RE: Is it possible to copy one db to another if the SID is differ
or consider note: 174625.1
-Original Message-
From: Stephen Lee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 11:04 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Is it possible to copy
One thing to keep in mind (If I recall correctly): If you are using rman
repository, the database ID (DBID) of the copied database will be the same
as the old database. You will have to create a second schema in the
repository if you plan on backing up both the new and the old databases
using the
al Message-
From: Choudhary Rajendra (TTL_LKO)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 4:08 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Is it possible to copy one db to another
if
hi
you have to do a
alter database backup controlfile to trace on the source database
change all occurrences PROD in TEST in the created backup controlfile
the create controlfile reuse has to be create controlfile SET database
"test"
oracle note 61590.1 on metalink
g.g. kor
rdw the netherland
Hi,
Please use SET in create controlfile statement if you are going to change
the DB Name.
CREATE CONTROLFILE REUSE SET DATABASE "TEST" RESETLOGS ARCHIVELOG
thnx
Venkat
Hi,
You have to recreate the controlfile as "CREATE CONTROLFILE SET
DATABASE "TEST" RESETLOGS ARCHIVELOG". The new database name will be TEST .
Pl ensure that the old control files are deleted before recereating the
controlfile .
Regards
Rajendra
-Original Message-
Sent: W
: CHAN Chor Ling Catherine (CSC)
Subject: RE: Is it possible to copy one db to another
if the SID is differ ent
Hi
Can u try SET instead of REUSE?
CREATE CONTROLFILE SET DATABASE "T
The question of restricting users to the 'approved' applications only comes up
every couple of months...
Yes, you can use PRODUCT_USER_PROFILE but remember:
It only works Oracle SQL*Plus connections -
If you can control what your users can run on their PCs, why do you let them
have SQL*Plus?
Dear Shahid.
Yes product_user_profile will disable commands used in sql*plus.
i tried, it worked. Thanks to the guy who gave the clue
insert into PRODUCT_USER_PROFILE (product,userid,attribute,char_value)
values('SQL*PLUS','TEST','SELECT','DISABLED')
Ramana
- Original Message -
To: <[E
Shahid Malik(IT) wrote:
>
> Hi Friends,
>
> I want that user only access data from application not from sql
> prompt.
>
> Any help would be highly appreciated.
>
> Shahid.
>
Shahid,
Read everything you find in the manuals about PRODUCT_USER_PROFILE. I
think that it is documented in
THANKS
-Original Message-
Sent: Monday, June 25, 2001 1:11 PM
To: Multiple recipients of list ORACLE-L
On Jun 24, 2001 at 10:20:19PM, Shahid Malik(IT) wrote:
> Hi Friends,
>
> I want that user only access data from application not from sql
> prompt.
>
> Any help would be highly a
Title: RE: Is it possible???
THANKS
-Original Message-From: Amar Kumar Padhi
[mailto:[EMAIL PROTECTED]]Sent: Monday, June 25, 2001 1:11
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Is it possible???
if you are on 8i, then you can define rules in
On Jun 24, 2001 at 10:20:19PM, Shahid Malik(IT) wrote:
> Hi Friends,
>
> I want that user only access data from application not from sql
> prompt.
>
> Any help would be highly appreciated.
SQL*Plus User's Guide and Reference Release 8.1.7. Chapter E. Security.
Besides SQL*Plus there are so
Title: RE: Is it possible???
if you are on 8i, then you can define rules in product_user_profile for preventing users from using sql*plus.
like:
-insert into system.product_user_profile(product, userid, attribute, char_value)
2 values ('SQL*Plus', 'user', 'SELE
You can achieve this in Oracle 8i with the login trigger. You can check in
the login trigger if the application that trie to connect to the database is
an allowed one. If not, than raise an exception and the login failes.
For earlier versions you can use the product_user_profile table, but it's
n
I think you can try using PRODUCT_USER_PROFILE table.
You can disable perticular command by this table. This will only work in sql
prompt. Other applications can use commands.
-Original Message-
Malik(IT)
Sent: Monday, June 25, 2001 11:50 AM
To: Multiple recipients of list ORACLE-L
Hi
25 matches
Mail list logo