Re: export all tables except one

>> I want to export all the tables from my schema apart from one(which is
>> huge).
>>
>> Is there an easy way to do this or do I need to list all the tables I
>> do want?

> 1 You do need to list all the tables you want.You can do this by having > sql*plus generating a parameter file with the tables=(...) keyword

John, there are some options available beyond what Mr. Bakker noted if you are running 10g.

10g offers the option of using an EXLUDE parameter so that you could export a whole schema and exclude just the table you do not want.

Another option is available from the QUERY parameter in 10g ... that way you could still export the definition of the table but use a query on the specific table that returns no rows ( SELECT * FROM BAD_TABLE WHERE 1 = 2 is one possible hack ).

So yes depending on version you may have some other options.

It is helpful when posting a question on a forum like this to include what specific database versions you are interested in exporting to and from. Received on Tue Aug 02 2005 - 07:34:34 CDT