Snipplr

(SQL) Oracle Schema DB Stats - geekzspot

Wed, 15 May 2013 05:34:45 GMT

Run DB Stats for your Schema

(SQL) Oracle DB Stats - geekzspot

Wed, 15 May 2013 03:53:11 GMT

Run Oracle Database Statistics for the whole database

(SQL) Oracle Show my GRANTs and Privileges for an Object - geekzspot

Wed, 15 May 2013 02:33:14 GMT

-- See what GRANTs and Privileges I have on an object, such as a Table, View, Sequence, Stored Procedure

(SQL) Oracle Database Parameters - geekzspot

Sat, 11 May 2013 05:08:56 GMT

See database settings. Client will override Database.

(SQL) Show Oracle Parameter value - geekzspot

Wed, 08 May 2013 02:59:55 GMT

Here for example we show the default NLS_LENGTH_SEMNATICS Parameter

(SQL) Oracle Change Data Type for all Columns - geekzspot

Wed, 08 May 2013 02:42:05 GMT

You might want to change all VARCHARs from BYTE to CHAR?

(SQL) Oracle change Column Datatype - geekzspot

Tue, 07 May 2013 13:06:15 GMT

Maybe you want to change BYTE to CHAR? Maybe you want to go BIGGER?

(SQL) Oracle Truncate All User Tables - geekzspot

Sat, 04 May 2013 06:34:31 GMT

Warning! This is dangerous! There may be no Flashback to recover data! Also, if this thing crashes, you must rerun it successfully or data integrity will be a mess!

(SQL) Oracle Move a Table to another Tablespace - geekzspot

Sat, 04 May 2013 03:32:19 GMT

To move a Table to another Tablespace, its Index must be rebuilt!

(SQL) Oracle default Tablespace Name - geekzspot

Tue, 29 Jan 2013 05:02:39 GMT

Well what do ya know?

(SQL) Rename Oracle Column - geekzspot

Fri, 25 Jan 2013 08:37:56 GMT

Renaming columns is easy

(SQL) Bounce Oracle - geekzspot

Thu, 24 Jan 2013 05:04:00 GMT

How to "bounce" an Oracle database

(SQL) Oracle Database Free Space - geekzspot

Thu, 24 Jan 2013 04:48:40 GMT

This SQL will quickly show you approximately how much free space is in your database, expressed in various units of measurements.

(SQL) Oracle Table Sizes - geekzspot

Thu, 24 Jan 2013 02:55:39 GMT

Get the size of all Tables in your Database Schema Run DB Stats for more accuracy!

(SQL) Ver tablas asignadas a un usuario por privilegios - thescorpion

Wed, 14 Nov 2012 04:10:35 GMT

ver tablas que tiene un usario asiganadas por privilegio

(SQL) Grant y Revoke sobre objetos - dinamico - thescorpion

Wed, 14 Nov 2012 03:55:28 GMT

Uso de Grant y Revoke de objetos masivos de distintos user

(SQL) Creacion de DBLINK con Full name service - thescorpion

Sat, 20 Oct 2012 04:18:47 GMT

Cuando se da el caso que tienes 2 servidores diferentes y el ServiceName de oracle es el mismo...En el momento de crear un dblink hay que especificar bien la cadena de coneccion para que se direccione al otro servidor y no escoja el serviceName del el mismo servidor en el cual estamos

(SQL) Mostrar JOB - thescorpion

Sat, 20 Oct 2012 01:29:31 GMT

mostar los job registrados en oracle

(SQL) Mostrar Objetos que hacen Referencia a un Objeto Especifico - thescorpion

Fri, 12 Oct 2012 02:59:07 GMT

Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle

(SQL) Aumentar tamaño al Tablespace en oracle - thescorpion

Fri, 05 Oct 2012 05:38:37 GMT

incremento del table space en oracle