hi winnie,
it got me errors like..* IMP-00015: following
statement failed because the object already exists:* IMP-00017: following
statement failed with ORACLE error 1119:"CREATE TABLESPACE
"ROLLBACK_DATA" DATAFILE'G:\ORANT\DATABASE\RBS1ORCL.ORA"
..* IMP-3: ORACLE error 1536
How about using export and import...
Looks like easiest way
-Original Message-
Sent: Thursday, May 03, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L
Hi all,
Do you have a handy way or some scripts to create a
schema which is identical to an existing schema (has
Is there a list dedicated to using PL/SQL and/or Java with Oracle?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
Hi Gurus !
Is there any standard method to encrypt data? We are making an application
that uses application-level privilege system, so we should store passwords
for users. Of course we want to store encrypted passwords, but we don't know
if is there an existing way for this or try develop own
Hello
Does anybody know what the following ora 600 relates to,
ORA-00600: internal error code, arguments: [15212], [1], [], [], [], [], [],
[]
Wed May 2 20:51:16 2001
Errors in file /opt/oracle/CRMVAN01/admin/udump/crmvan01_ora_29802.trc:
ORA-00600: internal error code, arguments: [17090],
I think you have taken a full database export from 8.0.4 and you have created the
database and other necessary datafiles. when importing a full database export, u need
to only have the database created with system tablespace and when u import the same,it
will create the datafiles and also the
Andor, Gyula schrieb:
Hi Gurus !
Is there any standard method to encrypt data? We are making an application
that uses application-level privilege system, so we should store passwords
for users. Of course we want to store encrypted passwords, but we don't know
if is there an existing way
Interesting. Thanks a lot.
80Mb.
Cheers
Nuno Souto
[EMAIL PROTECTED]
http://www.users.bigpond.net.au/the_Den
- Original Message -
We found out that if we flush the shared pool once a week , we don't
get
this error.
What is size of your shared_pool ?
--
Please see the official
I was wondering if Oracle ever considered incorporating PGP into their
databases.
I don't know much about the different types of security (e.g. Kerberos
etc.), though, so maybe that idea doesn't make any sense.
: )
Is it not possible for people to write password encryption procedures in
8.1?
I'm a bit suss on ignoring them. The mem
in use from glance doesn't increase.
Might be a side effect of something else?
Dunno, it's got me stumped. Been happening
since we moved from 8.0.5.2 to 8.0.6.0.
Maybe I should just slap on the 8.0.6.2 patch?
Going back to 8.0.5 is no option, not
We do daily exports, but our largest
table is not that large. And they all
complete, no errors. Heaps of tables, though.
Also, this is 8.0.6. I'd expect the darn thing
to be fixed by now! Thanks for the info.
Cheers
Nuno Souto
[EMAIL PROTECTED]
http://www.users.bigpond.net.au/the_Den
-
It doesn't surprise me that they are focusing on Windows2000 as a platform.
Even while one part of IBM was trying to market OS/2, other parts of IBM
only wanted to support Windows95... and the CEO couldn't make up his mind.
Finally OS/2 became largely irrelevant, it is still fighting to stay
I would like to hear about this as well, we will be migrating to the new
version this Summer.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch |
Hi List
Is there any way of receiving an e-mail or sms , whenever a ORA- error
appears in the Oracle Alert Log, or when something unexpected happens to
the Oracle Instance ?
TIA
Saj
--
Sajid Iqbal
Database Team Leader
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
you can always go with the UNIX crypt() function. That works
pretty well
;).
And what colud we use on WinNT?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andor, Gyula
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
Helmut
When you tune views you have to keep in mind how you select from the view - you
may tune perfectly the select statement that builds the view but when you select
from the view the query may be very slow. When you run select * from myview
the performance may be much different than select
Nechama,
I do a level 0 or level 1 and then do archivelog current and then backup my
archivelogs. I have been able to do point-in-time and ordinary recovery
using this plan. This makes a complete set of backups. Further, we put them
on tape each day and store a complete set for recovery.
drop table emp;
create table emp(
EMPNO number primary key,
FIRSTNAME VARCHAR2(30),
SURNAME VARCHAR2(30),
PASSWORD CHAR(32),
PHONE VARCHAR2(32)
);
create or replace trigger emp_encryptpassword
before insert or update of password on emp
for
Depending on your application you can actually create your own
partitioning. For example, we have a database here where we create
a new tablespace and tables every month to deal with that months
data. We have some set views that combine certain months together.
I would say that if you can
ORACLE-L,
In SQL PLUS, I had this problem when I tried delele a table,
delete linha_prodt;
delete linha_prodt
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
for solve this, I droped the table, but the problem ocurred again.
I had this problem only in this table at the
Deepender Kr Gupta schrieb:
Hi All !!
I have a DBA question. Can we make a DB link for nonoracle databases ! The
answer is
'YES' , I know. But How.
The documentation says you will have to use Oracle
hetrogeneous services. There is no explaination any
further.
I want my Oracle
thank you ruth
Nechama Glasrot
Oracle DBA
Seisint, Inc.
6601 Park of Commerce Blvd.
Boca Raton, Florida 33487
nglasrot @seisint.com mailto:[EMAIL PROTECTED]
Direct 561.999.3977
Main 561.999.4400
Fax 561.999.4695
-Original Message-
Sent: Thursday, May 03, 2001 8:31 AM
To: Multiple
There is a program (AUTOMAIL) which sends an email to anyone you idntify
when there is a change in a file. Look at it . It is attached .
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 03, 2001 3:00 PM
Hi List
Is there any way of
Hi
Can anyone please tell me the formula to calculate
physical memory required for the system if size of the
database is known. The size of database I am going for
is 1 terabytes. The number of users are 70 it is a
dataware house server. I am going for 8 CPU's . Now i
want to know the physical
Jared,
I agree, The online redo logs should never be restored back onto a system
that is otherwise running. But the intent is to make a hot backup that could be
restored to a completely blank system, which I believe was being done here. In
that case you need the online logs if for nothing
Hi
Can anyone please tell me the formula to calculate
physical memory required for the system if size of the
database is known. The size of database I am going for
is 1 terabytes. The number of users are 70 it is a
dataware house server. I am going for 8 CPU's . Now i
want to know the physical
Gyula,
Assuming your not on a version or Oracle that supports DBMS_OBFUSCATION you
can try the following package. It's actually been copied from a Metalink doc.
create or replace package encrypt as
function code(inp_data varchar2, key varchar2 default 'your desired value')
return
I wonder how can I cache a table other than
creating it with the cache option.??
Bunyamin K.Karadeniz Database
Group / Information Systems Department HAVELSAN Ankara
/TURKEY Tel : +903122873565 / 1681
Mobile Tel : +90 535 3357729
The OCI stuff used to be part of the programmer option in the client
installation. I don't recall which of the client installation choices
include this, though I know that the full installation does.
Ron Morton
Database Architect / Administrator
Union Switch Signal Inc
[EMAIL PROTECTED]
I am configuring multithreaded server configuration of
an WIN2000 Advanced server with Oracle 8i Rel3 EE.
All the parameter are set accurately and checked the
MTS configuration through loopback and see connection
entries in v$circuit accordinglybut when we
connect through some other PC it
I am configuring multithreaded server configuration of
an WIN2000 Advanced server with Oracle 8i Rel3 EE.
All the parameter are set accurately and checked the
MTS configuration through loopback and see connection
entries in v$circuit accordinglybut when we
connect through some other PC it
alter
table table_name cache;
HTH
Mark
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin
K.KaradenizSent: Thursday, May 03, 2001 03:31To:
Multiple recipients of list ORACLE-LSubject: HOW TO CACHE THE
TABLE??
I wonder how can I
The best way for you to see Oracle Installation Guide specific to your
platform where they have guidelines to calculate memory requirment. However
you may go for between 2 to 4GB depending whether your application is using
parallel querries which requires a lot of memory...
Regards
Rafiq
Hi,
(I apologise for cross-posting, but we are totally stuck ...)
Our Environment:
Oracle 7.3.4 database (on Solaris)
Forms 6.0.8
Citrix 1.8 Metaframe (on Win NT/2000 sp1)
We get 'ORA-06508 PL/SQL: could not find program unit being called' errors
on a regular
Which RDBMS is more ANSI SQL compliant, Oracle or MS
SQL Server?
I have some frustrated SQL Server developers that only
understand how to write inner and outer joins using
SQL Server's syntax. Don't DB2, Informix and Sybase
use the same method of defining joins as predicates?
Just curious.
Let say you have my_procedure1 (param1 IN VARCHAR, param2 OUT VARCHAR);
In procedure2 code you could write:
PROCEDURE my_procedure2 AS
par_1 VARCHAR2(10) := My Test;
par_2 VARCHAR2(5);
BEGIN
my_procedure1(par_1, par_2);
DBMS_OUTPUT.PUT_LINE(par_2);
-- etc
END;
HTH
Title: monitoring listener.log
Hi and
thanks to" Danisment Gazi Unal (what does it mean ?)"
Here
is the script :
#!/bin/sh
# This script make 2 things :
# 1- archive alert files
# 2- search "ORA-" in alert.log file
# if error is found , send an email to adresses passed in parameters
#
#
Bunyamin,
Would you please send a copy of the attachment directly to me, since the list does not
allow binary attachments. Or if there is a URL where I can download or get more info,
please e-mail that URL to the list.
Thanks,
Sivaram
Bunyamin K.Karadeniz [EMAIL PROTECTED] 05/03/01
Zabair
I have no idea of argument 17090 but 15212 appeared on our database last
week. We have HP-UNIX 11.0.32 with 8.1.6.2. If you check on metalink
it says something wrong with PL/SQL code with undetermined reason.
You may check on metalink with your complete error code.
Regards
Rafiq
A developer has an after update on table_name for each row ... trigger which
sends mail via the UTL_SMTP package. If the triggering statement is something like,
update saltab set dba_salary = dba_salary * 1000, and the resultant value is too
large. The mail is not sent. However, if the
Claudia,
They don't cause any more fragmentation than any other data type, but then
today I would not store them inside the DB, I'd be more tempted to use the BFILE
way.
Dick Goulet
Reply Separator
Author: Casas; Claudia [EMAIL PROTECTED]
Date:
I get the exact same message every time and the procedures always work and there are
no invalid objects in dba_objects. I think you can safely ignore the message. I have
no idea why it comes out, hopefully someone else can spread some light on that.
[EMAIL PROTECTED] 05/03/01 11:56AM
I
Oweson,
Check MetaLink for Doc # 1626.997.
It might help !
Srini Chavali
Oracle DBA
Cummins Inc
Oweson Flynn [EMAIL PROTECTED]@fatcity.com on 05/03/2001
10:51:12 AM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
You are missing a newline after the / at the end of the procedure.
Pat
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Pat Hildebrand
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego,
something amazing just happened.
I logged an iTar without delay. It was easy.
An analyst picked it up within 15 minutes and
sent me a i've got it mail.
If this keeps up on a consistent basis, I am
in grave danger of developing a positive opinion
of OWS.
figured i'd share the good news,
Probably this has been posed million times, but I
really like to know. We'll have a meeting about this
in our company, and I'd love to contribute someting.
Any idea on the following issue, any link, paper, etc,
will be greatly appreciated.
pros and cons of
1. Oracle vs Sybase
2. Unix vs NT
Suggestions anyone?? I'm attempting to get a standby database to run in
managed recovery mode, so that the archived logs
are automatically applied, however, when running the command 'recover
managed standby database' I receive the following error message:
SVRMGR recover managed standby
Walt,
RTF SQL Reference M. I recall seeing a pretty good
section in there about ANSI SQL92, and Oracle's superset
of it.
Also the Concepts Manual
hth
Ross
|| -Original Message-
|| From: Walter K [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 03, 2001 12:41 PM
|| To: Multiple
Check out BLOBs. They're stored externally. Can be tough to work with
but also can be very worthwhile.
Regards,
David A. Barbour
Oracle DBA,OCP
Casas, Claudia wrote:
Do you recommend storing images in an oracle database or just storing the
directory path to them instead. Somebody told me
I think it's as simple as no carriage return on the end of the last line
(I'm assuming it's the ';' character).
Cheers
Iain Nicoll
-Original Message-
Sent: 03 May 2001 17:27
To: Multiple recipients of list ORACLE-L
I get the exact same message every time and the procedures always
Siv,
Check out all the email tools available at:
http://www.freedownloadscenter.com/Email_Tools/
Regards,
David A. Barbour
Oracle DBA, OCP
Siv Chelakkara wrote:
Bunyamin,
Would you please send a copy of the attachment directly to me, since the list does
not allow binary
Sounds strange. I'd be curious at what values the a similar trigger would
show if you captured :old and :new.
Henry
-Original Message-
Sent: Thursday, May 03, 2001 12:35 PM
To: Multiple recipients of list ORACLE-L
R.I.
A developer has an after update on table_name for each row ...
Hey DBAs for big databases,
Would you mind running this simple query? I am building a case
that we have an extremely unheathly application, and would like
to (a) do a reality check, and (b) anonymously cite evidence from
other sites.
col name format a35
col min format 999
col max format
Jared,
I think you hit the nail on the head when you said Best practice of
course is to make a backup of your database in it's current condition
prior to restoring it.
Too many recoveries are failures because DBAs tend to forget basics when
confronted with the pressures from management,
In each case, it's good versus evil...
[EMAIL PROTECTED] 05/03/01 01:36PM
Probably this has been posed million times, but I
really like to know. We'll have a meeting about this
in our company, and I'd love to contribute someting.
Any idea on the following issue, any link, paper, etc,
will
briefly:
our choice was oracle/NT, based mainly on division/corporate direction which
was based on the strengths of oracle. widely installed, industry leader,
robust platform.
NT was a no-brainer; the majority of our knowledge is NT. price and
complexity were considered also, even though you
Jared,
Amen to that. Wonder how many of them have even taken the wrapping off the
book?? :-)
Dick Goulet
Reply Separator
Author: Jared Still [EMAIL PROTECTED]
Date: 5/3/2001 10:17 AM
DIck,
Totally agree. I just wanted to make sure that the
Man, I had to laugh with this one. And I really need it because I have
been in the middle of a downtime. Got paged at 3:30am. I only went to
bed at midnight so I am a little punchy right now
-Original Message-
Sent: Thursday, May 03, 2001 10:46 AM
To: Multiple recipients of list
Under Oracle Financials:
NAME minavgvar max
--- -- --
opened cursors cumulative 0201 3222968
opened cursors current 0 31 6 335
Order entry
I wrote an article on this that may be of use to you.
www.cybcon.com/~jkstill/util
Jared
On Thursday 03 May 2001 02:35, Andor, Gyula wrote:
Hi Gurus !
Is there any standard method to encrypt data? We are making an application
that uses application-level privilege system, so we should
No, he just sent the ACK so far.
|| -Original Message-
|| From: Bill Wagman [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 03, 2001 2:27 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: Metalink Praise
||
||
|| Well that's fine but did the support person give you the
Oracle VS Sybase
Oracle, wide install base, plenty of developers/dba's although they can get
pricey. Large market share makes for a stable company. Has abundant
development and management tools available + a healthy third party market.
Sybase, shrinking install base, trained people
Leslie,
Sybase is what SQL Server is built from, I think. I don't know much about
Sybase, but I Know that SQL Server 7 only has one transaction log file (redo
log file), that you have to back up regularly and truncate otherwise your
database will freeze. In SQL server there is no such thing as
Hey all,
I know that this has been addressed on the list before, so if there's an
archive yet (I've been away for a bit) just point me to it. I made the
terrible, heinous mistake of 1) installing Personal Oracle 8.1.6 on my
laptop, which went well, then 2) installing Oracle Developer 6i on the
Which is a better way to back up a database - use EXPORT/IMPORT or
physical datafile backups?
Chris
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Chris Rezek
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego,
Actually that seems to be a file that points to the file in the pfile
directory, the password file is also located here. If you want to know what
pfile is associated with what db you can just open it up, not to mention
that it will be uder the directory with the same name as the DB.
Kev
Diana,
Actually 8i does work with Dev 6i, but you have to install Developer first
and into the default home then you create a new home for 8i and install it
there. To remove Oracle from the machine you do not need to format the
drives, just shut down all services and delete the
Trash the directories, kill the registry entries and you're golden. I kill
Oracle on windoze all the time this way.
Dan
-Original Message-
Sent: Thursday, May 03, 2001 3:16 PM
To: Multiple recipients of list ORACLE-L
Hey all,
I know that this has been addressed on the list before,
Ross,
Around 500 users, uptime 26days; OLTP system
NAME minavgvar max
--- -- --
opened cursors cumulative 0 10611282 1107346
opened cursors current 0161
I know Ross was a bit overwhelmed with Metalink earlier today but I'm
going to hold off on my applause until they can figure out their shared
pool problems. I think this will be fixed in V9.1.4 of the database.
I've received this at least once every day this week when visiting
Metalink.
Thu, 3
we had a customer of the sort_area_size=1000
in their database, the temp table space is 256MB, the
db_block_size is 8k. They have some performance
problem, I think it's probably related to the setting
of sort_area_size(we have only one user). So what's
the benefits/disadvantage of too big
I deleted the message from the person wanting to know about Oracle V
Sybase and NT V Unix.
It appears the answer is Linux on the mainframe (running Oracle of
course)
http://dailynews.yahoo.com/h/cn/20010503/tc/venezuela_banks_on_ibm_linux_mainframe_1.html
- Brian
Doc ID:
Note:74790.1
Subject:
Cleanly Deinstalling RDBMS
Software from 95/98/NT
Type:
BULLETIN
Status:
PUBLISHED
Content Type:
TEXT/PLAIN
Diana,
SMILE ON
Get RedHat 7 CD-ROM
Insert into CD-ROM drive
Reboot and answer promts
SMILE OFF
In reality. To gut the machine of all Oracle stuff.
1. Delete all the stuff in the Oracle directories.
2. Remove all the Oracle stuff from the start menu.
3. BACKUP YOUR REGISTRY!!
4. If you skipped
Hello
I need help on this.
We have a Oracle 7.3.4 database and Oracle 8.1.6 database
The application is as follows
package in Oracle 8.1.6 calls package in Oracle 7.3.4
using Database link
Package in Oracle 7.3.4 does a lot of processing
but now
sometimes Oracle 7.3.4 package gives
LoL!!!Sorry! Guess the single analyst they
have working on MetaLink is bringing the system
to it's knees once he started work on my tar.
-Original Message-
Sent: Thursday, May 03, 2001 3:22 PM
To: Multiple recipients of list ORACLE-L
I'd put out that smoke. Am getting pl/sql
More info since this is s-u-c-h a fascinating topic. In case you're
wondering, it's past the end of the work day here for me, so I'm not wasting
time... ironically I'm staying late to study for a SQL Server 7
Administration exam!
Here goes, mind you this is from the lead developer for MS SQL
Here's an example.
create or replace trigger donuttin
after update on ian.test2
for each row
Declare
fhandle UTL_FILE.FILE_TYPE;
file_text varchar2(50);
Begin
fhandle :=
UTL_FILE.FOPEN('/tmp', 'utlfile.txt', 'A');
UTL_FILE.PUT_LINE(fhandle, 'old is '||:old.isint
Why do I keep getting this error even though this object is not a view??? I am in as
the owner of the table, which has the DBA role to boot.
SQL show user
USER is FARS_OWNER
SQL select owner, object_name, object_type from dba_objects where object_name like
'%ALIASTYPE%';
OWNER OBJECT_NAME
Thanks so much to everyone who replied! It seems to be working now. And,
I agree completely with the RedHat idea, but this is my consulting laptop,
and Windoze is very much the name of the game.
Actually, at home I have RedHat, but I don't have Oracle -- it's running
Postgres, which I must
http://dailynews.yahoo.com/h/nm/20010503/tc/microsoft_linux_dc_2.html
http://dailynews.yahoo.com/h/nm/20010503/tc/microsoft_linux_dc_2.html
Let me know what you think.
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Patrice.
Hey thanks a lot. That's a pile of history that I had no idea of. I always
believed that MS came up with SQL*Server on their own as a follow on to access.
Well, Well what do you know, good old Bill is a real thief after all!!!
Dick Goulet
Reply
Does anyone know which products M$ created *on their own* ?? Any ideas
anyone?
I know one BSOD .. yeah, they have the patent on it, what else?
???
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any
Has anyone heard about a company called LECCO Technology and their products
which supposedly use artificial intelligence to re-write and optimize SQL
statements?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services
hi
I am databse on sun solaris 2.7 and oracle8.1.6.I am getting the following
error in alert log frequently.IS this error cause the database crash.Please
help to come out from this problem.
ORA-07445: exception encountered: core dump [dredseek()+388] [SIGSEGV]
[Address not mapped to object]
Found this on Dogpile, looks like they have an evaluation download.
LECCOTECH: Where the Experts go for Performance
* LECCOTECH is a worldwide company delivering leading edge Relational
Database Management System performance enhancement tools designed
specifically for development teams and
Practical Oracle 8i:building efficient databases
by Jonathan Lewis
visit http://www.jlcomp.demon.co.uk/
Regards
Suhen
Can anyone suggest me a good book on database design and sizing and also on
performance tuning,backup recovery.
Thanks
Ravindra
--
Please see the official ORACLE-L FAQ:
Hi all,
Do you guys have any password policy knowledge to share?
For Solaris 7,
and Oracle 8i 8.1.6,
Can anyone introduce me some good URL sites for those white paper ?
Thank You
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL
Jonathan Gennick wrote:
Fellow list members, I received the following email from a
reader a few minutes ago. If you skip down to where he talks
about backup, you'll see that he's in trouble with a
database that won't recover. I've already suggested that he
open a TAR, and that he supply
89 matches
Mail list logo