Try this:
alter database rename global_name to test;
-Original Message-
Sent: Monday, September 24, 2001 2:24 PM
To: Multiple recipients of list ORACLE-L
Ok, this is 8.1.6 no patches applied on solaris.
Global Names = false
No db_domain name set
Altered the global names in the database
Can you be more specific? I am curious also. When
I create a link to a database on 'xxx' it comes out 'xxx.cj.com' which is
correct but I began looking around and I don't see how it is working. In
our initxxx.ora file we have 'db_domain = WORLD'. In the sqlnet.ora file
we have
#NAMES.DE
1 2:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: database link questions
>
>
> Ok, this is 8.1.6 no patches applied on solaris.
> Global Names = false
> No db_domain name set
> Altered the global names in the database and get
> test.us.oracle.com
Ok, this is 8.1.6 no patches applied on solaris.
Global Names = false
No db_domain name set
Altered the global names in the database and get test.us.oracle.com still and still
get us.oracle.com extenstion of the link.
Where else do I look or do? This will be a private database link.
Thanks
Kat
The extension on a database link is always the domain of the database it is
created in.
HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 21, 2001 6:16 PM
> I try to create a database link named Custom, it ends up as:
>
I try to create a database link named Custom, it ends up as:
Custom.us.oracle.com when I query the dba_db_links table.
I don't want the .us.oracle.com extension.
What can I do, where does this extension come from? Global Names?
I see that my global name is TEST.US.ORACLE.COM
Do I need to alter
I am evaluating SharePlex and I have some questions:
In the current release, do the foreign key constraints need to be disabled
in the target database? Doesn't it take a while to enable the foreign keys
during failover?
How did you handle switching the users over to the target database?
using
> normal
> upgrade procedure. I must upgrade to base line release first(8.1.7.0.0)
> and
> then patch needs to be applied. Since patch was already applied, my only
> option
> could be to recreate the catalog database in 8.1.7.1.0 and then DO THE
> FULL
> IMPORT. My
upgrade to base line release first(8.1.7.0.0) and
then patch needs to be applied. Since patch was already applied, my only
option
could be to recreate the catalog database in 8.1.7.1.0 and then DO THE FULL
IMPORT. My questions would be:
[1] Do I need to do the FULL IMPORT of the catalog database? and
g
> normal
> upgrade procedure. I must upgrade to base line release first(8.1.7.0.0)
> and
> then patch needs to be applied. Since patch was already applied, my only
> option
> could be to recreate the catalog database in 8.1.7.1.0 and then DO THE
> FULL
> IMPORT. My
already applied, my only
option
could be to recreate the catalog database in 8.1.7.1.0 and then DO THE FULL
IMPORT. My questions would be:
[1] Do I need to do the FULL IMPORT of the catalog database? and then issue
the
"upgrade catalog" command twice to upgrade the catalog to work with
applied. Since patch was already applied, my only
option
could be to recreate the catalog database in 8.1.7.1.0 and then DO THE
FULL
IMPORT. My questions would be:
[1] Do I need to do the FULL IMPORT of the catalog database? and then
issue the
"upgrade catalog" command twice to u
Forgott to mension Oracle verson, 8.1.7.1.3 on a Windows 2000 advanced
server
/Jonas
-Ursprungligt meddelande-
Från: Cale, Rick T (Richard) [mailto:[EMAIL PROTECTED]]
Skickat: den 17 augusti 2001 12:08
Till: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Ämne: RE: Two (probably simple) questions
What version of Oracle are you using?
Function based indexes only work in EE.
Rick
-Original Message-
Sent: Friday, August 17, 2001 6:46 AM
To: Multiple recipients of list ORACLE-L
p
Hello folks!
I need to create a function based index, but when I do this, Oracle gives me
the message
Hello folks!
I need to create a function based index, but when I do this, Oracle gives me
the message ORA-00439, function not installed, so I have tried and tried to
figure out how to install this function, but I have failed, therefore this
e-mail. I have looked in ORACLE_HOME/rdbms/admin and rea
Tom,
Thank you for your answer - it has solved my problem.
At 05:11 2001.08.16. -0800, you wrote:
>Zsolt,
>
>The correct call for the function if the function exists within the package
>would be:
>
> Insert into A
> ( Select Col1 ,PackageName.MyFunction(Col1)
> from B );
>
>Tom
Zsolt,
The correct call for the function if the function exists within the package
would be:
Insert into A
( Select Col1 ,PackageName.MyFunction(Col1)
from B );
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, August 15, 2001 6:44 PM
To:
1. No.
2. I do not think its a function of the number of words. DDL needs the
Execute Immediate.
3. Don't Know. Need to see the function.
-Original Message-
Sent: Wednesday, August 15, 2001 5:08 PM
To: Multiple recipients of list ORACLE-L
Hi,
1.Can I rollback after doing a truncate
> 1.Can I rollback after doing a truncate table (it seems to me
> that I can' t)
The truncate command is DDL (like create) and not DML (like delete). All DDL commit
work as part of their processing. So if you did some work before issuing a truncate
command and then tried to rollback after the
Hi,
1.Can I rollback after doing a truncate table (it seems to me that I can' t)
e.g.
Execute Immediate 'Truncate Table '|| TablaNevTomb(i);
Execute Immediate
'Begin '||
'Insert into '|| TablaNevTomb(i) ||' (Select * From
X$_'||TablaNevTomb(i)||');'||
ent by: cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
[EMAIL PROTECTED] Subject: Temporary tablespace
questions...
the high water mark of a datafile, meaning the highest data block ever
used you wont be able to shrink it down.
drop the temp tablespace and recreate it during a slow time.
joe
> [EMAIL PROTECTED] wrote:
>
> Hi all...
>
> I've searched thru the archives, but didn't find what I was
> lo
Title: Temporary tablespace questions...
Hi all...
I've searched thru the archives, but didn't find what I was looking for. I have a database with a huge temporary tablespace. It's huge because the there is value for max_extent... now I can fix that, but my problem
You need to detirmine what you are looking for before ANY of those questions
can be answered.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence OCP MCSE MCP A+ RAPTOR
[EMAIL PROTECTED]]
> Sent: Wednesday, August 01, 2001 11:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Evaluation questions
>
>
>
> Chaim,
>
> That could work. Logminer wasn't around when I first had this problem,
> and I
> haven&#x
CTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Evaluation questions
>Date: Wed, 01 Aug 2001 12:15:51 -0800
>
>
>
>
>
>
>
>"Hillman, Alex" <[EMAIL PROTECTED]> on 08/01/2001 02:16:
velopers.
Rachel (today it is hot and humid here, and today the AC in the office
doesn't work killing duhvelopers is looking like more and more fun)
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject
the AC in the office doesn't work killing duhvelopers is looking
like more and more fun)>From:
[EMAIL PROTECTED]>Reply-To:
[EMAIL PROTECTED]>To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>>Subject: RE: Evaluation
questions>Date: Wed, 01 Aug 2001 07:
e fun)
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Evaluation questions
>Date: Wed, 01 Aug 2001 07:51:19 -0800
>
>
>
>
>
>
>
>
>"Rachel Carmichael" &l
iple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Evaluation questions
>Date: Wed, 01 Aug 2001 07:51:19 -0800
>
>
>
>
>
>
>
>
>"Rachel Carmichael" <[EMAIL PROTECTED]> on 07/31/2001 11:48:02 AM
>
>Please respond to [EM
Mark,
mark,
Yep, it ain't a walk in the park... as I said. I've been thinking/working on
this for a number of years, haven't found a solution yet.
The problem with taking so many snapshots is that I am afraid that they will
affect performance.
I don't do easy questio
lots of good info directly on the desktop.
Rachel
>From: "Gary Weber" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Evaluation questions
>Date: Tue, 31 Jul 2001 06:11:36 -0800
>
&
ot;
Having said that, Q Diagnostics was indeed bliss... I fixed locks before
users complained, was able to model and monitor bad SQL and fix it and had
lots of good info directly on the desktop.
Rachel
>From: "Gary Weber" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
&g
NOW you tell me 2 jobs later!
>From: Scott Shafer <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Evaluation questions
>Date: Tue, 31 Jul 2001 12:12:04 -0800
>
>Rachel,
>
>Y
;Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: Evaluation questions
> >Date: Tue, 31 Jul 2001 10:47:28 -0800
> >
> >Also, please keep in mind that some applications will "select for
> >update...&
CTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Evaluation questions
>Date: Tue, 31 Jul 2001 10:47:28 -0800
>
>Also, please keep in mind that some applications will "select for
>update..." and lock a
Rachel Carmichael wrote:
>
> And blamed me. Apparently I should have been able to stop this from
> happening (locking and rollback segments filled to capacity of the
> tablespace) by magic. I KNEW I should have brought the fairy dust that day.
>
> Rachel
either that, or dusted the fairy.;-)
all?
Sigh... but it's fun to try to solve on a boring day.
Rachel
>From: "Mark Leith" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Evaluation questions
>Date: Tue, 31 Jul
bad SQL and fix it and had
lots of good info directly on the desktop.
Rachel
>From: "Gary Weber" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Evaluation questions
>Date: Tue, 31
does that affect it all?
Sigh... but it's fun to try to solve on a boring day.
Rachel
>From: "Mark Leith" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Evaluation questions
>Dat
Rachel,
You are right, I have not seen a tool that does this as standard either,
though I think there could be a way of doing this with our particular
product, that I will look in to - but I have a couple of questions:
In a real world situation - what would the timeframe be for a user to update
fixed.
>From: "O'Neill, Sean" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Evaluation questions
>Date: Tue, 31 Jul 2001 02:25:49 -0800
>
>I'm still slogging away at sel
er2 but not the SQL that is doing the
blocking. That's useful in beating duhvelopers about the head in order to
get the code fixed.
>From: "O'Neill, Sean" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROT
ead in order to
get the code fixed.
>From: "O'Neill, Sean" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Evaluation questions
>Date: Tue, 31 Jul 2001 02:25:49 -0800
>
>I
I'm still slogging away at selection process of DB monitor tool. I'm now at
stage where I'm compiling a list of specific tasks I'd like to take the
contenders through and score them on same.
E.G.
Can package alert if Oracle DB goes down?
Can package alert if Control File extends?
I'd appreciate
Rachel & folks, fyi:
--- Forwarded message follows ---
...
> This is the summer of Win2000 and Developer6i/Oracle8i training &
> I went "nomail" for vacation a while ago (and then family sick
> leave when my kids, 3 years and 7 years old, got summer
> colds/asthma), and didn't go back o
ED]>
Date: 7/19/2001 1:55 PM
nah, this was a LONG time ago... and we had all sorts of other fun to deal
with with the licenses too. but it's a thought
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
nah, this was a LONG time ago... and we had all sorts of other fun to deal
with with the licenses too. but it's a thought
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re:re: [Questions
Rachel,
You can always do as a local firm around here does, namely byt a server
license, enjoy the year of support. And then some years later when you decide
to upgrade to the next version, buy that license, in the new version, all over
again. Seems rather foolish and costly, but then they
Eric,
Where you been Welcome back.
>
>Be aware that if you do not pay for continuing support, and then you
>later (years later) decide you need a suport contract again *for the
>platform you started on*, Oracle has been known to retroactively
>charge (at a percentage at least 50%?) for the y
Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Questions about Oracle World Wide Support"Chuan Zhang" --
>
> From: "Chuan Zhang" <[EMAIL PROTECTED]>
> Date: Sun, 15 Jul 2001 10:00:30 +1000
> Su
Title: RE: Questions about Oracle World Wide Support
Chuan,
Without a support contract you better hope that you can get yourself out of every single recovery disaster that can possibly happen. If your data isn't important, then don't purchase a support contract. If you know
Wednesday, July 18, 2001, 9:06:20 PM, Chuan Zhang wrote:
CZ> What are the benifits of having a support contract?
All joking aside, I wouldn't want to manage a database
without having a support contract. With support, you have
something to fall back on when you can't solve a problem
yourself. With
Dear DBA gurus,
Could I ask you about the following
questions:
What are the benifits of having a support
contract?what are the issues withnot having a support contract or what the
risks do I have to take without the Support?What is it covering? I
mean, Does it cover issues involved in
Maybe the list can have a crack at these.
Jared
-- Forwarded Message --
Date: Mon, 9 Jul 2001 18:16:02 +0300
To:
1) Oracle dba admin guide(ch-7) that comes as pdf format under 8.1.6 oracle
documentation cd talks about using these parameters for tuning archiving
(LOG_ARCHIVE
n site, Dharminder.
-Original Message-
Sent: Monday, July 09, 2001 1:15 PM
To: Multiple recipients of list ORACLE-L
Hey all,
I am looking for some books/web sties containing questions/problems related
to SQL, PL/SQL I am looking for this information so that the a newcomer to
Oracle can enhan
www.cramsession.brainbuzz.com/cramsession/oracle should be a useful
information site, Dharminder.
-Original Message-
Sent: Monday, July 09, 2001 1:15 PM
To: Multiple recipients of list ORACLE-L
Hey all,
I am looking for some books/web sties containing questions/problems related
to SQL
Hey all,
I am looking for some books/web sties containing questions/problems related
to SQL, PL/SQL I am looking for this information so that the a newcomer to
Oracle can enhance his/her skill in oracle by solving these
problems/questions. I already know one such book Oracle PL/SQL Programming
Monday, July 09, 2001, 11:30:20 AM, Ron Smith wrote:
SRL> We are trying to replace a VB program with SQL*Loader. Two Questions. The
SRL> input file contains record types. A type 1 header record contains data that
SRL> must be retained and combined with a type 3 record. Also, dependi
ts of list ORACLE-L
We are trying to replace a VB program with SQL*Loader. Two Questions. The
input file contains record types. A type 1 header record contains data that
must be retained and combined with a type 3 record. Also, depending on the
record type the data is loaded into different t
We are trying to replace a VB program with SQL*Loader. Two Questions. The
input file contains record types. A type 1 header record contains data that
must be retained and combined with a type 3 record. Also, depending on the
record type the data is loaded into different tables. Is all this
We are looking to hire an SAP Systems Analyst. Can anyone suggest some
good questions/answers specific to SAP? I have seen lists of Oracle
interview questions so I was wondering if anyone has seen any on SAP?
Or, if you just know some good questions/answers, please send them to
me. Thanks
TED]>
Sent by: cc:
[EMAIL PROTECTED]Subject: Questions for Oracle creation
& Backup
Dear Sir/Madam,
We will migrate Mysql to Oracle soon. Now I have some questions.
1. We have 5 databases in one instance in Mysql. Do we need to create 5 databases
in Oracle, or only one? We have to start 5 instances and assign
different sizes of RAM to them If we create 5 databases.
2. How
You need to create preferences to specify storage parameters like:
begin
ctx_ddl.create_preference('storage_small','BASIC_STORAGE');
ctx_ddl.set_attribute('storage_small','I_TABLE_CLAUSE','tablespace
LOBADM_01_SMALL_DATA');
ctx_ddl.set_attribute('storage_small','K_TABLE_CLAUSE','tablespace
LOB
Title: RE: Intermedia Questions, Any Gurus on This Subject?
Hi Vicky,
You need to create a preference to define the storage clause with CTX_DDL. I did this at a former employer and I don't have the scripts handy, sorry to say. The documentation does go over this in detail. Yo
Intermedia Questions, Any Gurus on This Subject?
>
> Help anybody, version 8.1.6.3 on UNIX
>
> 1. Storage clause of an intermedia index build. How
> to specify the buffer pool to KEEP or CACHE the index?
>
> 2. How to specify the tablespace for such a DOMAIN
> index.
Help anybody, version 8.1.6.3 on UNIX
1. Storage clause of an intermedia index build. How
to specify the buffer pool to KEEP or CACHE the index?
2. How to specify the tablespace for such a DOMAIN
index. When put in tablespace clause, says its invalid
option for domain index.
Thanx
=
V
AIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED]Subject: EXPORT questions
hi
What is diffrent between the full export taken by sys user and system user?
Why people prefer the system user to take full export?
If any one can take full export with sys user in FGAC case then how to
import incase of recovery means from sys user itself likefollowing command.
imp userid=sys/c
om
>my home. I think this is something to do with Proxy settings.
>
>Please check if you can change proxy settings/ try alternate solutions.
>
>-- Krishna
>
>
>>From: "Viraj Luthra" <[EMAIL PROTECTED]>
>>Reply-To: [EMAIL PROTECTED]
>>To: Multi
y alternate solutions.
>
>-- Krishna
>
>
>>From: "Viraj Luthra" <[EMAIL PROTECTED]>
>>Reply-To: [EMAIL PROTECTED]
>>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>>Subject: Re: OCP Model Questions
>>Date: Mon, 04 Jun 2001 00:1
technicians - http://www.BSALERT.org)
...
> Please check if you can change proxy settings/ try alternate solutions.
...
> > >I have compiled some model questions for OCP DBA Test at
> > >http://www.oraref.com (mirrored at
> > >http://smart_and_handsome.tripod.com/o
j Luthra" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: OCP Model Questions
>Date: Mon, 04 Jun 2001 00:10:21 -0800
>
>
>the url does not work
>
>
>On Sun, 03 Jun 2001 22:10:45
>
lease check if you can change proxy settings/ try alternate solutions.
-- Krishna
>From: "Viraj Luthra" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: OCP Model Questions
>Date: Mo
the url does not work
On Sun, 03 Jun 2001 22:10:45
Krishna Kakatur wrote:
>Hi All,
>
>I have compiled some model questions for OCP DBA Test at
>http://www.oraref.com (mirrored at
>http://smart_and_handsome.tripod.com/oracle.html).
>
>If you have more, I will be hap
Hi All,
I have compiled some model questions for OCP DBA Test at
http://www.oraref.com (mirrored at
http://smart_and_handsome.tripod.com/oracle.html).
If you have more, I will be happy to add them to the Web Page.
-- Krishna
I'll try to answer these;
You can uncatalog any archivelogs you have removed without using rman. This
will accomplish what you wish. But for the future, try to an rman
archivelog backup with the delete option. This put the archivelogs in a
backupset and then deletes them. Rman know right where
hi listers ...
1/ i had to delete archived logs before i could back them up thru rman ...my
? is how do i notify rman that these logs no longer exist ... do i
crosscheck (mark as expired) all previous logs and then issue a complete
resynch ... or do i just resynch ... or ?
2/ i am changing the ar
My boss has to prepare a report for our board about change management and
asked me to look at some documentation of PVCS ERP change manager. Have
any of you ever used this product and what are your opinions of it.
TIA.
Lisa
* Lisa Yates[
I have had good luck with Red Hat Linux 6.2 and Oracle 8.1.6.1 for Linux.
You don't need
to do any upgrades to Linux before installing Oracle, you don't have to
download your own Java virtual machine, and you don't have to install any
Oracle patches to make it work (as I had to with Oracle 8.1.5).
I'd even give latitude to someone who might not know everything, but who has a basic
understanding and will logically and carefully research a problem as opposed to
hacking away at it until he/she figures it out.
>>> [EMAIL PROTECTED] 03/22/01 12:13PM >>>
Gosh I keep mine hush-hush. It is at
Title: RE: Re[2]: Couple of questions
Gosh I keep mine hush-hush. It is at the very bottom of my resume... Yes I have it but so what? I didn't claim to know a whole lot about backup and recovery until a couple of months ago when I actually had resources and time to PRACTICE.
Yes,
Someone coming into where I work with only their OCP as their claim to fame will
most likely not get an interview whereas someone with a number of years Oracle
experience will. We were pretty badly burned in the recent past by someone who
had their OCP as their sole claim to fame. This particula
True, but it probably looks good on a resume!
-Original Message-
Dandekar
Sent: Thursday, March 22, 2001 11:02 AM
To: Multiple recipients of list ORACLE-L
> Also for those who have Oracle certification how much database experience
> (Oracle in particular) did you have before you obtaine
> Also for those who have Oracle certification how much database experience
> (Oracle in particular) did you have before you obtained certification?
> What do you recommend for experience before attempting certification?
OCP and Good Oracle DBA are not one of the same things. There might
be peop
On Thu, 22 Mar 2001,Donald Bricker scribbled on the wall in glitter crayon:
->Is anyone running Oracle 8.1.6 on Solaris 8? Any problems? Anything to be aware of?
yup, no problems so far. however this is not a large database nor mission
critical. YMMV.;-)
--
Bill Thater Certifieabl
Is anyone running Oracle 8.1.6 on Solaris 8? Any problems? Anything to be aware of?
Also for those who have Oracle certification how much database experience (Oracle in
particular) did you have before you obtained certification?What do you recommend for
experience before attempting certificatio
Actually, two questions here:
1. I have a dynamicly-built query that will be
executed using dynamic sql:
select Z, (select y from tableA t1 where
t1.id=t2.id) X
from tableA t2;
To get the value from the query, I use:
dbms_sql.column_value( theCursor, 1,columnValue
For MTS experienced users;
I am installing 8.1.7 on Digital Unix (compaq).
Received the following error when I tried to create
an instance. ORA-600 ( 16305). Metalink says that
its a failure from the init.ora parameters but nothing
more.
Appreciate any help.
Steff Gonos
=
**
Thanks for all the information Greg. One more question. What's an oracle names proxy? I thought names was going away entirely in 9i.
Chuck Hamilton
"Nelson, Greg" <[EMAIL PROTECTED]> wrote:
Failover information in Oracle Internet Directory (OID) is entered like Net8configuration information. Yo
Failover information in Oracle Internet Directory (OID) is entered like Net8
configuration information. You can import the exact information that is in
your TNSNAMES.ORA into OID, so if you can code failovers in TNSNAMES.ORA you
can put it in OID as well. So you would handle failovers using OID
I'm considering the switch from Oracle Names to Oracle Internet Directory. One feature I liked about names was the dynamic discovery. Does dynamic discovery also work with OID? For example if one of my databases fails over to another machine in it's cluster, the names server is automatically update
I had no feedback on this one.
There must be some datawarehousers on this list.
Hi,
I'm currently testing the Oracle 8i new
datawarehousing functionnalities. Are you using
materialised view for aggregate dimension ?
The second question is what do you do with yes/no
flags. They can be put in
]
> > Sent: Friday, February 23, 2001 1:32 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: questions: security on the unix
> >
> >
> > DBAs
> >
> > Whis is right security for oracle datafile. 640 or 777 or others.
> >
> > I found
All the datafiles of oracle shall have 640. That is -rw-r-.
Owner of the files will be oracle and the group shall be dba.
The users access and updation of all the oracle files
are controlled by oracle only as per the
profile of the individual oracle user.
Manoharan
[EMAIL PROTECTED]
--
Hi,
I'm currently testing the Oracle 8i new
datawarehousing functionnalities. Are you using
materialised view for aggregate dimension ?
The second question is what do you do with yes/no
flags. They can be put in the fact table or they can
be put in a profile dimension. Is there another way ?
Th
Oh Mitchell,
You have to set s-bit permission should be 6755 --something like that.When
user updates a record he is ultimately writing to datafiles.At that time
he should assume as file-owner.That means only thru sqlplus or thru some other
application only he can write to the file,Neither he ca
>
> Thanks Brian.
>
> It is very strang. I have two database on 2 nodes.
>
> db1, one instance all 640 for datafile.
>
> db2 2 databases. that I have change the test database for 640. the error
> message said the datafile premittion error.
> owner is oracle:dba
>
> Mitchell
>
>
Are you s
on College
> [EMAIL PROTECTED]
>
>
>
>
> > -Original Message-
> > From: Mitchell [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 23, 2001 1:32 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: questions: secu
601 - 700 of 717 matches
Mail list logo
