If you have OEM (Oracle Enterprise Manager) with the management packs, there
is one called Change Manager. That will allow you to compare two schemas
and give you a nice report as well.
-Original Message-
From: Steve Sapovits [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 16, 2005 11:11
Pete,
If you are trying to connect to an Oracle 7 database then you need to use
the Oracle 9.0 client. Connecting to Oracle 7 from 9.2 is no longer
supported. Any version equal to or less than 9.0.1 will work.
HTH,
Sam Gold
-Original Message-
From: Hope Peter [mailto:[EMAIL PROTECTED]
It depends on what database you are using. It can be done in oracle by
SELECT region AVG(amount)
FROM sales SAMPLE(5)
GROUP BY region;
This statement select 5 percent of the data in the sales table. This is
from the oracle 8i documentation.
Thanks,
Sam Gold
-Original Message-
Fro
Yes you can. Here is an example.
$sth_tbs_mode = $dbh->prepare("BEGIN SYS.BACKUP.BEGIN_BK(?); END;");
$sth_tbs_mode->execute($tablespace_name);
Or you can use do if you are not passing any parameters.
$dbh->do("BEGIN SYS.BACKUP.BEGIN_BK('USERS'); END;");
$dbh->do ("ALTER SYSTEM ...");
I
Hey Marc,
Try putting a $sth1->finish(); before you do the next do statement. See
your code below, I marked it with *** Try that and see if it helps.
Thanks,
Sam Gold
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, March 12, 2004 7:10 AM
To: [EMAIL P
I would go with the latest and greatest.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Friday, March 12, 2004 12:50 AM
To: Gold, Samuel (Contractor); [EMAIL PROTECTED]
Subject: RE: DBI with ORACLE encryption
Hi,
We have tried this way of connecting as
I had no problems inserting a string of 4000 numbers or characters into a
varchar2(4000).
-Original Message-
From: Bretz, Ellen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 10:56 AM
To: [EMAIL PROTECTED]
Subject: varchar2 4000
Is anyone having trouble inserting or updating
If you don't have to manipulate any of the data then SQL*Loader is the way
to go. If you have to do any sort of manipulation of the data then it is
very difficult to use SQL*Loader. Personally I user perl to load my data
because I have to format some of the data and replace some of the values.
It
The message I received was removed by MailSweeper. I know that there is a
new virus called Mydoom.B that is going around. Here is what I found on
Symantec's site.
[EMAIL PROTECTED] is a mass-mailing worm that arrives as an attachment with
the file extension .bat, .cmd, .exe, .pif, .scr, or .zip.
I have called oracle and ask them if they would provide the shutdown
functionality in OCI and there answer was no. The reason they gave was:
"OCI does not provide the functionality to start and stop the database.
Doing so requires access to a lower level API which is not exposed to OCI."
That is
This is caused by the user executing the script not being part of the dba
group. ORA-01031 is insufficient privileges. Who ever is executing the
script needs to be part of the dba group or osdba group. HTH.
Thanks,
Sam Gold
-Original Message-
From: Baras, Gal [mailto:[EMAIL PROTECTE
I would check your date that you are inserting, it could be expecting a
different format. What is you NLS_DATE_FORMAT set to?
Here is the output from oerr.
oerr ora 1858
01858, 0, "a non-numeric character was found where a numeric was
expected"
// *Cause: The input data to be converted using
o. Is the two_task environmental variable set? You may also
>want to try using
>DBI->trace and see what that gives you.
>
>
>Thanks,
>Sam Gold
>
>
>-Original Message-
>From: Ian Harisay [mailto:[EMAIL PROTECTED]
>Sent: Friday, July 18, 2003 2:58 PM
look for stored procedures in the perl docs. Here is an example.
$sth_tbs_mode = $dbh->prepare("BEGIN SCOTT.BACKUP.BEGIN_BK(?); END;");
where Scott is the owner of the package. the package name is backup and the
procedure is begin_bk.
Thanks,
Sam Gold
-Original Message-
From: Ronni
Yes, use the 32-bit oracle libraries. I will forward a previous post on
this issue.
Thanks,
Sam Gold
-Original Message-
From: Rafael Caceres [mailto:[EMAIL PROTECTED]
Sent: Monday, June 16, 2003 6:54 PM
To: [EMAIL PROTECTED]
Subject: Can't build DBD::Oracle on AIX 5.1 with Oracle 9.2
I am pretty sure that it is only sql statements. I used a package to issue
commands like alter tablespace begin backup and the like.
-Original Message-
From: Wolf, Dr. Stefan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 8:17 AM
To: '[EMAIL PROTECTED]'
Subject: administrative comm
9:16 AM
To: Gold, Samuel (Contractor)
Cc: 'Alan Burlison'; Andy Hassall; Christian Merz; [EMAIL PROTECTED]
Subject: Re: Oracle connect internal/OS authentification
So do you all think that setting ora_session_mode to ORA_SYSDBA should force
the password to be non-null?
Tim.
On Fri, Jun 06
I have used code like this:
use DBI;
use Env;
use strict;
# Make sure that the environmental variables are undefined.
#
undef $ENV{ORA_SID};
undef $ENV{ORACLE_SID};
#
# Defing the environmental variables.
#
$ENV{ORA_SID} ='test';
$ENV{ORACLE_SID} =$ENV{ORA_SID};
I have had no issues connecting t
Very interesting.
-Original Message-
From: Alan Burlison [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 8:16 PM
To: Andy Hassall
Cc: Christian Merz; [EMAIL PROTECTED]
Subject: Re: Oracle connect internal/OS authentification
Hmm, this seems to work for me as well (on Solaris)
Have you tried to run your sql statement in sqlplus? Does it work there?
Thanks,
Sam Gold
-Original Message-
From: deadtwoU wishUknew [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 1:01 PM
To: Ronald J Kimball; deadtwoU wishUknew
Cc: [EMAIL PROTECTED]
Subject: Re: DECODE in(DB
tell me about it. :)
-Original Message-
From: Alan Burlison [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 12:32 PM
To: Gold, Samuel (Contractor)
Cc: 'Christian Merz'; [EMAIL PROTECTED]
Subject: Re: Oracle connect internal/OS authentification
Gold, Samuel (Contrac
, June 05, 2003 9:17 AM
To: Gold, Samuel (Contractor)
Cc: 'Christian Merz'; [EMAIL PROTECTED]
Subject: Re: Oracle connect internal/OS authentification
Gold, Samuel (Contractor) wrote:
> Sorry, but there is no way. / as sysdba is a SQL*Plus specific command. I
> opened a tar with oracle
Sorry, but there is no way. / as sysdba is a SQL*Plus specific command. I
opened a tar with oracle on the issue of being able to connect / as sysdba
and using OCI to shutdown the database like the shutdown command in
SQL*Plus. They told me that neither could be done. I created a user with
very s
I believe you have to you use it like this:
$q = qq |select * from x where y LIKE ?|;
upper casing the LIKE.
HTH,
Sam Gold
-Original Message-
From: Thomas Good [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 12:32 PM
To: DBI Users
Subject: LIKE and Variable Binding
Hi, how doe
24 matches
Mail list logo
