API tools faq
paste
ExaGridDba

ExaGridDba's Pastebin

1,589 24,628 0 10 years ago
Name / Title Added Expires Hits Comments Syntax  
ex1 output Oct 20th, 2022 Never 187 0 None -
ex1 basic i-0273fc27080b8d564 dest-host Oct 20th, 2022 Never 53 0 None -
ex1 basic i-0269ad6c61c8f8edf src-host Oct 20th, 2022 Never 61 0 None -
ex1 basic sg-06cd140165280acb6 src-sg Oct 20th, 2022 Never 41 0 None -
ex1 basic sg-0d86f9996252af4bb dest sg Oct 20th, 2022 Never 40 0 None -
The disk that a mp device is partition of May 5th, 2020 Never 499 0 None -
paths and partitions of a multipath device May 5th, 2020 Never 194 0 None -
dg.xml Oct 18th, 2019 Never 143 0 None -
stop and delete rds instance Apr 19th, 2019 Never 231 0 None -
create aws rds instance from command line Apr 19th, 2019 Never 576 0 None -
orald - Oracle's GNU linker Feb 20th, 2018 Never 168 0 None -
explain plan on Oracle SQL Live 18c Feb 17th, 2018 Never 153 0 None -
set constraint deferred Jan 23rd, 2018 Never 146 0 None -
12c express load tsv to table Jan 8th, 2018 Never 176 0 None -
bit shift function Nov 25th, 2017 Never 144 0 None -
maximum row number that can be returned by dbms_rowid Nov 24th, 2017 Never 136 0 None -
maximum possible number of rows in one block Nov 24th, 2017 Never 132 0 None -
subpartition name required but not used in template Nov 22nd, 2017 Never 135 0 None -
12.1 non-cdb TDE change the keystore password Nov 15th, 2017 Never 177 0 None -
12.2 non-cdb on-prem decrypt a tablespace Nov 14th, 2017 Never 129 0 None -
Still no NVL2 in PL/SQL 12.2 Oct 18th, 2017 Never 140 0 None -
get own session serial# without privilege Jul 7th, 2017 Never 124 0 None -
Unique index card 10 Jun 24th, 2017 Never 126 0 None -
12c results error in list partitioned table Jun 4th, 2017 Never 161 0 None -
psuvers.sql: get Oracle Database PSU version Jun 4th, 2017 Never 201 0 None -
nohup.bash wrapper with unique, timestamped log Jun 3rd, 2017 Never 327 0 None -
11gR1 beta "smartfile" syntax May 31st, 2017 Never 255 0 None -
reader-friendly ASH sql_exec_id May 30th, 2017 Never 162 0 None -
Does dbms_stats.gather_table_stats issue commit? May 17th, 2017 Never 195 0 None -
Barebones UCP connection May 5th, 2017 Never 224 0 Java -
Fibonacci series with 12c recursive subquery factoring Apr 25th, 2017 Never 146 0 None -
create primary key on top of nonunique index Dec 29th, 2016 Never 171 0 None -
lists of quoted items in perl Aug 2nd, 2016 Never 166 0 None -
export/import data pump mixed case username Jul 30th, 2016 Never 186 0 None -
datapump undocumented command "desc" Jul 18th, 2016 Never 200 0 None -
ambiguous data pump command "s". start/stop/status Jul 18th, 2016 Never 264 0 None -
Change table and index ownership Jul 12th, 2016 Never 168 0 None -
spool log off defeats rman command line log= Jul 5th, 2016 Never 142 0 None -
can't create oracle user with name > 30 characters Jun 28th, 2016 Never 122 0 None -
31 character osuser Jun 28th, 2016 Never 102 0 None -
Rename LOB is an expensive operation Jun 26th, 2016 Never 140 0 None -
Oracle database proxy login Jun 18th, 2016 Never 230 0 None -
12c: 2+2=3 May 30th, 2016 Never 150 0 None -
Incorrect results 12c global index May 30th, 2016 Never 380 0 None -
index with 0 rows rendered unusable May 21st, 2016 Never 122 0 None -
Friday the 13th generator May 12th, 2016 Never 133 0 None -
Demonstrate Jonathan Lewis's RI deadlock. May 10th, 2016 Never 139 0 None -
Demonstrate Jonathan Lewis's RI lock May 10th, 2016 Never 89 0 None -
Incorrect v$parameter isdefault = true Apr 19th, 2016 Never 133 0 None -
testAnyDbLink.sql Mar 23rd, 2016 Never 108 0 None -
dropAnyDbLink.sql Mar 23rd, 2016 Never 99 0 None -
createAnyDbLink.sql Mar 23rd, 2016 Never 103 0 None -
seven ways to find sgabeg Nov 22nd, 2015 Never 248 0 None -
database startup trigger branches depending on resetlogs Nov 2nd, 2015 Never 169 0 PL/SQL -
alertlog_pkg: printf to the alert log Nov 2nd, 2015 Never 171 0 PL/SQL -
out_pkg: printf, die, assert for PL/SQL Nov 2nd, 2015 Never 146 0 PL/SQL -
avoid divide by zero error with nullif Oct 23rd, 2015 Never 179 0 SQL -
avoid log(0) error with nullif Oct 23rd, 2015 Never 202 0 SQL -
last business day function Oct 23rd, 2015 Never 198 0 None -
v$latch summarizes v$latch_children Oct 17th, 2015 Never 134 0 Oracle 11 -
some cr v$bh rows are duplicates Oct 10th, 2015 Never 186 0 Oracle 11 -
v$sgastat pools appear per con_id, but not the buffer cache Oct 4th, 2015 Never 147 0 Oracle 11 -
Did I create 1 row or 4294967297? Aug 7th, 2015 Never 256 0 Oracle 11 -
1700 was / was not a leap year Jul 26th, 2015 Never 332 0 None -
Sep 2, 1752 Jul 26th, 2015 Never 326 0 None -
Table segment exists after error. Index valid after truncate Jun 8th, 2015 Never 278 0 Oracle 11 -
Block dump of IOT secondary indexes May 17th, 2015 Never 373 0 Oracle 11 -
IOT leaf and overflow block dump May 17th, 2015 Never 352 0 Oracle 11 -
Number and Oracle float storage are similar May 15th, 2015 Never 278 0 Oracle 11 -
copy good plan to another sql May 11th, 2015 Never 410 0 Oracle 11 -
interval partitioned IOT not supported in 12.1.0.2 May 9th, 2015 Never 345 0 Oracle 11 -
timestamp range partition boundary to max 6 decimal places May 7th, 2015 Never 343 0 Oracle 11 -
table access by index rowid batched, or not batched Apr 26th, 2015 Never 375 0 Oracle 11 -
where clause vs extended part syntax same plan_hash_value Apr 26th, 2015 Never 269 0 Oracle 11 -
Different Pstart/Pstop same plan_hash_value Apr 26th, 2015 Never 304 0 Oracle 11 -
Different access / filter predicate, same plan_hash_value Apr 26th, 2015 Never 284 0 Oracle 11 -
rename pdb and its service Apr 12th, 2015 Never 278 0 None -
alter system pdb scope and persistent Apr 12th, 2015 Never 282 0 None -
This is not a deadlock! Jan 29th, 2015 Never 276 0 None -
Scala update scott.emp jdbc Nov 26th, 2014 Never 302 0 Scala -
lvremove will not remove a disk from a mounted ASM diskgroup Oct 9th, 2014 Never 294 0 Oracle 11 -
redacted 12c column exposed via tab statistics Jul 27th, 2014 Never 249 0 Oracle 11 -
Self join elimination in 11.2, and a hint that does not work Jul 1st, 2014 Never 295 0 Oracle 11 -
audit truncate table (unified) Jun 11th, 2014 Never 418 0 Oracle 11 -
audit truncate table (classic) Jun 11th, 2014 Never 248 0 Oracle 11 -
initwailua20.ora.20140611 Jun 10th, 2014 Never 272 0 None -
crsctl stat res ora.wailuaq.db -p output Jun 10th, 2014 Never 591 0 None -
wailua.log dbca output Jun 10th, 2014 Never 395 0 None -
crdb.wailua.ksh dbca script Jun 10th, 2014 Never 476 0 Bash -
wailua.dbt dbca template based on New_Database.dbt Jun 10th, 2014 Never 383 0 XML -
Python quicksort Apr 28th, 2014 Never 263 0 Python -
asmdu.sql Mar 1st, 2014 Never 262 0 Oracle 11 -
insert and update WE8MSWIN1252 characters with sqlplus Feb 11th, 2014 Never 164 0 Oracle 11 -
view any character set with only PuTTY and sqlplus Feb 11th, 2014 Never 150 0 None -
load WE8MSWIN1252 chars into 12c ASCII database (contrived) Feb 1st, 2014 Never 175 0 Oracle 11 -
add column to middle of 12c table Jan 13th, 2014 Never 121 0 None -
12c: reorder the columns in a table! Wow! Jan 13th, 2014 Never 268 0 None -
ORA-01450 while indexing 12c extended type Jan 12th, 2014 Never 122 0 None -
Trace.java start and stop tracing Nov 7th, 2013 Never 124 0 Java -
Ocmrf.java Oct 16th, 2013 Never 111 0 Java -
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!