Oracle Drop/Delete User with All tables and files

Hi All,

Today I am going to explain the procedure to delete/drop a user in Oracle database along with tables and mapped files for that user tablespace.

Pre-requisites

Oracle database with the following

1. User
2. Tablespace of the user
3. Datafile of the tablespace

Procedure

Drop the user

Syntax: DROP USER CASCADE;
Example: DROP USER sampleuser CASCADE;

Make the tablespace offline

Syntax: ALTER TABLESPACE OFFLINE;
Example: ALTER TABLESPACE sampletablespace OFFLINE;

Drop the tablespace with mapped datafile[s]

Syntax: DROP TABLESPACE INCLUDING CONTENTS AND DATAFILES
Example: DROP TABLESPACE sampletablespace INCLUDING CONTENTS AND DATAFILES

With the above 3 commands, you can make sure that, user and user related data has been completed removed from database.

Hope, it will help to resolve your issue.

Please send your feedback and comments to psrdotcom@gmail.com

Change EOL (End Of Line) Character from Windows to Unix/Linux for all the files in current working directory

Hi all,

For a single file, you can do the change of EOL using notepad++.
Reference: http://psrdotcom.blogspot.in/2017/01/change-eol-end-of-line-character-from.html

But it would be difficult, if you want to do for multiple files in one go.

I have found a solution to update EOL for all files in the current directory.

Pre-requisite

Make sure that, working directory contains only the files which you want to change EOL.

Note: If not, copy the files to a new directory and change the EOL for all the files in that directory.

Procedure

1. Download dos2unix utility from sourceforge https://sourceforge.net/projects/dos2unix/
2. Extract the zip file
3. Tip: Make sure that the extracted path doesn't contain spaces.
4. Keep the bin directory available in your PATH environment variables
5. Download the customized batch file from GIST https://gist.github.com/psrdotcom/d73ff9590c3010253b5b2a886704b26b
6. Extract if needed, and place the "dos2unixfolder.bat" in the same directory where the "dos2unix" is placed.
7. Tip: If you place the batch file in the same folder of dos2unix.exe. You no need to add again the patch of batch file in environment PATH.
8. Navigate to your folder, where you want all the files EOL to be changed
9. Press "Right Click on Mouse" in empty area
10. 
11. Select "Open Command Prompt Here"
12. Type the batch file name "dos2unixfolder.bat"
13. You will able to see the conversion process
14. Once the conversion is completed, you can check the EOL coversion in notepad++.
15. If you need to help in checking, refer to http://psrdotcom.blogspot.in/2017/01/change-eol-end-of-line-character-from.html

Please send your comments and feedback to psrdotcom@gmail.com

Change EOL (End Of Line) Character from Windows to Unix/Linux using Notepad++

Hi all,

Today I will explain about updating/converting EOL for a single file from windows format to unix/linux format.

1. In Windows, the EOL (End-Of-Line) character is \r\n (CR LF) (Carriage Return, Line Feed)
2. In Unix/Linux, the EOL character is \n (LF) (Line Feed)

Check for EOL

If you open the file in notepad++, you will be able to see the EOL character by following below steps:

• Type the content and hit enter button on keyboard
• Choose menu "View -> Show Symbol"
• Check the "Show End of Line" option

• Now, you will be able to view "CR LF" special symbols in you file at every line end as show below

Update EOL

To convert the EOL from Windows (CR LF) to Unix (LF), do the following

• Click on "Edit" menu
• Choose "EOL Conversion"
• Select "Unix(LF)"

• Now, you can check the update EOL character in your file. Example conversion show below

This type of conversion useful, when you are updating file in windows and using the same file in U/Linux environment.

Batch File Update

For all files in one folder, you can follow my blog.
Reference: http://psrdotcom.blogspot.in/2017/01/change-eol-end-of-line-character-from_20.html

Send your comments and feedback to psrdotcom@gmail.com

Mount TrueCrypt Volume with Read and Write File Permission for Users and Groups

Hi friends,

I have been working on Ubuntu from a long time. Recently I am exploring on TrueCrypt and I faced the following issue. After searching lot of websites and forums, I made a solution which worked for me perfectly.

Objective:
TrueCrypt volume copied data should be available to all when its mounted.

Usual Procedure:
Mount the TrueCrypt volume in Ubuntu
Copy some data to the volume
Change file permissions to other users or groups
Other users should be able to view the data from the volume when mounted

Hiccup(Problem):
After mounting the TrueCrypt Volume the directory permissions are changed and fixed to 700 (rwx --- ---). i.e. No access to groups and others.
Changing the directory permissions and changing the ownership will not be applied.
So, other groups and others cannot access the data.

Solution:
While mouting the TrueCrypt volume we need to specify the file system type and give permission to user[s] and/or group[s] with umask.

Please find the syntax and example below

Syntax:
$sudo /usr/bin/truecrypt -t --filesystem={filesystem_type} --fs-options={rwx},uid={userid},gid={groupid},umask={ugorwx} {your_tc_volume} {mounting_folder}

Example:
$sudo /usr/bin/truecrypt -t --filesystem=vfat --fs-options=rw,uid=1000,gid=1000,umask=022 tc1.tc /mnt/folder1

Thanks for visiting my blog.

Please send your feedback and comments to psrdotcom@gmail.com

Converting Power Point Presentation (PPT) to Images and Conversion of Images to PPT

Hi all,
Today I was searching for converting the slideshow to images and doing some batch processing to the images like crop, resize, filename change and again making ppt with the modified images.

I followed the below procedure to convert my slides in ppt to images, cropping the images and finally making slideshow with edited images.

• Converting slides to images
1. (MS Office 2007) Office Button (Top-Left) -> Save As ->  Other Formats
2. Choose the corresponding destination folder
3. Choose "Save as type" as "JPEG File Interchange Format (*.jpg)"
4. One pop-up comes with the following options
• Every Slide: This option saves every slide to an individual image
• Current Slide: This option saves only the current slide to an image
5. Choose relevant option to you
• Batch Processing the images
1. I have seen one video from youtube and I was impressed with the Irfan View working with batch processing of images
2. Please see the below video and do the batch processing of images
• http://www.youtube.com/watch?feature=player_detailpage&v=Z_eEKD8AJz0
• Uploading images to PPT
1. (MS Office 2007) Click on "Insert" tab and select "Photo Album" -> "New Photo Album"
2. Select the image(s), which you would like to add in the presentation.

This kind of approach makes our lives easy.


If you have any queries, please mail to psrdotcom@gmail.com