Sunday, September 18, 2011

How to view the database nls parameters?


SQL> select * from nls_database_parameters;

How to edit the schedule jobs in unix?

Use the following command to edit the schedule jobs in unix.

$crontab -e

How to see the schedule jobs in unix?

Use the following command to see the list of schedule jobs.

$crontab -l

While importing the dump facing ORA-22993 error

This is due to characterset problem. This is because of CLOB datatype in the table.
Change the target characterset to AL32UTF8. It will solve the problem.
OR
Recreate the target database with the AL32UTF8 characterset.