Home » RDBMS Server » Security » Want DMP help
Want DMP help [message #148163] Tue, 22 November 2005 23:55 Go to next message
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.
Re: Want DMP help [message #148213 is a reply to message #148163] Wed, 23 November 2005 02:37 Go to previous message
Frank Naude
Messages: 4570
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
Previous Topic: Issue in setting listener password
Next Topic: Oracle exposed on a Webserver
Goto Forum:
  


Current Time: Sat Dec 04 01:12:49 CST 2021