How to start export from PL/SQL

From: Epicentre team A <oracle_at_epicentre.fr>
Date: Tue, 3 Sep 2002 12:57:48 +0200
Message-ID: <al248h$lsc$1@wanadoo.fr>

Is possible to run export (for generate dump) in stored proc.

for example

CREATE OR REPLACE PROCEDURE ExportProc is

cursor C1 is select username from dba_users where default_tablespace <> 'SYSTEM' and default_tablespace <> 'TOOLS';

MyUser dba_users.username%type;

begin

OPEN C1; LOOP FEtCH C1 into MyUser;

EXIT WHEN C1%NOTFOUND; dbms_output.put_line('Current User is: ' || MyUser);

/* Export command

... what to do

END LOOP; CLOSE C1; end;

Oracle Version: 8.1.7.4
Thanks
Epicentre Team A Received on Tue Sep 03 2002 - 05:57:48 CDT