Re: oracle 9 export all without 1 table

On Feb 28, 7:47 am, Jagjeet Singh <jagjeet.ma..._at_gmail.com> wrote:
> > | Hello!
> > |  I have user name : joe
> > | He have 4000 tables. Id like to know if it is possible to export all tables
> > | without only one table. Or export all and import all without only one or
> > | delete from export dmp file certin table?
>
> Export 3999 tables :  This make sense to me as there is no need to
> take export of table which is not required.
>                                 I had to do this because of space
> constraint I choose to leave one big archive table.
>
>                                how i did that -- create one policy
> using dbms_rls where would return "where 1=2" for select command
>                                                       create one
> trigger on logon if calling module is exp. that's it.
>

And if they're running Standard Edition that won't work.

> Export all and import without one = this is simple, take full export
> and before import create any table with same name

Which will cause the import to fail at that point and any table listed after that fatal error won't be imported.

David Fitzjarrell Received on Mon Mar 02 2009 - 08:17:18 CST