ddl-oracle-users Mailing List for DDL::Oracle (Page 11)
Brought to you by:
rvsutherland
Menu
▾
▴
ddl-oracle-users — Notices and general discussion of DDL::Oracle
You can subscribe to this list here.
| 2000 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
(3) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2001 |
Jan
(2) |
Feb
(4) |
Mar
(6) |
Apr
(2) |
May
(1) |
Jun
(3) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
| 2004 |
Jan
(1) |
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
(1) |
Sep
(2) |
Oct
|
Nov
|
Dec
|
| 2005 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
(3) |
Jul
(8) |
Aug
(5) |
Sep
(7) |
Oct
(7) |
Nov
(3) |
Dec
(8) |
| 2006 |
Jan
(9) |
Feb
(8) |
Mar
(11) |
Apr
(4) |
May
(9) |
Jun
(15) |
Jul
(15) |
Aug
(12) |
Sep
(13) |
Oct
(35) |
Nov
(19) |
Dec
(27) |
| 2007 |
Jan
(10) |
Feb
(8) |
Mar
(6) |
Apr
(8) |
May
(2) |
Jun
(2) |
Jul
(5) |
Aug
(25) |
Sep
(19) |
Oct
(12) |
Nov
(12) |
Dec
(7) |
| 2008 |
Jan
(8) |
Feb
(3) |
Mar
(5) |
Apr
(9) |
May
(1) |
Jun
(4) |
Jul
(8) |
Aug
(4) |
Sep
(10) |
Oct
(3) |
Nov
|
Dec
(36) |
| 2009 |
Jan
(31) |
Feb
(17) |
Mar
(25) |
Apr
(52) |
May
(126) |
Jun
(103) |
Jul
(70) |
Aug
(30) |
Sep
(18) |
Oct
(40) |
Nov
(5) |
Dec
(15) |
| 2010 |
Jan
(2) |
Feb
(9) |
Mar
(34) |
Apr
(48) |
May
(78) |
Jun
(73) |
Jul
(65) |
Aug
(64) |
Sep
(42) |
Oct
(28) |
Nov
(7) |
Dec
(14) |
| 2011 |
Jan
(22) |
Feb
(24) |
Mar
(27) |
Apr
(30) |
May
(15) |
Jun
(5) |
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2013 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
(1) |
Dec
|
| 2015 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
|
| 2016 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
|
From: Richard S. <rvs...@ya...> - 2002-05-22 16:16:30
|
Files attached. Comments and complaints sought and appreciated! Cheers, Richard ===== Richard Sutherland rvs...@ya... "Tom Ridge offers five colors to warn against terrorist attacks. I think it would be far more useful, however, if we had five colors to warn against the government's incompetence." - Maureen Dowd __________________________________________________ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com |
|
From: <Res...@Ma...> - 2001-12-07 04:36:16
|
<html>
<head>
<title>Newsletter</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table width="500" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="#CCCCCC">
<tr>
<td width="50%"><a href="http://www.make-cents.com"><img src="http://www.make-cents.com/images/newslogo.gif" width="249" height="60" border="0"></a></td>
<td width="50%"><a href="http://www.zurichinvestmentgroup.com/signews.htm"><img src="http://www.make-cents.com/images/szigban.gif" width="250" height="60" border="0"></a></td>
</tr>
<tr>
<td width="50%"><font size="4"><b><font size="4"><b><font size="2">NEWSLETTER</font></b></font></b></font></td>
<td width="50%">
<div align="right"><font size="4"><font size="4"><font size="2">Thursday,
December 7, 2001</font></font></font></div>
</td>
</tr>
<tr>
<td width="50%"><b><img src="http://www.make-cents.com/images/us.gif" width="30" height="17"></b><img src="http://chart.neural.com/servlet/WatchList?mode=1&chrow=666699&chrname=Verdana&chrtxt=FFFFFF&crow1=eeeeee&crow2=wht&cfcol1=eeeeee&cfcol2=wht&ahr=2&adr=3&afc=1&fhrname=Verdana&cfcdtxt=000000&fhrname=B&fhrsize=9&ffcsize=9$fdrsize=9&cup=006600&width=220&height=17&border=0&gline=1&cgline=eeeeff&field=NCGT&symbol=$COMPQ&name=Nasdaq"><br>
<img src="http://chart.neural.com/servlet/GIFChart?sym1=$compq&height=120&width=250&cbcku=FFFFF0&cbckl=red&cbckd=ffffff&ctxtu=006699&ctxtd=006699&ctxtl=006699&csym1=6666FF&cbckg=eeeeee&cind7a=red&cind7=dgrn&source=SP&dres=max&pdcdata=0&ignore=1220004345&texttype=1&mode=1&image=png" border=0></td>
<td width="50%"><img src="http://www.make-cents.com/images/sw.gif" width="30" height="17"><img src="http://chart.neural.com/servlet/WatchList?mode=1&chrow=666699&chrname=Verdana&chrtxt=FFFFFF&crow1=eeeeee&crow2=wht&cfcol1=eeeeee&cfcol2=wht&ahr=2&adr=3&afc=1&fhrname=Verdana&cfcdtxt=000000&fhrname=B&fhrsize=9&ffcsize=9$fdrsize=9&cup=006600&width=220&height=17&border=0&gline=1&cgline=eeeeff&field=NCGT&symbol=$SSMI&name=Zurich SMI"><br>
<img src="http://chart.neural.com/servlet/GIFChart?sym1=$SSMI&height=120&width=250&cbcku=FFFFF0&cbckl=red&cbckd=ffffff&ctxtu=006699&ctxtd=006699&ctxtl=006699&csym1=6666FF&cbckg=eeeeee&cind7a=red&cind7=dgrn&source=SP&dres=max&pdcdata=0&ignore=1220004345&texttype=1&mode=1&image=png" border=0></td>
</tr>
</table>
<table width="500" border="0" cellspacing="0" cellpadding="6" align="center" bgcolor="#FFFFFF">
<tr>
<td width="60%" valign="top">
<table width="100%" border="0" cellspacing="1" cellpadding="8" align="center" bgcolor="#000000">
<tr>
<td bgcolor="#FFFFF0">
<p><b>Global Quantitative Strategy</b></p>
<p><font size="2"><font size="2"><b><img src="http://www.make-cents.com/images/smclogo.gif" width="60" height="16">
Make-Cents</b></font><font size="1" face="Arial, Helvetica, sans-serif"><br>
</font>Global Quant Stock Ideas for the Month of December.<br>
The sustained global equities rally in November saw all our style-driven
strategies deliver positive returns over the month. Value (+9.75%),
upside reversal (+13.70%) and earnings surprise (+6.31%) all outperformed
our benchmark, the MSCI AC World Free Index, which finished the
month up 6.15% in US dollar terms. Upside reversal performed well
for the second month - which it often does in bear market rallies.
The US dominates the positive and negative stock picks this month.</font></p>
<p><font size="2">We highlight:<br>
VALUE: British American Tobacco<br>
(BATS.L, 561p, Buy), Mayne Nickless<br>
(MAY.AX, A$6.93, Buy) and<br>
Den Norske Bank </font><font size="2">(DNB.OL, NOK 36.80, Buy).
<br>
GROWH: Tyco (TYC, $59.76, Buy),<br>
TSMC (2330, T$83.5, SB);<br>
Kookmin Bank (60000 KS, KRW 49.7, Buy) and<br>
Allied Waste (AW, $12.01, SB).<br>
MOMENTUM: Best Buy (BBY, $73.31, SB); Woolworths (WOW.AX, A$11.50,
Buy),<br>
CSL Ltd (CSL.AX, A$50.82, Buy) and<br>
Sappi (SPP, $10.31, Buy)<br>
UPSIDE REVERSAL:<br>
General Electric (GE, $37.55, Buy) <br>
EARNINGS SURPRISE:<br>
Fannie Mae (FNM, $77.85, Buy),<br>
Freddie Mac (FRE, $65.45, Buy), Tenet Healthcare (THC, $60.70, SB),
and Health Mgmt Assoc (HMA, $19.20, SB). (Europe Morning)</font><font size="2"><br>
</font><font size="2"><font color="#0000FF">for more <a href="http://www.zurichinvestmentgroup.com/signews.htm">Subscribe
here </a></font></font></p>
<p><b><img src="http://www.make-cents.com/images/us.gif" width="30" height="17">
Technical Market Update</b><font size="1" face="Arial, Helvetica, sans-serif"></font><br>
<font size="1" face="Arial, Helvetica, sans-serif"><img src="http://www.make-cents.com/images/bob.gif" width="102" height="102"><br>
Bob Dickey<br>
MANAGING DIRECTOR RESEARCH<br>
for RBC Dain Rauscher Wessels</font><font size="2"><b><br>
</b></font></p>
<p><font size="2">The strong close, good volume, and breakout on the
Nasdaq delay any pullback in the markets for the near term, in our
opinion. The DJIA has more resistance to get through starting around
10,200 but will likely work into the mid-10,000 area over the next
several days. Wednesday (December 5) saw a good number of stocks
break out of their ranges on good volume, most notably, the semiconductors,
which are often a leading group, suggesting rallies ahead for other
tech areas. The market is spiking higher over the near term, and
we believe the strength on Wednesday suggests further strength ahead.<br>
We believe the market is telling us that an economic recovery lies
in the future. Oddly enough, the general market peak was in March
of 2000, while the official recession is said to have started in
March of 2001. The recession was not realized or announced until
November 2001, which is a year-and-a-half after the market peak.
Now, the same thing is working in reverse.</font><font size="2"></font><font size="2"><br>
<font color="#0000FF">for more <a href="http://www.zurichinvestmentgroup.com/openacc.htm">Subscribe
here</a></font></font></p>
</td>
</tr>
</table>
</td>
<td valign="top" width="40%">
<table width="100%" border="0" cellspacing="1" cellpadding="8" align="center" bgcolor="#0000FF">
<tr>
<td bgcolor="#F4F4F4">
<p><b>Research News</b></p>
<p><font size="2"><b><img src="http://www.make-cents.com/images/scsfb.gif" width="60" height="16">
CSFB</b><br>
</font><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><font face="Arial, Helvetica, sans-serif">•
</font></font> <font size="1" face="Arial, Helvetica, sans-serif">MOVERS
& SHAKERS<br>
Stocks surprised many by not giving up much of yesterday's gain.
Lots of trading around positions within sectors today. Treasuries
declined as falling jobless claims and rising factory orders heightened
speculation the Federal Reserve will stop cutting interest rates
after an expected reduction next week. TECH OVERVIEW: Group feels
a little tired, with buyers on the sidelines and some money moving
around within tech.</font></p>
<p><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><font face="Arial, Helvetica, sans-serif">•
</font></font> <font size="1" face="Arial, Helvetica, sans-serif"></font><font size="1" face="Arial, Helvetica, sans-serif">US
Portfolio Strategy <br>
Stocks Can Survive with Low Inflation; Focus on Health Care <br>
In a low inflation world, with concerns about balance sheets, the
health care sector is the sector most investors can find some comfort
in. The sector's 14% weighting today will be at or above 25% of
the S&P 500 within a decade, in our view. Unit growth driven
by new products and demographics will easily exceed GDP for the
foreseeable future and pricing for these unique products and services
are likely to continue to expand beyond general inflation.</font></p>
<p><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><font face="Arial, Helvetica, sans-serif">•
</font></font> <font size="1" face="Arial, Helvetica, sans-serif"></font><font size="1" face="Arial, Helvetica, sans-serif">The
stock market continues to display an extremely bullish technical
pattern, with big gainer days and little loser days. Yesterday,
on the heels of Wednesday's monster rally, the DJIA and S&P
500 lost only a little ground; and the Nasdaq actually finished
to the upside. When the stock market staircase features steep risers
(upside days) and level steps (consolidation days), investors are
implicitly showing an unwillingness to collect profits.</font><font size="1" face="Arial, Helvetica, sans-serif"><br>
</font><font size="2"><font color="#0000FF" size="1" face="Arial, Helvetica, sans-serif">for
more </font><font size="1" face="Arial, Helvetica, sans-serif"><font color="#0000FF"><a href="http://www.zurichinvestmentgroup.com/signews.htm">subscribe
here</a></font><br>
</font></font></p>
<p><font size="2"><b><img src="http://www.make-cents.com/images/sargus.gif" width="60" height="16"><br>
Argus Market Report</b><br>
</font><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><font face="Arial, Helvetica, sans-serif">•
MARKET REVIEW<br>
• </font></font><font size="1" face="Arial, Helvetica, sans-serif">Ratings
Change: Raising rating on Lucent to BUY from HOLD.<br>
</font><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><font face="Arial, Helvetica, sans-serif">•
</font></font><font size="1" face="Arial, Helvetica, sans-serif">
Ratings Change: Reducing near-term rating on BBBY shares to HOLD
from BUY on valuation basis.<br>
</font><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><font face="Arial, Helvetica, sans-serif">•
</font></font><font size="1" face="Arial, Helvetica, sans-serif">
Highlights from the Monthly Retail Review.<br>
</font><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><font face="Arial, Helvetica, sans-serif">•
</font></font><font size="1" face="Arial, Helvetica, sans-serif">
Value Stock: Lowering 2001 and 2002 EPS estimates on HOLD-rated
FON.</font><font size="1" face="Arial, Helvetica, sans-serif"><br>
</font><font size="2"><font size="1" face="Arial, Helvetica, sans-serif"></font></font><font size="2"><font size="2"><font size="2"><font size="2"><font size="2"><font size="2"><font size="2"><font size="2"><font color="#0000FF" size="1" face="Arial, Helvetica, sans-serif">for
more </font><font size="1" face="Arial, Helvetica, sans-serif"><font color="#0000FF"><a href="http://www.zurichinvestmentgroup.com/signews.htm">subscribe
here</a></font></font></font></font></font></font><font size="1" face="Arial, Helvetica, sans-serif"></font></font></font></font></font></p>
<p><font size="2"><b><img src="http://www.make-cents.com/images/sdain.gif" width="60" height="16"><br>
RBC Dain Rauscher Wessels</b><br>
</font><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><font face="Arial, Helvetica, sans-serif">•
(AEOS) American Eagle Outfitters, Inc. <br>
Buy-Aggressive ; Price Target: $35.00<br>
SOFTLINES RETAIL<br>
WARM WEATHER AND PROMOTIONS HURT NOVEMBER SALES</font></font></p>
<p><font size="1" face="Arial, Helvetica, sans-serif">*Comps decline
significantly, driven by warm weather and sparse retail traffic.<br>
*Both men’s and women’s categories produce negative comps.<br>
*Inventory levels remain under control through promotional activity.<br>
*We are lowering estimates; weather remains the wild card.</font><font size="2"><font size="2"><font size="1" face="Arial, Helvetica, sans-serif"><font color="#0000FF"><br>
</font><font size="2"><font size="2"><font color="#0000FF" size="1" face="Arial, Helvetica, sans-serif">for
more </font><font size="1" face="Arial, Helvetica, sans-serif"><font color="#0000FF"><a href="http://www.zurichinvestmentgroup.com/signews.htm">subscribe
here</a></font></font></font></font></font></font></font></p>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" valign="top">
<div align="center"><a href="http://www.zurichinvestmentgroup.com/signews.htm"><img src="http://www.make-cents.com/images/tempban.gif" width="468" height="60" border="0"></a></div>
</td>
</tr>
<tr>
<td colspan="2" valign="top">
<div align="center">
<p align="center"><font size="2"><a href="http://www.make-cents.com/refer.htm">EMAIL
TO A FRIEND</a> <a href="http://www.make-cents.com/txtnews.htm">PRINTER
FRIENDLY FORMAT</a></font></p>
<p><font size="2">Make-Cents.com E-Mail Center: <a href="http://www.zurichinvestmentgroup.com/signews.htm">subscribe</a>
or <a href="http://www.zurichinvestmentgroup.com/unscribe.htm">unsubscribe</a>
to Newsletter at Make-Cents<br>
________________________________________<br>
<br>
Copyright © 2001 Make-Cents. All rights reserved. </font></p>
</div>
</td>
</tr>
</table>
</body>
</html>
|
|
From: Christian M. <sc...@bi...> - 2001-06-04 10:51:55
|
Christian Mondrup wrote: > > As above mentioned I'm a new user and have almost no experience with > writing DBI syntax (I've been using Oracle4 should be perl 4 !! (combined with Oracle 6) > & and oraperl for years) and > therefore presume that the problem is with the programmer (me) and not > the programming tool (DDL). Butwhat *is* the problem? Will someone > please enlighten me? -- Christian Mondrup, Computer Programmer Scandiatransplant, Skejby Hospital, University Hospital of Aarhus Brendstrupgaardsvej, DK 8200 Aarhus N, Denmark Phone: +45 89 49 53 01 - http://www.scandiatransplant.org |
|
From: Richard S. <rvs...@ya...> - 2001-06-04 10:40:04
|
Christian,
The problem WAS in DDL::Oracle, but has since been corrected. Please
upgrade to the current version (1.10), and see if this fixes your output.
Thanks. And please report any other issues you find -- we try to fix all
reported bugs.
Richard
--- Christian Mondrup <sc...@bi...> wrote:
> Dear list members.
>
> I'm a new user of the DDL utility which I've taken into use for a cron
> job collecting a.o. table and view DDL from the data dictionary of my
> developer's work station.
>
> I have, however, a problem which I haven't been able to solve: how do I
> achieve the column name definition part of a create view statement
> being reflected by the DDL utility? What I get when I execute the below
> script with 'view' as argument for my option -t are statements
> consisting of 'create or replace view as ' followed by the select and
> where clauses in question but no list of column names reflecting those
> I explicitly declared myself.
>
> As above mentioned I'm a new user and have almost no experience with
> writing DBI syntax (I've been using Oracle4 & and oraperl for years)
> and therefore presume that the problem is with the programmer (me) and
> not the programming tool (DDL). Butwhat *is* the problem? Will someone
> please enlighten me?
>
> #!/usr/local/bin/perl
> require "app_name.pl";
> use Getopt::Long;
> use DBI;
> use DDL::Oracle;
>
> sub read_opts {
> my($usage);
> $script = &app_name;
> $usage = "Usage: ${script}.pl -opt ..\n";
> $usage .= " -l user/password\n";
> $usage .= " -t object type\n";
> $usage .= " [ -n object name ]\n";
> $usage .= " [ -o object owner ]\n";
>
> &GetOptions('l=s','t=s','n:s','o:s') || die "$usage\n";
> $opt_l || die "$usage\n";
>
> # split oracle user and password from login parm
> ($user,$passwd) = split(/\//,$opt_l);
>
> die "$usage\n" if ! ($user && $passwd);
>
> $object_type = ($opt_t eq "table") ? 'table family' : $opt_t;
> $OBJECT_TYPE = "\U$opt_t\E";
> $object_name = "\U$opt_n\E";
> $object_owner = "$opt_o";
> }
>
> read_opts;
>
> $oracle_home = "/export/home/app/oracle/product/7.3.4";
> $ENV{ORACLE_HOME} = "$oracle_home";
> $ENV{ORA_NLS32} = "${oracle_home}/ocommon/nls/admin/data";
>
> my $dbh = DBI->connect(
> "dbi:Oracle:SC",
> $user,
> $passwd,
> {
> PrintError => 0,
> RaiseError => 1
> }
> );
> DDL::Oracle->configure(
> dbh => $dbh,
> schema => "0",
> );
> $select =
> "SELECT
> owner,
> object_name
> FROM dba_objects
> WHERE owner = '$object_owner'
> AND object_type = '$OBJECT_TYPE'";
>
> if (length($object_name) > 0) {
> $select .=
> "\n AND object_name = '$object_name'";
> }
> my $sth = $dbh->prepare("$select");
> $sth->execute;
> my $list = $sth->fetchall_arrayref;
> my $obj = DDL::Oracle->new(
> type => $object_type,
> list => $list
> );
> my $ddl = $obj->create;
>
> Best regards
> --
> Christian Mondrup, Computer Programmer
> Scandiatransplant, Skejby Hospital, University Hospital of Aarhus
> Brendstrupgaardsvej, DK 8200 Aarhus N, Denmark
> Phone: +45 89 49 53 01 - http://www.scandiatransplant.org
>
> _______________________________________________
> DDL-Oracle-users mailing list
> DDL...@li...
> http://lists.sourceforge.net/lists/listinfo/ddl-oracle-users
=====
Richard Sutherland
rvs...@ya...
A GURU HAIKU
Drug testing you say?
Think I'll go to Joe's Tavern
And do my homework.
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
|
|
From: Christian M. <sc...@bi...> - 2001-06-03 22:58:06
|
Dear list members.
I'm a new user of the DDL utility which I've taken into use for a cron
job collecting a.o. table and view DDL from the data dictionary of my
developer's work station.
I have, however, a problem which I haven't been able to solve: how do I
achieve the column name definition part of a create view statement being
reflected by the DDL utility? What I get when I execute the below script
with 'view' as argument for my option -t are statements consisting of
'create or replace view as ' followed by the select and where clauses in
question but no list of column names reflecting those I explicitly
declared myself.
As above mentioned I'm a new user and have almost no experience with
writing DBI syntax (I've been using Oracle4 & and oraperl for years) and
therefore presume that the problem is with the programmer (me) and not
the programming tool (DDL). Butwhat *is* the problem? Will someone
please enlighten me?
#!/usr/local/bin/perl
require "app_name.pl";
use Getopt::Long;
use DBI;
use DDL::Oracle;
sub read_opts {
my($usage);
$script = &app_name;
$usage = "Usage: ${script}.pl -opt ..\n";
$usage .= " -l user/password\n";
$usage .= " -t object type\n";
$usage .= " [ -n object name ]\n";
$usage .= " [ -o object owner ]\n";
&GetOptions('l=s','t=s','n:s','o:s') || die "$usage\n";
$opt_l || die "$usage\n";
# split oracle user and password from login parm
($user,$passwd) = split(/\//,$opt_l);
die "$usage\n" if ! ($user && $passwd);
$object_type = ($opt_t eq "table") ? 'table family' : $opt_t;
$OBJECT_TYPE = "\U$opt_t\E";
$object_name = "\U$opt_n\E";
$object_owner = "$opt_o";
}
read_opts;
$oracle_home = "/export/home/app/oracle/product/7.3.4";
$ENV{ORACLE_HOME} = "$oracle_home";
$ENV{ORA_NLS32} = "${oracle_home}/ocommon/nls/admin/data";
my $dbh = DBI->connect(
"dbi:Oracle:SC",
$user,
$passwd,
{
PrintError => 0,
RaiseError => 1
}
);
DDL::Oracle->configure(
dbh => $dbh,
schema => "0",
);
$select =
"SELECT
owner,
object_name
FROM dba_objects
WHERE owner = '$object_owner'
AND object_type = '$OBJECT_TYPE'";
if (length($object_name) > 0) {
$select .=
"\n AND object_name = '$object_name'";
}
my $sth = $dbh->prepare("$select");
$sth->execute;
my $list = $sth->fetchall_arrayref;
my $obj = DDL::Oracle->new(
type => $object_type,
list => $list
);
my $ddl = $obj->create;
Best regards
--
Christian Mondrup, Computer Programmer
Scandiatransplant, Skejby Hospital, University Hospital of Aarhus
Brendstrupgaardsvej, DK 8200 Aarhus N, Denmark
Phone: +45 89 49 53 01 - http://www.scandiatransplant.org
|
|
From: <Del...@wa...> - 2001-05-11 15:18:37
|
Please see [ #423336 ] Error using type='table family' at http://sourceforge.net/tracker/index.php?func=detail&aid=423336&group_id=12630&atid=112630. |
|
From: Richard S. <rvs...@ya...> - 2001-04-06 00:41:09
|
> FROM: L SternDATE: 04/04/2001 11:08:43
> SUBJECT: [DDL-Oracle-users] using component
> Some examples of how to use the new component key
> word would help.
> Leon
Thanks, Leon, for pointing out this omission. The SYNOPSIS section of
the pod has been updated for the next release. Here is the section about
type 'components'. Basically it is the same as for any 'create' method,
except that the owner/name contents are irrelevant.
--------
# Here's another example, this time for type 'components'. This type
# differs from the norm, because it has no owner and no name.
my $obj = DDL::Oracle->new(
type => 'components',
list => [[ 'no owner','no name' ]]
);
my $ddl = $obj->create;
print $ddl;
----------
If you still have trouble, please write again. It's no good having a
module without instructions which help people use it.
Thanks.
Richard
=====
Richard Sutherland
rvs...@ya...
"Even if you are on the right track, you'll get run
over if you just sit there." - Will Rogers (1879-1935)
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
|
|
From: L S. <pai...@ya...> - 2001-04-04 18:09:02
|
Some examples of how to use the new componenet key word would help. Leon __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ |
|
From: Richard S. <rvs...@ya...> - 2001-03-29 14:46:33
|
Remke,
Thanks again. You have been extremely helpful in shaking down
DDL::Oracle for Oracle7, and I really appreciate it. I may get a new
version out this weekend. There was another bug reported, plus some new
features are under construction.
Again, THANKS.
Richard
--- Remke Rutgers <Rem...@br...> wrote:
> Hello list-users (Richard)?
>
> This issue concerns version 1.06 of ddl-oracle, containing Oracle.pm
> version 1.40.
>
> Lines 613-616 of Oracle.pm say:
> if ( $oracle_major < 8 )
> {
> $sql .= "$enable\n";
> }
>
> $enable has the value of ENABLE or DISABLE, depending on the state of
> the constraint.
>
> However, in Oracle 7.3.3, in an ALTER TABLE ... ADD CONSTRAINT
> statement you only need to use DISABLE if the constraint must not be
> enforced. Default is enabled and that does not need a keyword.
>
> Eg, the code generated is:
> ALTER TABLE myuser.exm_result_category ADD CONSTRAINT
> fk_exm_result__exm_result FOREIGN KEY
> (
> resultid
> )
> REFERENCES myuser.exm_result
> (
> resultid
> )
> ON DELETE CASCADE
> ENABLE
> ;
>
> The line ENABLE should be omitted, or it should read: ENABLE CONSTRAINT
> constraintname
>
> I changed line 613-616 in Oracle.pm to:
> if ( $oracle_major < 8 )
> {
> if ( $enable ne 'ENABLE' )
> {
> $sql .= "$enable\n";
> }
> }
> That seems to work fine.
> However, I do not know if this is valid for all older Oracle versions.
>
> Remke Rutgers - Rem...@br...
> Technisch Consultant
>
> Bright Alley - Media Park
> Sumatralaan 45 / Postbus 10
> 1200 JB Hilversum
> web www.brightalley.com
> tel +31 35 6774000 / fax +31 35 6774355
>
> _______________________________________________
> DDL-Oracle-users mailing list
> DDL...@li...
> http://lists.sourceforge.net/lists/listinfo/ddl-oracle-users
=====
Richard Sutherland
rvs...@ya...
Rights? You want rights?
I'll give you so many rights you'll beg for a left.
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/?.refer=text
|
|
From: Remke R. <Rem...@br...> - 2001-03-29 14:36:44
|
Hello list-users (Richard)?
This issue concerns version 1.06 of ddl-oracle, containing Oracle.pm version
1.40.
Lines 613-616 of Oracle.pm say:
if ( $oracle_major < 8 )
{
$sql .= "$enable\n";
}
$enable has the value of ENABLE or DISABLE, depending on the state of the
constraint.
However, in Oracle 7.3.3, in an ALTER TABLE ... ADD CONSTRAINT statement you
only need to use DISABLE if the constraint must not be enforced. Default is
enabled and that does not need a keyword.
Eg, the code generated is:
ALTER TABLE myuser.exm_result_category ADD CONSTRAINT
fk_exm_result__exm_result FOREIGN KEY
(
resultid
)
REFERENCES myuser.exm_result
(
resultid
)
ON DELETE CASCADE
ENABLE
;
The line ENABLE should be omitted, or it should read: ENABLE CONSTRAINT
constraintname
I changed line 613-616 in Oracle.pm to:
if ( $oracle_major < 8 )
{
if ( $enable ne 'ENABLE' )
{
$sql .= "$enable\n";
}
}
That seems to work fine.
However, I do not know if this is valid for all older Oracle versions.
Remke Rutgers - Rem...@br...
Technisch Consultant
Bright Alley - Media Park
Sumatralaan 45 / Postbus 10
1200 JB Hilversum
web www.brightalley.com
tel +31 35 6774000 / fax +31 35 6774355
|
|
From: Richard S. <rvs...@ya...> - 2001-03-13 14:33:59
|
Remke, Sorry. I read it too quickly, and thought it said "version 0.38." I'll take a look at it. It doesn't [yet] distinguish between versions on triggers, so maybe that's the problem. Richard --- Remke Rutgers <Rem...@br...> wrote: > Hello Richard and others, > > The Oracle.pm module v 1.38 I was referring to is the one included in > version 1.05. I can get around the issue by commenting out line 4056 in > Oracle.pm. I don't know if that introduces other issues however. > > Remke > > > -----Original Message----- > > From: Richard Sutherland [mailto:rvs...@ya...] > > Sent: dinsdag 13 maart 2001 10:51 > > To: Remke Rutgers; 'ddl...@li...' > > Subject: Re: [DDL-Oracle-users] Oracle.pm, v 1.38: error on > > dba_triggers.base_object_type in Orac le 7.3.3 > > > > > > Remke, > > > > The CREATE TRIGGER routine was completely rewritten in > > version 1.03. The current version is 1.05, which was released last > > Sunday. Please upgrade, and let us know if you still have any > > problems. > > > > Thanks. > > > > BTW, if you go to http://sourceforge.net/projects/ddl-oracle/, you can > > "monitor" the package. This will then send you a notice when new > > versions become available. > > > > HTH. > > > > Richard > > > > --- Remke Rutgers <Rem...@br...> wrote: > > > Hello Richard (and others), > > > > > > Line 4082 in Oracle.pm, version 1.38 gives an error: > > > column base_object_type does not exist. > > > Commenting out line 4056 removes this problem. > > > Probably this column was introduced in Oracle 8? > > > > > > Remke > > > > > > Remke Rutgers - Rem...@br... > > > Technisch Consultant > > > > > > Bright Alley - Media Park > > > Sumatralaan 45 / Postbus 10 > > > 1200 JB Hilversum > > > web www.brightalley.com > > > tel +31 35 6774000 / fax +31 35 6774355 > > > ===== Richard Sutherland rvs...@ya... In a world without walls and fences, who needs windows and gates ? __________________________________________________ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ |
|
From: Remke R. <Rem...@br...> - 2001-03-13 14:25:15
|
Hello Richard and others, The Oracle.pm module v 1.38 I was referring to is the one included in version 1.05. I can get around the issue by commenting out line 4056 in Oracle.pm. I don't know if that introduces other issues however. Remke > -----Original Message----- > From: Richard Sutherland [mailto:rvs...@ya...] > Sent: dinsdag 13 maart 2001 10:51 > To: Remke Rutgers; 'ddl...@li...' > Subject: Re: [DDL-Oracle-users] Oracle.pm, v 1.38: error on > dba_triggers.base_object_type in Orac le 7.3.3 > > > Remke, > > The CREATE TRIGGER routine was completely rewritten in > version 1.03. The > current version is 1.05, which was released last Sunday. > Please upgrade, > and let us know if you still have any problems. > > Thanks. > > BTW, if you go to http://sourceforge.net/projects/ddl-oracle/, you can > "monitor" the package. This will then send you a notice when new > versions become available. > > HTH. > > Richard > > --- Remke Rutgers <Rem...@br...> wrote: > > Hello Richard (and others), > > > > Line 4082 in Oracle.pm, version 1.38 gives an error: > > column base_object_type does not exist. > > Commenting out line 4056 removes this problem. > > Probably this column was introduced in Oracle 8? > > > > Remke > > > > Remke Rutgers - Rem...@br... > > Technisch Consultant > > > > Bright Alley - Media Park > > Sumatralaan 45 / Postbus 10 > > 1200 JB Hilversum > > web www.brightalley.com > > tel +31 35 6774000 / fax +31 35 6774355 > > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Auctions - Buy the things you want at great prices. > http://auctions.yahoo.com/ > > _______________________________________________ > DDL-Oracle-users mailing list > DDL...@li... > http://lists.sourceforge.net/lists/listinfo/ddl-oracle-users > |
|
From: Richard S. <rvs...@ya...> - 2001-03-13 09:48:56
|
Remke, The CREATE TRIGGER routine was completely rewritten in version 1.03. The current version is 1.05, which was released last Sunday. Please upgrade, and let us know if you still have any problems. Thanks. BTW, if you go to http://sourceforge.net/projects/ddl-oracle/, you can "monitor" the package. This will then send you a notice when new versions become available. HTH. Richard --- Remke Rutgers <Rem...@br...> wrote: > Hello Richard (and others), > > Line 4082 in Oracle.pm, version 1.38 gives an error: > column base_object_type does not exist. > Commenting out line 4056 removes this problem. > Probably this column was introduced in Oracle 8? > > Remke > > Remke Rutgers - Rem...@br... > Technisch Consultant > > Bright Alley - Media Park > Sumatralaan 45 / Postbus 10 > 1200 JB Hilversum > web www.brightalley.com > tel +31 35 6774000 / fax +31 35 6774355 > __________________________________________________ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ |
|
From: Remke R. <Rem...@br...> - 2001-03-13 08:52:09
|
Hello Richard (and others), Line 4082 in Oracle.pm, version 1.38 gives an error: column base_object_type does not exist. Commenting out line 4056 removes this problem. Probably this column was introduced in Oracle 8? Remke Remke Rutgers - Rem...@br... Technisch Consultant Bright Alley - Media Park Sumatralaan 45 / Postbus 10 1200 JB Hilversum web www.brightalley.com tel +31 35 6774000 / fax +31 35 6774355 |
|
From: Richard S. <rvs...@ya...> - 2001-02-18 15:59:51
|
Remke,
I am making a change in DDL::Oracle v1.02 to address this problem. I
decided to omit the PARALLEL clause for 7.3 instances, because Oracle
does not supply the info needed in its normal dictionary views. I could
have gone against the SYS.IND$ table, but I decided against this since
some [many?] users would not have access to this table. I did not want
to use the parallelism of the table in the CREATE INDEX clause, since I
have no way to know if this is accurate.
I hope this will fix your problem. I guess that means I hope that you
are not using a PARALLEL clause in your indexes. Let me know if you
disagree.
Cheers,
Richard
--- Richard Sutherland <rvs...@ya...> wrote:
> Remke,
>
> Thanks very much for the bug report. The testing on Oracle 7.3 has, to
> be honest, been very sparce, so I am relying on users to help me out.
> I have only just recently been able to do any testing at all on 7.3.
>
> As it turns out, this feature IS supported beginning with Oracle8, so
> the other versions are just fine. I will include a fix for this
> problem in the next release (1.02), which may be ready within the next
> week.
>
> Thanks again. I really appreciate it!
>
> Richard Sutherland
>
> --- Remke Rutgers <Rem...@br...> wrote:
> > Hello listmembers (just Richard?),
> >
> > I just discovered your library today and it looks very promising.
> > I think however I discovered a bug.
> > I am using Oracle 7.3.3.0 on Solaris and ActiveState Perl.
> > Note that I am in no way an experienced perl programmer, I can copy
> > paste and modify, but hardly program in perl from scratch. I am a
> > reasonably experienced Oracle user, but no DBA.
> >
> > When using
> > my $obj = DDL::Oracle->new(
> > type => 'table family',
> > list => $list,
> > );
> > to create a script that includes indexes, constraints etc, I get an
> > error message from Oracle.pm line 1252. (version 1.01)
> > i.instances does not exist. (i is an alias for dba_indexes)
> > Four modifications fixed the problem:
> > 1085 LTRIM(t.degree)
> > 1086 , LTRIM(t.instances)
> > 1124 , ${view}_segments s, ${view}_tables t
> > 1127 AND s.segment_name = i.index_name AND
> > s.segment_name =
> > t.table_name
> >
> > Of course the same modifications are necessary for other versions of
> > Oracle.
> >
> > A different view? Let me know.
> >
> > Remke
> > ____________________________________________
> > Remke Rutgers - Rem...@br...
> > Technisch Consultant
> >
> > Bright Alley - Media Park
> > Sumatralaan 45 / Postbus 10
> > 1200 JB Hilversum
> > web www.brightalley.com
> > tel +31 35 6774000 / fax +31 35 6774355
> >
> > _______________________________________________
> > DDL-Oracle-users mailing list
> > DDL...@li...
> > http://lists.sourceforge.net/lists/listinfo/ddl-oracle-users
>
>
> =====
> Richard Sutherland
> rvs...@ya...
>
> The software said it requires Windows 95 or better,
> so I installed Linux.
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35
> a year! http://personal.mail.yahoo.com/
>
> _______________________________________________
> DDL-Oracle-users mailing list
> DDL...@li...
> http://lists.sourceforge.net/lists/listinfo/ddl-oracle-users
=====
Richard Sutherland
rvs...@ya...
The software said it requires Windows 95 or better,
so I installed Linux.
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
|
|
From: Richard S. <rvs...@ya...> - 2001-02-17 21:58:02
|
Remke,
Thanks very much for the bug report. The testing on Oracle 7.3 has, to
be honest, been very sparce, so I am relying on users to help me out. I
have only just recently been able to do any testing at all on 7.3.
As it turns out, this feature IS supported beginning with Oracle8, so the
other versions are just fine. I will include a fix for this problem in
the next release (1.02), which may be ready within the next week.
Thanks again. I really appreciate it!
Richard Sutherland
--- Remke Rutgers <Rem...@br...> wrote:
> Hello listmembers (just Richard?),
>
> I just discovered your library today and it looks very promising.
> I think however I discovered a bug.
> I am using Oracle 7.3.3.0 on Solaris and ActiveState Perl.
> Note that I am in no way an experienced perl programmer, I can copy
> paste and modify, but hardly program in perl from scratch. I am a
> reasonably experienced Oracle user, but no DBA.
>
> When using
> my $obj = DDL::Oracle->new(
> type => 'table family',
> list => $list,
> );
> to create a script that includes indexes, constraints etc, I get an
> error message from Oracle.pm line 1252. (version 1.01)
> i.instances does not exist. (i is an alias for dba_indexes)
> Four modifications fixed the problem:
> 1085 LTRIM(t.degree)
> 1086 , LTRIM(t.instances)
> 1124 , ${view}_segments s, ${view}_tables t
> 1127 AND s.segment_name = i.index_name AND
> s.segment_name =
> t.table_name
>
> Of course the same modifications are necessary for other versions of
> Oracle.
>
> A different view? Let me know.
>
> Remke
> ____________________________________________
> Remke Rutgers - Rem...@br...
> Technisch Consultant
>
> Bright Alley - Media Park
> Sumatralaan 45 / Postbus 10
> 1200 JB Hilversum
> web www.brightalley.com
> tel +31 35 6774000 / fax +31 35 6774355
>
> _______________________________________________
> DDL-Oracle-users mailing list
> DDL...@li...
> http://lists.sourceforge.net/lists/listinfo/ddl-oracle-users
=====
Richard Sutherland
rvs...@ya...
The software said it requires Windows 95 or better,
so I installed Linux.
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
|
|
From: Remke R. <Rem...@br...> - 2001-02-16 15:30:26
|
Hello listmembers (just Richard?),
I just discovered your library today and it looks very promising.
I think however I discovered a bug.
I am using Oracle 7.3.3.0 on Solaris and ActiveState Perl.
Note that I am in no way an experienced perl programmer, I can copy paste
and modify, but hardly program in perl from scratch. I am a reasonably
experienced Oracle user, but no DBA.
When using
my $obj = DDL::Oracle->new(
type => 'table family',
list => $list,
);
to create a script that includes indexes, constraints etc, I get an error
message from Oracle.pm line 1252. (version 1.01)
i.instances does not exist. (i is an alias for dba_indexes)
Four modifications fixed the problem:
1085 LTRIM(t.degree)
1086 , LTRIM(t.instances)
1124 , ${view}_segments s, ${view}_tables t
1127 AND s.segment_name = i.index_name AND s.segment_name =
t.table_name
Of course the same modifications are necessary for other versions of Oracle.
A different view? Let me know.
Remke
____________________________________________
Remke Rutgers - Rem...@br...
Technisch Consultant
Bright Alley - Media Park
Sumatralaan 45 / Postbus 10
1200 JB Hilversum
web www.brightalley.com
tel +31 35 6774000 / fax +31 35 6774355
|
|
From: Richard S. <rvs...@ya...> - 2001-02-11 17:14:42
|
FYI, DDL-Oracle-1.01.tar.gz is available from the CPAN and from SourceForge.net. And is attached. Richard Sutherland ===== Richard Sutherland rvs...@ya... The software said it requires Windows 95 or better, so I installed Linux. __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ |
|
From: Richard S. <rvs...@ya...> - 2001-01-28 01:20:44
|
FYI. Latest attached. Richard --- PAUSE <up...@p1...> wrote: > Date: Sun, 28 Jan 2001 01:33:12 +0100 > Reply-to: cpa...@pe... > Subject: CPAN Upload: R/RV/RVSUTHERL/DDL-Oracle-1.00.tar.gz > From: PAUSE <up...@p1...> > To: "Richard Sutherland" <RVS...@cp...>, cpa...@pe... > > The uploaded file > > DDL-Oracle-1.00.tar.gz > > has entered CPAN as > > file: $CPAN/authors/id/R/RV/RVSUTHERL/DDL-Oracle-1.00.tar.gz > size: 45328 bytes > md5: b70e66c45196f96c2844861d088a6990 > > No action is required on your part > Request entered by: RVSUTHERL (Richard Sutherland) > Request entered on: Sun, 28 Jan 2001 00:31:49 GMT > Request completed: Sun, 28 Jan 2001 00:33:12 GMT > > Virtually Yours, > Id: paused,v 1.72 2000/12/26 15:12:53 k Exp k ===== Richard Sutherland rvs...@ya... "The means by which we live have outdistanced the ends for which we live. Our scientific power has outrun our spiritual power. We have guided missiles and misguided men." - Martin Luther King Jr. (1929-1968) __________________________________________________ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ |
|
From: Richard S. <rvs...@ya...> - 2001-01-28 01:18:30
|
FYI. Latest attached. Richard --- PAUSE <up...@p1...> wrote: > Date: Sun, 28 Jan 2001 01:33:12 +0100 > Reply-to: cpa...@pe... > Subject: CPAN Upload: R/RV/RVSUTHERL/DDL-Oracle-1.00.tar.gz > From: PAUSE <up...@p1...> > To: "Richard Sutherland" <RVS...@cp...>, cpa...@pe... > > The uploaded file > > DDL-Oracle-1.00.tar.gz > > has entered CPAN as > > file: $CPAN/authors/id/R/RV/RVSUTHERL/DDL-Oracle-1.00.tar.gz > size: 45328 bytes > md5: b70e66c45196f96c2844861d088a6990 > > No action is required on your part > Request entered by: RVSUTHERL (Richard Sutherland) > Request entered on: Sun, 28 Jan 2001 00:31:49 GMT > Request completed: Sun, 28 Jan 2001 00:33:12 GMT > > Virtually Yours, > Id: paused,v 1.72 2000/12/26 15:12:53 k Exp k ===== Richard Sutherland rvs...@ya... "The means by which we live have outdistanced the ends for which we live. Our scientific power has outrun our spiritual power. We have guided missiles and misguided men." - Martin Luther King Jr. (1929-1968) __________________________________________________ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ |
|
From: Richard S. <rvs...@ya...> - 2000-12-31 21:56:12
|
DDL::Oracle has been updated to produce DDL for Oracle 7.3 and 8.0 databases for the following: TABLES INDEXES TABLESPACES Program defrag.pl now does an ANALYZE TABLE/INDEX after the import for objects which were previously analyzed. It also has been revised to handle tables containing '$' in their names. Some changes for robustness have been made, such as verifying that log directories are writeable before file creation. And a few bugs were squashed. Richard ===== Richard Sutherland rvs...@ya... They know enough who know how to learn. -Henry Adams (1838-1918) __________________________________________________ Do You Yahoo!? Yahoo! Photos - Share your holiday photos online! http://photos.yahoo.com/ |
|
From: Richard S. <rvs...@ya...> - 2000-12-06 01:50:42
|
Release 0.23 now ready for download. It has significant performance improvements. Actually, they're not significant. Rather they are MAJOR performance improvements -- 2 or 3 orders of magnitude on large databases. One functional bug is fixed in this release -- the REBUILD of unusable indexes following a defrag of a tablespace with partitioned objects was not working, but now is (we think). And we were inadvertantly adding a blank line to Trigger text, and that is now fixed. Your comments are, as always, sought and appreciated. ===== Richard Sutherland rvs...@ya... They know enough who know how to learn. -Henry Adams (1838-1918) __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ |
|
From: Richard S. <rvs...@fu...> - 2000-12-02 16:43:16
|
Oracle.pm and defrag.pl have reached Beta stage. All features planned = for this stage have been implemented and put through integration testing. We are = looking for testers to put the software through rigorous tests on as many platforms and = instances as=20 possible. If you use defrag.pl, ddl.pl or just DDL::Oracle as a standalone tool, = please let us know what your experiences were (good, bad or indifferently) so that we can = fix what is broken as well as report any successes. Use the "Open Discussion" or "Help" forums at SourceForge.net, or send = email to: ddl...@li... All comments, suggestions, criticisms, etc., are sought and appreciated. Thanks. |
|
From: Richard S. <rvs...@ya...> - 2000-11-19 21:31:30
|
A good week! Release 0.19 is now available for downloading. Program defrag.pl is ready for some serious beta testing, but please review the logs between each step. It now has one of the 2 proposed methods for handling partitions. The second method is under construction, and should be in the next release. In addition, shell scripts are now provided to ease executing the various export, import and sql files. This also ensures that logs are created for each file. Code has been restructured for readability and supportability. Your $.02 is sought and appreciated. All reported bugs have been fixed. [Actually, none have been reported, yet, but we're expecting them to arrive any day now. ;-) ] Keep those cards and letters coming! ===== Richard Sutherland rvs...@ya... They know enough who know how to learn. -Henry Adams (1838-1918) __________________________________________________ Do You Yahoo!? Yahoo! Calendar - Get organized for the holidays! http://calendar.yahoo.com/ |
1308 messages has been excluded from this view by a project administrator.
![http://www.make-cents.com/images/newslogo.gif"](http://www.make-cents.com/images/newslogo.gif"){kind=link}
![http://www.make-cents.com/images/szigban.gif"](http://www.make-cents.com/images/szigban.gif"){kind=link}
![http://www.make-cents.com/images/us.gif"](http://www.make-cents.com/images/us.gif"){kind=link}
![http://www.make-cents.com/images/sw.gif"](http://www.make-cents.com/images/sw.gif"){kind=link}
![http://www.make-cents.com/images/smclogo.gif"](http://www.make-cents.com/images/smclogo.gif"){kind=link}
![http://www.make-cents.com/images/bob.gif"](http://www.make-cents.com/images/bob.gif"){kind=link}
![http://www.make-cents.com/images/scsfb.gif"](http://www.make-cents.com/images/scsfb.gif"){kind=link}
![http://www.make-cents.com/images/sargus.gif"](http://www.make-cents.com/images/sargus.gif"){kind=link}
![http://www.make-cents.com/images/sdain.gif"](http://www.make-cents.com/images/sdain.gif"){kind=link}
![http://www.make-cents.com/images/tempban.gif"](http://www.make-cents.com/images/tempban.gif"){kind=link}