Re: Exporting Tables

deepa balu via OracleMonster.com wrote:
> hi
> i found one way to do this in metalink
>

[snip]

>
> . exporting pre-schema procedural objects and actions
> . exporting foreign function library names for user SCOTT
> . exporting object type definitions for user SCOTT
> About to export SCOTT's objects ...
> . exporting database links
> . exporting sequence numbers
> . exporting cluster definitions
> . about to export SCOTT's tables via Conventional Path ...
> . . exporting table BONUS 0 rows exported
> EXP-00079: Data in table "DEPT" is protected. Conventional path may only be
> exporting partial table.
> . . exporting table DEPT 0 rows exported
> . . exporting table DUMMY 1 rows exported
> EXP-00079: Data in table "EMP" is protected. Conventional path may only be
> exporting partial table.

[snip]

It is certainly ingenious, but it isn't "a way to do this"... it's a way to *seem* as though you are able to export by exception. But as your output itself shows, you have actually exported the EMP table... just not the rows in it.

Which may or may not be what you (or the original poster, if different) was after. But it's slightly misleading to suggest it shows that you can get export actually to *skip* particular tables altogether.

It *is* a clever use of RLS technology, though.

Regards
HJR Received on Wed Dec 29 2004 - 03:08:30 CST