Re: Newbie and Oracle/Linux

See below ...

Sami Valkonen wrote:
> 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
>
> is said to be for Oracle releases 7 and 8.. Does it work with 9, too?

Yes.

>
> 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")

Works similarly, see the docs.

>
> $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?
>
> mysqldump -u$dbuser -p$dbpass -h$dbhost -P$dbport --databases --opt $dbname

There is no similar function. I've written one in the past, but it was specific for an application.

>
> export PGPASSWORD=\"$dbpass\" && pg_dump -d -U $dbuser -h $dbhost -p
> $dbport $dbname
>

See the Oracle utilities guid for exp/imp

-- 
Ron Reidy
Oracle DBA