Archive

Archive for October, 2012

Database Character sets FAQ

October 19, 2012 Leave a comment

What is Unicode:

Unicode provides a unique number for every character,
no matter what the platform,
no matter what the program,
no matter what the language.

What is National character set:

It is alternative to the character set.

National character set is used in NCHAR, NVARCHAR2, NCLOB columns. You use these datatypes when you have data that does not fit in your database character set and you want to record them IN SPECIAL COLUMNS.

If using unicode as database character set then there is no need of national character set.
National character set is here for backward compatibility and was useful when unicode did not exist.

What are supplementary characters:

NCHAR, Unicode

Categories: Uncategorized

Windows: Keep N files and Remove rest from subfolders

October 19, 2012 Leave a comment

FOR /R "Z:\MYBackup\" %%G in (.) DO (

Pushd %%G

for /f "skip=15 tokens=*" %%i in (‘dir /a:-d-s /b /o:-d’) do DEL "%%i"

Popd )

Categories: Uncategorized

Setup Datapump

October 12, 2012 Leave a comment

Create datapump user KP:

GRANT EXP_FULL_DATABASE to kp;

CREATE DIRECTORY datapump AS ‘E:\oradata\dpump’;

GRANT READ, WRITE ON DIRECTORY datapump to kp;

Categories: Uncategorized