-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
NLS_LANG=<language>_<territory>.<character set> Example: export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 Setting NLS_LANG tells Oracle what characterset the client is using so Oracle can do conversion… READ MORE
For SQL*Plus to process french accents characters when using SQL*Plus, you would need to set NLS_LANG On Windows set NLS_LANG=.AL32UTF8… READ MORE
Move from single instance to RAC 1- Install CRS 2- Install new RDBMS binaries rac enable 3- Make sure there… READ MORE
Today, due to a network issue the host (Solaries) lost contact with the NetApp filer and it corrupted some datafiles… READ MORE
Here is a simple script to extract the DB Links DDL with the encripted password. SET LONG 9000 — to… READ MORE
|
The following can be used to create a script for DB Links with work on 8i/9i and will contain the… READ MORE
SQL> SELECT le.leseq “Current log sequence No”, 100*cp.cpodr_bno/le.lesiz “Percent Full”, cp.cpodr_bno “Current Block No”, le.lesiz “Size of Log in Blocks”… READ MORE
|
One can’t move the temp tablespace during mount stage like other datafiles using “ALTER DATABASE RENAME FILE..” so a workaround… READ MORE
|
Using Oracle SID and SERIAL# can turn trace on/off a Oracle session that has already started. The values of SID… READ MORE
Get current total TEMP tablespace currently allocated, used and free: SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size) / 1024… READ MORE
Nice way to extract the DDL for all tablepaces.. This also can be used for other objects as well. SQL>set… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 