Skip to content

Instantly share code, notes, and snippets.

View JohnZavyn's full-sized avatar

John A. Marsh JohnZavyn

View GitHub Profile
@JohnZavyn
JohnZavyn / pom.xml
Created August 5, 2016 16:54
Renaming a dependency JAR before buiding a WAR in Maven
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-dependency-plugin</artifactId>
<executions>
<execution>
<phase>prepare-package</phase>
<goals>
<goal>copy</goal>
</goals>
@JohnZavyn
JohnZavyn / Oracle-replace-temporary-tablespace.sql
Created December 11, 2014 13:48
Oracle: Replace/reset Temporary TABLESPACE
/**
* I found after running a particular performance test that Oracle started hanging,
* and I noticed that the drive space was full. I eventually noticed that the TEMP
* tablespace had expanded to fill all the avlailable drive space. I found the following
* set of commands online that allowed me to drop the bloated tablespace and recreate
* a new one.
* @author John A. Marsh (with lots of help from the Internet)
* @since 2014-08-01
*/
@JohnZavyn
JohnZavyn / reset-oracle-sequence.sql
Last active August 29, 2015 14:09
Reset An Oracle SEQUENCE
SET DEFINE OFF;
SET SERVEROUTPUT ON;
SET FEEDBACK OFF;
--/
DECLARE
newStartNumber INTEGER;
oldStartNumber INTEGER;
difference INTEGER;
BEGIN
@JohnZavyn
JohnZavyn / oracle-drop-all-tables.sql
Created September 10, 2014 14:55
Oracle Drop All Tables, Views, Sequences, etc.
/**
* USE WITH CAUTION!
* This script attempts to drop every object it can find in the current schema.
* - Tables (including constraints)
* - Views
* - Sequences
* - More...
*
* @author John A. Marsh - ThreeLeaf.com (c) 2014
*/