Re: Export whole schema except data from 1 table?

Michael,

Time to learn the DBAs friend.
select table_name||"," from user_tables

Dennis Williams

On 6/20/06, Michael Ray <topshot.rhit_at_gmail.com> wrote:
>
> I want to export a 10gR2 schema onto my laptop, but it has one huge
> table with data I don't need. All tables are in 1 tablespace. Is there
> anyway to do this without having to list the 70 other tables in a
> parameter file? Or export the whole thing but only import all the rows
> except from that one table?
>
> "Unsupported" tweaking of the dump file perhaps? This would only be to
> copy onto a remote test system.
> --
>
> Sincerely,
> Michael Ray
> Topshot Systems LLC
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l