Oracle DBA by Example. Code samples, Scripts, Reference.
Pages
(Move to ...)
Home
▼
Sunday, January 26, 2014
impdp. SYSTEM Tablespace running out of space after several impdb runs
›
After running several times impdp, the next subsequent execution fails with error: "unable to extend temp segment by 128 in tablespa...
Thursday, January 23, 2014
Generic bash script for calling sqlplus and getting back the results
›
The scenario: bash script need to perform sqlplus. The flow: bash script main.sh is calling a generic bash script, sql_caller.sh, whi...
Tuesday, January 14, 2014
Oracle DB Links
›
Oracle DB Links Query To Query Existing DB Links: SELECT * FROM USER_DB_LINKS Or select from ALL_DB_LINKS, DBA_DB_LINKS To query from...
Monday, January 13, 2014
Oracle Reference:String Functions. Date Functions.
›
======================= TRUNSLATE ======================= TRUNSLATE(input_string, from_string, to_string) For example: TRUNSLATE('a...
Friday, January 10, 2014
Migrating from Oracle EE to Oracle SE
›
Overview. How to tell is Oracle is EE or SE: SELECT INSTR(BANNER,'Enterprise Edition') FROM V$VERSION WHERE ROWNUM=1; For EE...
‹
›
Home
View web version