I doubt if there is any such package. The easiest way is via export as Chris
earlier suggested. Other options are to use a copy command or to create the
tables across a database link

Titus Olowok
Oracle DBA
Atlanta, GA.


----- Original Message -----
From: "Khosla Munish "
<oracledba-ezmlmshield-x54681513.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, August 31, 2004 5:38 PM
Subject: RE: DBMS Package for Export


> But i need this thing through the DBMS package
>
>
> -----Original Message-----
> From: Chris Hagemaier
> [mailto:oracledba-ezmlmshield-x74332988.[Email address protected]
> Sent: Wednesday, September 01, 2004 2:48 AM
> To: LazyDBA Discussion
> Subject: RE: DBMS Package for Export
>
>
> You can use the "tables" parameter of the export command.
> That works...
>
> -----Original Message-----
> From: Khosla Munish
> [mailto:oracledba-ezmlmshield-x72150264.[Email address protected]
> Sent: Tuesday, August 31, 2004 2:03 PM
> To: LazyDBA Discussion
> Subject: DBMS Package for Export
>
>
>
>
>> Hi,
>> If we need to export only the few tables from a particular schema, there
> is a DBMS package which will alow us to do so. Wld anybdy let me know the
> name of that DBMS package.
>>
>> Thanks,
>> Munish

Oracle LazyDBA home page