script to collect db information

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

script to collect db information

Roshan
Hi Erman,

I have copied a script from Windows to Linux system to collect audit information.
Oracle_DB_Extractor_11g_Above_6.sql

However, the output is not getting displayed properly.

DBA_ROLE_PRIVS.ACTT
The readme says

• Use ‘ASCII’ mode of file transfer while transferring the extraction script to UNIX system.

• Use ‘Binary’ mode of file transfer while transferring the output data from UNIX system to Windows.

How do I use ASCII/Binary transfer mode in FileZilla? Is there any other tool I should use?

Regards,

Roshan
Reply | Threaded
Open this post in threaded view
|

Re: script to collect db information

ErmanArslansOracleBlog
Administrator
You copied just the sql right?

use "dos2unix"  to remove CTRL-M (^M) character

For filezilla read this -> http://www.inmotionhosting.com/support/website/file-management/corrupt-file-ftp-transfer