Hello, is there any SQL statement to see what SQL have been performed
over a database???
Inserts, deletes, etc.
TIA
--
Beatriz Martínez Jiménez Ingeniera Informática
Tfno: 983 546646 [EMAIL PROTECTED]
Fundación
a lot
--
Beatriz Martínez Jiménez Ingeniera Informática
Tfno: 983 546646 [EMAIL PROTECTED]
Fundación CIDAUT
Centro de Investigación y desarrollo en Automoción
Parque Tecnológico de Boecillo, p.209. 47151
Boecillo
Hello
I´m trying to connect as internal and I get the error 24314:service
handle not initialized.
Before executing the sqlplus command, I have set the oracle_sid variable
to my db one.
Any idea?
TIA
--
Beatriz Martínez
Hello list,
I want to know how could I identify the OS user name of a user acceding
an application. Is there any view/parameter that shows it??
A lot of thanks,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?=
INET:
Hello again,
thanks all that have replied.
I have another question. Is it possible to clone a database just only through
OS operations? For example, is it possible to overwrite the files related
with one database (.dbf, .ctl..) with the one related with the database to
'clone'?
Maybe it sounds
Hello list,
I new to clone a database for changing between test to production.
The new database is going to be in a different host.
I have the copy obtained through the enterprise manager (I suppose it´s
a cold backup).
Which are the steps I should follow?
A lot of thanks
--
Please see the
Hello all,
I was working with an 8.1.6 DB and I needed to migrate to 8.1.7. As I
was newbie (And i keep on being that) I copied all the files related
with the DB (control, dbf..). I created a new DB with the same name and
path as the 81.6 one and replaced its files with the one I saved
Thanks, christoffer, finally I have solved this and it works.
The parameters set I have now, is the following:
shared_pool_size 68157440 (size in bytes )
shared_pool_reserved_size 3407872
large_pool_size 614400
java_pool_size 5250
java_soft_sessionspace_limit 0
Hello all,
I want to load in ther server two jar files, through the loadjava
utility. But, where should be this files physically stored? Should they
be in any folder under ORACLE_HOME directory?
A lot of thanks in advance
begin:vcard
n:Jimenez;Beatriz Martinez
x-mozilla-html:FALSE
Hello all of you,
I get the ORA-03113 (end-of-file on communication channel) error when I
execute the initjvm script. This script is needed to use utl_smtp
package. Here is the output I get:
***
ERROR:
ORA-03114: not connected to ORACLE
create or replace java system;
*
ERROR en línea 1:
Hello, I am trying to log in the sqlplus (from command line) as the
internal user but I can´t remember its password.
Is there any way to change it?
TIA
begin:vcard
n:Jimenez;Beatriz Martinez
x-mozilla-html:FALSE
org:Fundación CIDAUT;Departamento de Informática
adr:;;Parque Tecnológico de
A lot of thanks for all of you!!!.
Moses Ngati Moya wrote:
Beatriz,
It is possible to change your internal password. At the command prompt (DOS)
issue the command
ORAPWD file=passwordfilepassword=newpasswordentrries=no. of DBAs
e.g.
ORAPWD file=ABCSPWD.ORA password=oracle
Hello all,
I´m looking for Oracle certification exams in Spanish. I have found a
lot of them, but all are in english.
Maybe somebody could give me information about where could we find them.
A lot of thanks,
begin:vcard
n:Jimenez;Beatriz Martinez
x-mozilla-html:FALSE
org:Fundación
Hello list,
I haven´t seen many questions about Developer tool in this forum, maybe
it´s not the correct one to make this question, but I´ll try it.
Although there is a lot of information about LOB´s in manuals and
Metalink, I haven´t found anything about displaying an image stored in a
BLOB
Hello list,
Oracle 8.1.7. NT4.0
I have created some procedures in the DBA Studio, and when I try to
compile them I get that the procedure status is Invalid, but in the
'show error' window there is no message. The window appears but it´s
completely empty.
Could somebody tell me what happens? Do i
minus order partition start subpartition union where connect
SAMPLE_
The symbol ; was substituted for END to continue.
From: Beatriz Martínez Jiménez [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: No errors showed
Hello list,
I get this error, working with the dbms_lob package.
(NT4, oracle 8.1.7)
This is the sequence of steps I have followed:
CREATE OR REPLACE DIRECTORY DIRECT_IMAGEN AS 'E:\DIRECT_IMAGEN';
CREATE OR REPLACE PROCEDURE insert_image
AS
file BFILE;
lob BLOB;
BEGIN
insert into
Hello List,
I would like to know any statement to know which 'object directory'
exists in the oracle instance, for a specified user.
TIA,
begin:vcard
n:Jimenez;Beatriz Martinez
x-mozilla-html:FALSE
org:Fundación CIDAUT;Departamento de Informática
adr:;;Parque Tecnológico de Boecillo
is the correct one.
I have made inserted too a parameter in the init.ora file 'UTL_FILE_DIR',
but with no luck.
Could somebody give me any idea? Am I doing anything wrong?
A lot of thanks again
Gogala, Mladen wrote:
select * from user_objects;
-Original Message-
From: Beatriz Martínez
Yes, I have tried this. I select a different route for the developer during
its installation. I get first an alert saying that if I select an installation
location different from the one already set, I will deactive the products
installed on it. Despite of this, I select this different folder,
Hello List,
I have trying to install both of them (Oracle database software and
Developer software) on the same machine, but it has been completely
impossible for me. Could anybody tell me whether there is or not any way
to do it?
Thanks in advance
begin:vcard
n:Jimenez;Beatriz Martinez
Hello list,
This question is not a matter or life or death but a curiosity I have.
Im working with Oracle 8.1.6 and NT. Each time I open the database,
I get the next message in the XXXALERT.log :
Obsolete system parameters with specified
values:
distributed_lock_timeout
I included it the
22 matches
Mail list logo