Guest

ExaGridDba's Pastebin

[gift pro] 721 14,939 6 years ago
Name / Title Added Expires Hits Syntax  
stop and delete rds instance Apr 19th, 19 Never 131 None -
create aws rds instance from command line Apr 19th, 19 Never 163 None -
orald - Oracle's GNU linker Feb 20th, 18 Never 101 None -
explain plan on Oracle SQL Live 18c Feb 17th, 18 Never 69 None -
set constraint deferred Jan 23rd, 18 Never 60 None -
12c express load tsv to table Jan 8th, 18 Never 89 None -
bit shift function Nov 25th, 17 Never 71 None -
maximum row number that can be returned by dbms_rowid Nov 24th, 17 Never 85 None -
maximum possible number of rows in one block Nov 24th, 17 Never 51 None -
subpartition name required but not used in template Nov 22nd, 17 Never 55 None -
12.1 non-cdb TDE change the keystore password Nov 15th, 17 Never 105 None -
12.2 non-cdb on-prem decrypt a tablespace Nov 14th, 17 Never 58 None -
Still no NVL2 in PL/SQL 12.2 Oct 18th, 17 Never 73 None -
get own session serial# without privilege Jul 7th, 17 Never 76 None -
Unique index card 10 Jun 24th, 17 Never 59 None -
12c results error in list partitioned table Jun 4th, 17 Never 82 None -
psuvers.sql: get Oracle Database PSU version Jun 4th, 17 Never 105 None -
nohup.bash wrapper with unique, timestamped log Jun 3rd, 17 Never 99 None -
11gR1 beta "smartfile" syntax May 31st, 17 Never 72 None -
reader-friendly ASH sql_exec_id May 30th, 17 Never 65 None -
Does dbms_stats.gather_table_stats issue commit? May 17th, 17 Never 109 None -
Barebones UCP connection May 5th, 17 Never 123 Java -
Fibonacci series with 12c recursive subquery facto... Apr 25th, 17 Never 38 None -
create primary key on top of nonunique index Dec 29th, 16 Never 102 None -
lists of quoted items in perl Aug 2nd, 16 Never 96 None -
export/import data pump mixed case username Jul 30th, 16 Never 85 None -
datapump undocumented command "desc" Jul 18th, 16 Never 103 None -
ambiguous data pump command "s". start/s... Jul 18th, 16 Never 112 None -
Change table and index ownership Jul 12th, 16 Never 97 None -
spool log off defeats rman command line log= Jul 5th, 16 Never 83 None -
can't create oracle user with name > 30 characters Jun 28th, 16 Never 73 None -
31 character osuser Jun 28th, 16 Never 32 None -
Rename LOB is an expensive operation Jun 26th, 16 Never 68 None -
Oracle database proxy login Jun 18th, 16 Never 84 None -
12c: 2+2=3 May 30th, 16 Never 94 None -
Incorrect results 12c global index May 30th, 16 Never 160 None -
index with 0 rows rendered unusable May 21st, 16 Never 31 None -
Friday the 13th generator May 12th, 16 Never 76 None -
Demonstrate Jonathan Lewis's RI deadlock. May 10th, 16 Never 79 None -
Demonstrate Jonathan Lewis's RI lock May 10th, 16 Never 26 None -
Incorrect v$parameter isdefault = true Apr 19th, 16 Never 80 None -
testAnyDbLink.sql Mar 23rd, 16 Never 57 None -
dropAnyDbLink.sql Mar 23rd, 16 Never 54 None -
createAnyDbLink.sql Mar 23rd, 16 Never 36 None -
seven ways to find sgabeg Nov 22nd, 15 Never 192 None -
database startup trigger branches depending on res... Nov 2nd, 15 Never 85 PL/SQL -
alertlog_pkg: printf to the alert log Nov 2nd, 15 Never 87 PL/SQL -
out_pkg: printf, die, assert for PL/SQL Nov 2nd, 15 Never 97 PL/SQL -
avoid divide by zero error with nullif Oct 23rd, 15 Never 135 SQL -
avoid log(0) error with nullif Oct 23rd, 15 Never 148 SQL -
last business day function Oct 23rd, 15 Never 131 None -
v$latch summarizes v$latch_children Oct 17th, 15 Never 92 Oracle 11 -
some cr v$bh rows are duplicates Oct 10th, 15 Never 133 Oracle 11 -
v$sgastat pools appear per con_id, but not the buf... Oct 4th, 15 Never 87 Oracle 11 -
Did I create 1 row or 4294967297? Aug 7th, 15 Never 196 Oracle 11 -
1700 was / was not a leap year Jul 26th, 15 Never 264 None -
Sep 2, 1752 Jul 26th, 15 Never 276 None -
Table segment exists after error. Index valid afte... Jun 8th, 15 Never 225 Oracle 11 -
Block dump of IOT secondary indexes May 17th, 15 Never 312 Oracle 11 -
IOT leaf and overflow block dump May 17th, 15 Never 259 Oracle 11 -
Number and Oracle float storage are similar May 15th, 15 Never 232 Oracle 11 -
copy good plan to another sql May 11th, 15 Never 312 Oracle 11 -
interval partitioned IOT not supported in 12.1.0.2 May 9th, 15 Never 273 Oracle 11 -
timestamp range partition boundary to max 6 decima... May 7th, 15 Never 286 Oracle 11 -
table access by index rowid batched, or not batched Apr 26th, 15 Never 260 Oracle 11 -
where clause vs extended part syntax same plan_has... Apr 26th, 15 Never 213 Oracle 11 -
Different Pstart/Pstop same plan_hash_value Apr 26th, 15 Never 221 Oracle 11 -
Different access / filter predicate, same plan_has... Apr 26th, 15 Never 224 Oracle 11 -
rename pdb and its service Apr 12th, 15 Never 217 None -
alter system pdb scope and persistent Apr 12th, 15 Never 228 None -
This is not a deadlock! Jan 29th, 15 Never 220 None -
Scala update scott.emp jdbc Nov 26th, 14 Never 215 Scala -
lvremove will not remove a disk from a mounted ASM... Oct 9th, 14 Never 248 Oracle 11 -
redacted 12c column exposed via tab statistics Jul 27th, 14 Never 200 Oracle 11 -
Self join elimination in 11.2, and a hint that doe... Jul 1st, 14 Never 240 Oracle 11 -
audit truncate table (unified) Jun 11th, 14 Never 316 Oracle 11 -
audit truncate table (classic) Jun 11th, 14 Never 196 Oracle 11 -
initwailua20.ora.20140611 Jun 10th, 14 Never 225 None -
crsctl stat res ora.wailuaq.db -p output Jun 10th, 14 Never 360 None -
wailua.log dbca output Jun 10th, 14 Never 295 None -
crdb.wailua.ksh dbca script Jun 10th, 14 Never 389 Bash -
wailua.dbt dbca template based on New_Database.dbt Jun 10th, 14 Never 329 XML -
Python quicksort Apr 28th, 14 Never 202 Python -
asmdu.sql Mar 1st, 14 Never 196 Oracle 11 -
insert and update WE8MSWIN1252 characters with sql... Feb 11th, 14 Never 107 Oracle 11 -
view any character set with only PuTTY and sqlplus Feb 11th, 14 Never 105 None -
load WE8MSWIN1252 chars into 12c ASCII database (c... Feb 1st, 14 Never 123 Oracle 11 -
add column to middle of 12c table Jan 13th, 14 Never 65 None -
12c: reorder the columns in a table! Wow! Jan 13th, 14 Never 106 None -
ORA-01450 while indexing 12c extended type Jan 12th, 14 Never 69 None -
Trace.java start and stop tracing Nov 7th, 13 Never 76 Java -
Ocmrf.java Oct 16th, 13 Never 62 Java -
12c non pdb to pdb, with errors Oct 3rd, 13 Never 4 None -
12c backup database cross platform, restore, recover Oct 2nd, 13 Never 143 Oracle 11 -
12c expdp character string buffer too small Sep 29th, 13 Never 440 None -
12c container dba does not see bind vars in other ... Sep 28th, 13 Never 197 Oracle 11 -
12c duplicate active using compressed backupset Sep 11th, 13 Never 77 None -
12c backup pdb to copy, "corrupt", switc... Sep 3rd, 13 Never 129 None -
12c pdb backup, "corrupt", restore, recover Sep 2nd, 13 Never 123 None -
alter session set container delays serveroutput Sep 2nd, 13 Never 120 None -
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!
 
Top