OraFAQ Forum: Security » Want DMP help

Home » RDBMS Server » Security » Want DMP help

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Want DMP help [message #148163]

Tue, 22 November 2005 23:55

ssmm
Messages: 6
Registered: September 2005
Location: mumbai

Junior Member

Hi All,
I want to hide one column while creating dmp .
So is it possible .

Thanks in advance.

Report message to a moderator

Re: Want DMP help [message #148213 is a reply to message #148163]

Wed, 23 November 2005 02:37

Frank Naude
Messages: 4575
Registered: April 1998

Senior Member

No, you can only export a subset of rows:

exp scott/tiger tables=emp query=\"where deptno=10\"

BTW: If you don't want people to see the data, you can always encrypt it. Alternatively, create a temp table (CTAS) without the column and export it.

Best regards.

Frank

Report message to a moderator

Previous Topic:	Issue in setting listener password
Next Topic:	Oracle exposed on a Webserver

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Oct 03 09:31:33 CDT 2023