giovedì 21 luglio 2011

Clear content of users tables

begin for t in (select table_name from user_tables) loop execute immediate ' truncate table '||t.table_name; end loop; end;

Retrieve and set Oracle Charset


Retrieving

SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;


Settiing

ALTER DATABASE CHARACTER SET WE8ISO8859P1;


Usefull in exp imp command beetwen differente oracle databases with different charset.