Newbie and Oracle/Linux

From: Sami Valkonen <anonymous_at_host.com>
Date: Mon, 18 Aug 2003 15:48:57 +0300
Message-ID: <bhqhvq$bqk$1_at_phys-news1.kolumbus.fi>

[Quoted] I'm already familiar with (and used to use) MySQL and PostgreSQL. Now trying to learn basics of Oracle..

I downloaded v. 9.2.0 from Oracle website and even got it installed (Red Hat Linux 7.3). Here's a couple of questions how things should be done exactly, I couldn't find clear answers with Google..

http://search.cpan.org/author/TIMB/DBD-Oracle-1.14/Oracle.pm

[Quoted] is said to be for Oracle releases 7 and 8.. Does it work with 9, too?

[Quoted] I use the following lines with MySQL/PostgreSQL, how this can be done with Oracle so that $dbname, $dbhost, and $dbport are respected?

$dbh =

DBI->connect("DBI:mysql:database=$dbname;host=$dbhost;port=$dbport", "$dbuser", "$dbpass")

[Quoted] $dbh = DBI->connect("DBI:Pg:dbname=$dbname;host=$dbhost;port=$dbport",
"$dbuser", "$dbpass")

And dumping a database with MySQL/PostgreSQL is easy from a script, what could be the stanza with Oracle?

[Quoted] mysqldump -u$dbuser -p$dbpass -h$dbhost -P$dbport --databases --opt $dbname

[Quoted] export PGPASSWORD=\"$dbpass\" && pg_dump -d -U $dbuser -h $dbhost -p
$dbport $dbname
Received on Mon Aug 18 2003 - 14:48:57 CEST