I have it running on AIX 4.3, we didn't have much problems though ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
Erik - I would assume that underneath Oracle is creating an index. One thing
to check is the SORT_AREA_SIZE for your database. If it is the default
(64K), then building an index can take a long time.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent:
Hello DBAs,
This procedure outlines how to establish a standby
database on the same server as the production database. However, it naively
assumes that extended production downtime is a non-issue!
Is it possible to establish a standby database on
the same box as the production database
You are learning the hard way. NEVER, NEVER, NEVER create tables in
Oracle by exporting from MS Access via ODBC. Access creates non-SQL
compliant objects. To access these tables you will need to select
Field, Field from Table Name; using the exact spelling and case as
displayed in Access. To
For what operating system?
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO |
Ah,
but check 10/5-16/1582 for Oracle. That is when the Gregorian calandar was
adopted. 1752 is just for England (I believe).
Henry
-Original Message-From: Robertson Lee - lerobe
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 19, 2001
12:09 PMTo: Multiple recipients of
Yep I got one.
...JIM...
[EMAIL PROTECTED] 12/19/01 6:50:18 AM
Did anyone get an e-mail from Palladium Consulting lately?
Just wondering where they got my e-mail address.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
--
Please see the official ORACLE-L FAQ:
Check
the definition for COMPROBANTES_RECORDand
the SELECT statement.
You
have one extra column AGENCIA in the record which is not in the
SELECT..
Yuval.
-Original Message-From: Ramon Estevez
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 19,
2001 2:13 PMTo:
For what it is worththe largest datafile I have created on a NTFS
partition has been 10gig...not sure what the max is, would be interested to
know.
I think the max size for FAT is 4 gig. Not sure though.
thanks,
C-
-Original Message-
Ashley
Sent: Wednesday, December 19, 2001 9:16
I other words the table names are case sensitive. But the issue you are
running into is this:
You currently try and receive an ora-942
select * from tablename;
When you should do:
select * from TableName;
MicroSoft products (whether access or sql server) will cause this. Good
Stephane ,
Thanks for the reply.
I tried using a join function and I got the sum(data) I wanted but it listed the date
twice, Once for each table select. In your reply you mentioned a percentage
calculation problem.??? I think the sums are wrong because they get summed for each
occurance
No undocumented features to become troublesome?
-Original Message-
Sent: Wednesday, December 19, 2001 1:43 PM
To: Multiple recipients of list ORACLE-L
I have it running on AIX 4.3, we didn't have much problems though ...
Raj
__
Thanks
Yuval
that worked
!!!
Regards,,
Ramon E.
Estevez
[EMAIL PROTECTED]
Dominican Republic
809-565-3121
-Mensaje original-De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]En nombre de Yuval ArnonEnviado el:
Wednesday, 19 December, 2001 2:51 PMPara: Multiple recipients of
Try this:
select sid from v$session
where audsid=(select userenv('sessionid') from dual);
- Kirti
-Original Message-
Sent: Wednesday, December 19, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L
Hi
How do find own session id?
Thanks
-sEEMA
Are you submitting the job as the perfstat user?
Tim
-Original Message-
Sent: Wednesday, December 19, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L
Daiminger, Helmut wrote:
Hi!
I created a new job in a database:
variable jobno number;
begin
dbms_job.submit
Post,
Actually I did try. database was opened successfully, but when I query
dba_data_file, all the files are disabled. (RBS from recover status to
disabled, other files from read/write to disabled ) From that point, I
stoped (I don't have time) I am waiting somebody else to tell me.
Joan
Ron Rogers wrote:
Stephane ,
Thanks for the reply.
I tried using a join function and I got the sum(data) I wanted but it listed the
date twice, Once for each table select. In your reply you mentioned a percentage
calculation problem.??? I think the sums are wrong because they get summed
Here's what I use. Shows above and below HWM. I have another one for
partitioned tables. Hope this works for you.
declare OP1 number :=0;
OP2 number :=0;
OP3 number :=0;
OP4 number :=0;
OP5 number :=0;
OP6 number :=0;
OP7 number :=0;
free_blocks number :=0;
cursor object_cursor is
Why not just:
select sid from v$session
where audsid= userenv('sessionid');
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 19, 2001 3:50 PM
Try this:
select sid from v$session
Tom,
At first, he said, no, he had checked that, but (as we know often happens),
he rechecked and saw that a higher level calling procedure was set at the
smaller size. So your suggestion did lead to the solution.
Thanks!
Marc Perkowitz
- Original Message -
To: [EMAIL PROTECTED]
Cc:
Way much better :)
Thanks. I forgot about mystat view..
- Kirti
-Original Message-
Sent: Wednesday, December 19, 2001 3:12 PM
To: [EMAIL PROTECTED]
select distinct SID from v$mystat;
Deshpande, Kirti wrote:
Try this:
select sid from v$session
where audsid=(select
After installing Oracle Financials Application 10.7 char on HP-UX 11, we
observe that there are strange characters are printed on first page of
Report printed through application. If same is printed through unix lp
command same are not printed.
So where to look and fix that. For comparison
The base release is 8.1.7[.0.0]
Applying patchsets change the 4th number, eg 8.1.7.1, or 8.1.7.2
The 5th number is reserved for port (ie OS) exceptions, fixes specific to each
platform.
On platforms like Unix, individual patches on top of the patchset can be applied
(relinked) without
Both of these work, but are inefficient for repeated frequent use by
an application:
select sid from v$session where audsid= userenv('sessionid');
select sid from v$mystat where rownum = 1;
This is the most efficient:
select ksusenum from x$ksumysta where rownum = 1;
You need to be SYS or
-Original Message-
Sent: Wednesday, December 19, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L
Why not just:
select sid from v$session
where audsid= userenv('sessionid');
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list
Jeremiah Wilton wrote:
Both of these work, but are inefficient for repeated frequent use by
an application:
select sid from v$session where audsid= userenv('sessionid');
select sid from v$mystat where rownum = 1;
This is the most efficient:
select ksusenum from x$ksumysta where
If it's a simple 'alter table enable constraint' then it's not
building an index, and doesn't even require one on the
child table.
Jared
DENNIS WILLIAMS
Title: Weid exp/imp problem
You
may need to use consistent=y on the export to ensure that the view for the
entire export run is from one snapshot in time. If your application is
busy changing data during the export, then as export moves through the list of
tables (alphabetically I think)
Oracle exports sequences in the full or user(e.g. owner=scott)level exports.
I would run 'strings' command to scan the dump file to make sure the
sequences are there (strings exp.dmp | grep -i sequence). If those are not
there, then the export was probably done at table level.
If the sequence
Thank you for your answer. The proble I have is NOT export. I checked
export log and found sequence actually export, but on import (user mode)
it did NOT create 'sequence.
From: Deshpande, Kirti [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
I heard that! We got bit on 8.1.7.1 by a 'Cache Buffer Chains' latch
contention bug (bug 1967363) that is not fixed until 8.1.7.3 or 9.0.2. The
releases are supposed to be out in January, IIRC.
--Scott
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Does anyone has the similar experience?
I plan to write a stored procedure to return 3 arrays.
It works fine in the database.
But if I call it from Java codes, I got tons of
errors.
(the JDBC drivers is from Web Logic, not from Oracle).
It would be wonderful if anyone is willing to share
the
Hi ALL,
I am using direct path method of SQL *Loader. I am
testing for a data file of 1 records. Here when I
test at onsite there was one bad file generated with 1
bad record. My log file showed rows loaded
properly and 1 record not loaded due to data errors.
When I check the count of
Hi,
I am trying to assign a default value for a column from my sequence and
i am unable to do that. How do you give it in the control file?
Thanks in advance.
Regards
Sundar
Mercadante, Thomas F wrote:
IA,
like this:
( col1 char ,
col_seq test_seq.nextval
)
where test_seq is a
101 - 134 of 134 matches
Mail list logo
