Dear Seema singh Ji
I am also looking for Same
Please do mail me if u got the result
Regards
Shailendra Singh
Nagpur
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, December 19, 2001 2:00 AM
> Hi
> Any one converte
Yep I've done this using one array only, I am attaching my java code which i
used for this purpose. I qam using Weblogic 5 with the Oracle Thin driver.
Gavin
1)My VARRAY of VARCHAR2 TYPE
===
CREATE TYPE taxonomy AS VARRAY(5) OF VARCHAR2(40);
2)My Java code:
Hi Hamid !
I hope this ud work.
Create or replace trigger cre_PK
before insert on tableA
for each row
begin
if :new.col1 is null then
select seqname.nextval into :new.col1 from dual;
end if;
end;
/
You can not use or insert statement for same table on which u r writing
Yep I've done this using one array only, I am attaching my java code which i
used for this purpose. I qam using Weblogic 5 with the Oracle Thin driver.
Gavin
1)My VARRAY of VARCHAR2 TYPE
===
CREATE TYPE taxonomy AS VARRAY(5) OF VARCHAR2(40);
2)My Java code:
Title: IFRUN60_dump_*
Hi all,
We have been experiencing this error "IFRUN60_dump_somenumber" for quite some time now. This occurs when we try to open a form through a menu that we have locally developed to support our application. MOst of the times this file doesn't even exist in the directory
read the fine manuals
you cannot import into a table that has a different definition of
columns.
--- Ken Janusz <[EMAIL PROTECTED]> wrote:
> If I use Exp / Imp utility to just extract and load data into an
> existing
> DB. If there are more columns in the input record that in the DB
> table I
Hello Gurus,
I am working on a little project using the package utl_http, so far I have
had limited success using this package.
The below http call fails for some reason, it is supposed to download a
page of size ~10K, i.e. 5 pieces of data, but instead it fails, I am not
sure why...
Any idea
Yep. According to Metalstink, its not fixed until 8.1.7.3 and that won't be
out until mid-January (I'm on HPUX). Or v9.0.2 if you like the bleeding
edge...
--Scott
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 20, 2001 11:
The Patch for 1967363 on 8.1.7.2/8.1.7.2.1 has been out for some time now.
(the patch
will not be released for 8.1.7.1 or 8.1.7.0)
I do have an 8.1.7.1 instance running and am waiting for scheduled downtime
to upgrade
to 8.1.7.2.1 + 1967363 on Tru64.
This instance is only a test environment and, y
I would beg to differ about Oracle not putting effort into data
recovery at this point in time...
especially since I know people working in the Center for Expertise who
are working on just that.
--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> I have the earlier version of Velpuri's book and fi
it tells you right there.. you first have to grant the role to KENNETH
I would suggest, as gently as I can, that you begin reading the
manuals.
--- Ken Janusz <[EMAIL PROTECTED]> wrote:
> I created the role KCJ and granted it create session, create user,
> alter
> user. Then I did alter user K
Um, that brings up another point. What are you using for
your recovery command. If you are not using the control file
you have to tell it you are using a backup control file
or it simply will never know where to end.
-Original Message-
McClure
Sent: Thursday, December 20, 2001 3:25 PM
I would suggest you use an ON INSERT trigger rather than BEFORE INSERT and
just select nextval into a variable then set :new.col1 = variable.
At 09:55 AM 12/20/01 -0800, you wrote:
>List,
>
>I need some help for creating a trigger, here is my question?
>
>I have a table TABLEA(col1,col2,col3) c
NGSSoftware Insight Security Research Advisory
Name:Oracle PL/SQL Apache Module
Systems Affected: Oracle 9iAS
Platforms: Sun SPARC Solaris 2.6
MS Windows NT/2000 Server
HP-UX 11.0/32-bit
Severity: High Risk
Vendor URL: http://www.oracle.com/
Author: David Litchfield ([EMAIL PRO
OK we had some data deleted from our production database and reporting
database that shouldn't have been deleted. We want to take from the
most recent backup the 3 tablespaces affected by the delete and the system
tablespace and restore those files to a temporary database with a backup
co
Ken - Try
GRANT KCJ TO KENNETH;
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, December 20, 2001 4:00 PM
To: Multiple recipients of list ORACLE-L
I created the role KCJ and granted it create session, create user, alter
user. T
leave windows and go to unix.
joe
Joe Raube wrote:
> I searched OTN and found this:
>
>
>http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/em.817/a85247/ch6.htm
>
>
>
> "Note:
> The Windows NT or Windows 2000 Domain User works only if the machine is
> a primary domain cont
Whoops, how did that sneak in there? Your right I usually set
sort_area_size to 10 MB on a OneWorld system, I am monitoring disk sorts and
really have not incurrered that many but this should be increased. Why do
you think retained is too big? I actually increased it. If someone uses 8
MB for
I am resolved that the trouble is not enough swap and not enough aio
processes. I think this will significantly improve the system. Spreading
swap will be my next push if I still have trouble. vmtune will be last
which is basically what I wanted to confirm.
AIX vmstat shows
kthr memory
I have the earlier version of Velpuri's book and find that it is excellent.
One thing to keep in mind is that Oracle isn't putting much effort into the
hot/cold backup & recovery recently. Therefore if your interest is in that
area, then I wouldn't wait for a new edition (your database might crash
Very briefly, we found:
a) it works fine
b) its a pain to setup since the doco (at 8i) was
scant to say the least
c) the error handling was poor, namely, every kind of
error gave a generic "An error has occurred" type of
message
So there is some short term pain, but once its done,
it works well
Ken,
You will find various iterations of the following query useful.
select * from dict where name like '%ROLE%';
You can find a complete list of the data dictionary tables in the Oracle Ref
Manual. Please check out the following link.
http://technet.oracle.com/docs/products/oracle8i/doc_librar
See if you can glean any information from
v$session_longops
hth
connor
--- [EMAIL PROTECTED] wrote: > Greetings,
> We have a third party application that has processes
> that delete millions
> of rows from a big table without a commit in the
> interim. Is there anyway
> we can monitor how many
Most of what you describe seems like it should work. One question. Why
create a control file at step 3? Did you backup a control file to a
filename, and back it up during your hot backup procedure? If so, you need
to use it to recover your database. I don't think you can create a control
file
You need to grant the role to KENNETH...
Grant role KCJ to KENNETH;
Tim
-Original Message-
Sent: Thursday, December 20, 2001 5:00 PM
To: Multiple recipients of list ORACLE-L
I created the role KCJ and granted it create session, create user, alter
user. Then I did alter user Kenneth d
dba_role_privs
-Original Message-
Sent: Thursday, December 20, 2001 4:31 PM
To: Multiple recipients of list ORACLE-L
Where do I find the roles assigned to a user? I cannot find it in the DD
views.
Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapo
Look at DBA_ROLE_PRIVS.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, December 20, 2001 3:31 PM
To: Multiple recipients of list ORACLE-L
Where do I find the roles assigned to a user? I cannot find it in the DD
views.
Thanks,
Ken Janusz, C
I created the role KCJ and granted it create session, create user, alter
user. Then I did alter user Kenneth default role KCJ. Then I went to login
at sqlplus and get this error.
>From the DD views I get:
Grantee: SYS
Granted_role: KCJ
Admin_option: yes
Default_role: no
nic13> alter user KENN
I wanted to post a summary because maybe some of you have also run into
problems with autoextent/max data file size on NT.
After a lot of hunting and gathering, I found that the 4GB limit is only
on the FAT32 file system. We are running NTFS on Windows 2000 server,
so it does not apply to us. A
You can find out what the current logfile is and then apply the previous
ones:
MIKEK:system> select a.group#,a.member,a.status,b.status,b.bytes
2 from v$logfile a, v$log b
3 where a.group# = b.group#
4 /
GROUP# MEMBER STATUSSTATUS
Ethan,
AIX performs all file i/o via the OS's virtual memory. In other words, the
VM (which is a combination of both the RAM and the Swap) is used for both
executable (OS/user code) and user's memory area as well as for I/O buffers.
This allocation is dynamic and certain upper and lower limits ar
Sam,
If you want to understand the internals of Hot/cold backup/recovery (with
case studies!) as well as the Database in general, this is an excellent
book. If you are looking for extensive RMAN-only information, then you may
be disappointed... I would certainly buy it! (already have the 7.3 as w
I searched OTN and found this:
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/em.817/a85247/ch6.htm
"Note:
The Windows NT or Windows 2000 Domain User works only if the machine is a
primary domain controller (PDC); otherwise, jobs will fail with VNI-2015
"authentication error.
Where do I find the roles assigned to a user? I cannot find it in the DD
views.
Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
INET: [EMAIL PROTECTED]
Fat C
Yes we are doing async, I checked smitty aio and the numbers were the
default, I am having the admins increase them to soemthing more along the
Oracle reccomends.
|| yesyes
64 bit yes, I assume read and write, don't know how to check that one.
|| can you do a "truss" on this OS..
By the way, those instructions to manually creating a
hot standby database came from Oracle so they should
be available online. There should be a hint in there
that would give you an idea of what you are missing
since its really the same thing except you are not staying
in recovery mode.
-O
I have a Linux server running Oracle Standart 8I, I already setup the init
file with the exclusive value to accept backup jobs, I also created a
special account with sysdba, sysoper, and dba rights and a linux account
same name password and with all rights to sysoper, sysdba and root groups.
O
I have not specifically tried what you are trying to
do recently, however, I did implement a standby database
using Trusted Oracle 7 in which you had to do it
manually. So it should work. You really do need
redo logs though. Although you do not specifically
need the ones from your other data
It sure will.
--- Ken Janusz <[EMAIL PROTECTED]> wrote:
> If I use Exp / Imp utility to just extract and load data into an
> existing
> DB. If there are more columns in the input record that in the DB
> table I am
> importing to, will Imp generate an error?
>
> Thanks,
>
> Ken Janusz, CPIM
>
SQL> select count(*), DEGREE from dba_tables group by DEGREE;
COUNT(*) DEGREE
-- --
2612 1
-Original Message-
Sent: Thursday, December 20, 2001 2:38 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Do any of the tables/indexes have parallel degreee > 1?
List,
I am in the middle of testing my backup procedures
and have come across something that I'm stuck on.
I've read through Velpuri's ver8 book and the Oracle
docs but am still having difficulties. I need to
restore an entire db from a hot backup, to another
server. The above mentioned book
I am using Oracle 8.1.7.2 on Solaris 2.8
Here is the script I am running:
===
create table testtext ( searchfield varchar(100));
insert into testtext values ('rstephenVb03R/o2Vi7Iwomigod/o/r/rstephen');
insert into testtext values ('gar
Do any of the tables/indexes have parallel degreee > 1?
Jared
"Post, Ethan"
I would agree with your assessment.
Our AIX setup was equiped with 3 swap disks. Non-mirrored plain small scsi
attached drives. When we originally just had one disk, our system would do
things simular to yours. When we performed intensive operations like
exports and imports, it would bog down
My only concern is having to upgrade PRODUCTION without being able to
upgrade test... and trading the bugs I know we have for the bugs that will
no doubt come with the new release.
-Original Message-
Sent: Thursday, December 20, 2001 2:17 PM
To: Multiple recipients of list ORACLE-L
None
Greetings,
We have a third party application that has processes that delete millions
of rows from a big table without a commit in the interim. Is there anyway
we can monitor how many rows have been deleted? Since we can't change the
code to make it commit, the easy option of 'select count(*) ' is
Yes we are doing async, I checked smitty aio and the numbers were the
default, I am having the admins increase them to soemthing more along the
Oracle reccomends. 64 bit yes, I assume read and write, don't know how to
check that one. Buffers? Db block or some other? Most non-default parms
are
None that I know of, if you have any specific concerns, I can ask my SA or
Sr. DBA
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that
The bottleneck is hdisk0 which is swap, no datafiles or anything else there.
The rest of the IO is spread out pretty nicely, archiver interferes with
redo at times but nothing I can do about it until I get some disk moved from
dev to prod. shared pool is 100M, from experience this is the right si
Error: ORA-12988
Text: cannot drop column from table owned by SYS
---
Cause: An attempt was made to drop a column from a system table.
Action: This action is not allowed
The solution seems to be 'do not create objec
I have configured various buffer sizes, the real issue has to be memory
related. So far the swap increase seems to have helped but I won't really
know to I work through some more rigorous scenarios to simulate the
conditions in place last night. From read the AIX stuff I just know it
handles mem
Ken,
This subject was discussed at some length in the past week or two. If I remember
correctly the only way and approved method is the ignore the columns and recreate the
tables as the proper owner.
ROR mª¿ªm
>>> [EMAIL PROTECTED] 12/20/01 02:15PM >>>
I have created a DB as SYS and added colum
List
after going in circles all day yesterday and getting the combined looping values in
the sum fields
of the query, I arrived refreshed and ready this am.
The answer I used was to create a view of the columns wanted from the 2 tables and
then use a UNION ALL query on the view to produce the re
Hi all,
Where can I find some articles on LDAP deployment apart from OTN and Oracle
sites? I am looking for real life experiences from users. We use Oracle 8i
and 9i.
If you have deployed it, what is your experience? Is it worth the effort?
Thanks in advance
Happy Holidays
Raj
___
more questions, no answers...sorry...
1) Are you doing async I/O?
2) full 64 bit read write or some hybrid?
3) and kind of "direct I/O" going on?
4) if (1) == 'yes', then what are buffers set to?
-Original Message-
Sorry for the cross post if you are the other big list.
I am having s
One thing that jumps right out is 50% IO waits.
You need to find out which disk(s) are so overloaded.
Analyze the stats from v$filestat to see what's going
on at the database level.
Q: Why is your SGA 2 gig, and how is it partitioned?
db_block_buffers:
shared_pool:
other pools:
Jared
Hell yes!
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
-Original Message-
Sent: Thursday, December 20, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L
If I use Exp / Imp utility to just extract and load da
Hello,
One of the DBAs here thinks that it is ok, esp. if you need material on
using RMAN (we do not).
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
-Original Message-
Sent: Thursday, December 20, 2001 1:10 PM
To:
I have created a DB as SYS and added columns to some of the tables as SYS.
When I try to drop some of these columns I get this error.
ORA-12988: cannot drop column from table owned by SYS
How can I get around this problem?
Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, I
You can set your buffer size to 1 and put commit=y into your parfile.
This may help.
Happy Holidays,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 20, 2001 1:35 PM
> Sorry for the cross post if you are the other big
Is there any way to tell this after the fact; i.e., what was the maximum number of
processes performing DML on a specific table on such and such a date?
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author
List,
I need some help for creating a trigger, here is my question?
I have a table TABLEA(col1,col2,col3) col1 is Primary Key for this table
and an application insert records into this table, but I want to write a
trigger on this table to generate primary key with using nexval of a
sequence I h
I don't have the new version of that book, but the older Oracle 7.3. version
was excellent.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Sam Bootsma [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 2:10 PM
If I use Exp / Imp utility to just extract and load data into an existing
DB. If there are more columns in the input record that in the DB table I am
importing to, will Imp generate an error?
Thanks,
Ken Janusz, CPIM
Database Conversion
Lead Sufficient System, Inc.
Minneapolis, MN
--
Pleas
Sorry for the cross post if you are the other big list.
I am having some trouble finding a solution to a problem. This is
specifically AIX related. Here is the gist.
* Any large sort or import appears to cause paging to take place. I only
say large because of the problems, in reality these ar
> I am thinking of buying Rama Velpuri's book, 'Oracle 8i Backup and
> Recovery'. Can anybody tell me if this is still considered to be one of
> the best Oracle Backup and Recovery books available? Before buying the 8i
> version of this book, can anybody tell me if there is a 9i book available?
>
FYI
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
-Original Message-
Sent: Thursday, December 20, 2001 11:22 AM
To: '[EMAIL PROTECTED]'
Scott,
The cache buffer chains issue, I'm pretty sure that I've seen that on
67 matches
Mail list logo
