pablosoracle.blogspot.com

Oracle database - tricks

Oracle database - tricks. Piątek, 7 sierpnia 2015. Script to shrink segments:. SELECT 'alter table '. Enable row movement;' sql1. WHERE TABLESPACE NAME IN ('USERS'). AND TABLE NAME NOT IN. FROM DBA TAB PARTITIONS. WHERE TABLESPACE NAME IN ('USERS'). FROM DBA TAB SUBPARTITIONS. WHERE TABLESPACE NAME IN ('USERS'). SELECT 'alter table '. Shrink space compact;' sql1. WHERE TABLESPACE NAME IN ('USERS'). AND TABLE NAME NOT IN. FROM DBA TAB PARTITIONS. WHERE TABLESPACE NAME IN ('USERS'). SELECT 'alter table '.

http://pablosoracle.blogspot.com/

OVERVIEW OF pablosoracle.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR PABLOSORACLE.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

November

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Friday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.8 out of 5 with 6 reviews

5 star

0

4 star

5

3 star

1

2 star

0

1 star

0

Hey there! Start your review of pablosoracle.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.7 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT PABLOSORACLE.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

19

SSL

EXTERNAL LINKS

3

SITE IP

216.58.216.193

LOAD TIME

0.734 sec

SCORE

6.2

PAGE TITLE

Oracle database - tricks | pablosoracle.blogspot.com Reviews

<META> DESCRIPTION

Oracle database - tricks. Piątek, 7 sierpnia 2015. Script to shrink segments:. SELECT 'alter table '. Enable row movement;' sql1. WHERE TABLESPACE NAME IN ('USERS'). AND TABLE NAME NOT IN. FROM DBA TAB PARTITIONS. WHERE TABLESPACE NAME IN ('USERS'). FROM DBA TAB SUBPARTITIONS. WHERE TABLESPACE NAME IN ('USERS'). SELECT 'alter table '. Shrink space compact;' sql1. WHERE TABLESPACE NAME IN ('USERS'). AND TABLE NAME NOT IN. FROM DBA TAB PARTITIONS. WHERE TABLESPACE NAME IN ('USERS'). SELECT 'alter table '.

<META> KEYWORDS

1 shrink segments

2 owner

3 table name

4 from dba tables

5 select table name

6 union all

7 union

8 table owner

9 modify partition

10 partition name

CONTENT

Page content here

KEYWORDS ON PAGE

shrink segments,owner,table name,from dba tables,select table name,union all,union,table owner,modify partition ,partition name,modify subpartition ,subpartition name,modify lob ,column name,from dba lobs,and partitioned ='no,move subpartition ,lob ,autor

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Oracle database - tricks | pablosoracle.blogspot.com Reviews

https://pablosoracle.blogspot.com

Oracle database - tricks. Piątek, 7 sierpnia 2015. Script to shrink segments:. SELECT 'alter table '. Enable row movement;' sql1. WHERE TABLESPACE NAME IN ('USERS'). AND TABLE NAME NOT IN. FROM DBA TAB PARTITIONS. WHERE TABLESPACE NAME IN ('USERS'). FROM DBA TAB SUBPARTITIONS. WHERE TABLESPACE NAME IN ('USERS'). SELECT 'alter table '. Shrink space compact;' sql1. WHERE TABLESPACE NAME IN ('USERS'). AND TABLE NAME NOT IN. FROM DBA TAB PARTITIONS. WHERE TABLESPACE NAME IN ('USERS'). SELECT 'alter table '.

INTERNAL PAGES

pablosoracle.blogspot.com

1

Oracle database - tricks: Changing database link definition in pl/sql

http://www.pablosoracle.blogspot.com/2015/02/changing-database-link-definition-in.html

Oracle database - tricks. Środa, 11 lutego 2015. Changing database link definition in pl/sql. To change database link definition in Oracle database we have to connect as a owner of this database link. In most cases it's possible by using output from dba db links and connect from sqlplus as a owner. But if we use undocumented function dbms sys sql.parse as user, then it's possible to change definition from pl/sql:. If we use specific password schema. Define pass prefix = 'pre'. Define pass postfix = 'post'.

2

Oracle database - tricks: lipca 2015

http://www.pablosoracle.blogspot.com/2015_07_01_archive.html

Oracle database - tricks. Środa, 15 lipca 2015. RMAN - unregister not existed database from catalog. Normally when I tried unregister non-existed database in RMAN catalog I received error:. Execute dbms rcvcat.unregisterdatabase(818673443,879389610);. BEGIN dbms rcvcat.unregisterdatabase(818673443,879389610); END;. ERROR at line 1:. ORA-02292: integrity constraint (RMAN.TSATT F2) violated - child record found. ORA-06512: at "RMAN.DBMS RCV. Select name,DB KEY,. Delete rman.tsatt where DBINC KEY=. Unfortun...

3

Oracle database - tricks: grudnia 2014

http://www.pablosoracle.blogspot.com/2014_12_01_archive.html

Oracle database - tricks. Wtorek, 30 grudnia 2014. ORA-01555: snapshot too old" after failover physical standby. Recently I received error on test database:. ORA-01555: snapshot too old: rollback segment number 53 with name " SYSSMU53 526582059$" too small. Simple problem with a simple solution :). This is a test database and almost nobody use this database. I checked a UNDO utilization and was on very low level. I changed undo guarantee, undo retention and I added additional datafiles to UNDO tablespace.

4

Oracle database - tricks: stycznia 2015

http://www.pablosoracle.blogspot.com/2015_01_01_archive.html

Oracle database - tricks. Piątek, 9 stycznia 2015. RMAN - restore process failed. On test server I had to restore database (3TB). Due to network issue RESTORE (not recovery) process failed. In normal situation I have to start restore process from beginning. Once again but I already have almost 2.5 TB restored. How to use this data? Database is in mount mode and in view V$DATAFILE COPY we have information about file id and datafile name (this information is needfull if OMF is used). SWITCH DATAFILE ALL;.

5

Oracle database - tricks: Oracle AQ - pl/sql notification does not work

http://www.pablosoracle.blogspot.com/2012/07/oracle-aq-plsql-notification-does-not.html

Oracle database - tricks. Poniedziałek, 2 lipca 2012. Oracle AQ - pl/sql notification does not work. A message to the. The status of ". And for mail notification. I noticed that the. SYSAQ$AQ SRVNTFN TABLE 1. Http:/ riyazmsm.blogspot.com. Appropriate queue name for pl/sql notification you can check using:. Select * from sys.AQ SRVNTFN TABLE 1. EXEC DBMS AQADM.START QUEUE('AQ$ AQ SRVNTFN TABLE 1 E',false, true);. Dequeue options DBMS AQ.dequeue options t;. Dq msgid RAW(16);. No messages EXCEPTION;. Dequeu...

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

OTHER SITES

pablosonfire.wordpress.com

PULL MY FINGER! | mianderings in the evolution of consciousness

Mianderings in the evolution of consciousness. It’s about…. To make a mocking bird. December 26, 2012. The first thing I heard this Christmas morning was an ornamental battery powered bird that chirped as I went passed it. It was like a booby trap for an already fragile state. I’m on the cusp of total depression and despair as it is what with the collective madness this season brings. It’s not entertaining or funny. Completely useless and totally destructive in the food chain. December 16, 2012. Accepted...

pablosong.com

THE SALT & THE SEA

THE SALT and THE SEA BIO. FOR BOOKING PLEASE EMAIL:. FOR LICENSING PLEASE EMAIL:. The Salt and The Sea.

pablosonpenn.com

Welcome pablosonpenn.com - BlueHost.com

Web Hosting - courtesy of www.bluehost.com.

pablosopactrip.blogspot.com

My South Pacific Adventures

My South Pacific Adventures. My name is Paul McCurdy. I am beginning a once in a lifetime journey to the South Pacific visiting Fiji, Vanuatu, and the Solomon Islands with the Plantary Coral Reef Foundation (www.pcrf.org). I will be surveying reefs throughout the region. Wednesday, June 21, 2006. Culture Shock - Back to Western Civilization. Day 342, May 1, 2006. Day 343, May 2, 2006. What would our first hot shower be like? Then, I talked to two other officers from the Torres Strait. They were islan...

pablosoraci.com

Pablo Soraci | Just another WordPress site

Just another WordPress site. September 20, 2013. Welcome to WordPress. This is your first post. Edit or delete it, then start blogging! One comment so far. Proudly powered by WordPress.

pablosoracle.blogspot.com

Oracle database - tricks

Oracle database - tricks. Piątek, 7 sierpnia 2015. Script to shrink segments:. SELECT 'alter table '. Enable row movement;' sql1. WHERE TABLESPACE NAME IN ('USERS'). AND TABLE NAME NOT IN. FROM DBA TAB PARTITIONS. WHERE TABLESPACE NAME IN ('USERS'). FROM DBA TAB SUBPARTITIONS. WHERE TABLESPACE NAME IN ('USERS'). SELECT 'alter table '. Shrink space compact;' sql1. WHERE TABLESPACE NAME IN ('USERS'). AND TABLE NAME NOT IN. FROM DBA TAB PARTITIONS. WHERE TABLESPACE NAME IN ('USERS'). SELECT 'alter table '.

pablosoria.com

Pablo Soria

12700 Biscayne Blvd Suite 205. Miami, FL 33181.

pablosoriadelachica.org

Pablo Soria de la Chica | Director of Business Development

Pablo Soria de la Chica Director of Business Development. Pablo Soria de la Chica Director of Business Development. As Director of Business Development for foreign exchange (forex) trading firm Bforex Ltd., Pablo Soria. Pablo Soria de la Chica has been with Bforex since 2008, and is a graduate of the Business Administration program at the Universidad Tecnológica de México. One of Mr. de la Chica. Pablo Soria de la Chica - CVShare. Pablo Soria de la Chica Twitter. 2015, pablosoriadelachica.org.

pablosorianocuesta.blogspot.com

Portfolio de Pablo Soriano -

Martes, 26 de abril de 2011. Asociación de SUP Tarifa. En el centro: Kai Lenny Campeón del mundo de SUP vistiendo la camiseta de la Asociación de SUP Tarifa. ALOHA. Publicado por P.Soriano. Enviar por correo electrónico. Miércoles, 2 de marzo de 2011. Promoción - Asociación de SUP en Tarifa. En este videos se puede ver una de las imagenes corporativas creadas por. Para la asociación de SUP en Tarifa. Tambien algunos enlaces donde podeis ver cartelería creada para distintos eventos:. Ya a la venta en una ...

pablosorianonavarro.blogspot.com

Pablo Soriano

Más vale pedir perdón que pedir permiso. Martes, 3 de mayo de 2011. Actividad plástica con ordenadores. Http:/ www.consumer.es/web/es/educacion/escolar/2011/03/27/199612.php. Publicado por pablo soriano. Clases para alumnos más desarrollados. Http:/ www.elpais.com/articulo/madrid/instituto/mejores/clase/elpepiespmad/20110406elpmad 6/Tes. Publicado por pablo soriano. Http:/ www.consumer.es/web/es/educacion/escolar/2011/04/22/200219.php. Publicado por pablo soriano. Consejos para el estudiante. Este artícu...

pablosorigins.blogspot.com

Pablo's Origins Blog

Talking about our origins (or the origin of anything) has been one of humanity's favorite pastimes since the human mind evolved. Here we can share, discuss and battle over the origins of our species and anything related, without fear of being burned alive, flaming is the only risk. The Origin of Life. Discovering the Genetic Code. We today know that chromosomes are made of DNA, but how that became a known fact? Proteins Vs. DNA. They thought it because pretty much everything that happens in the cell is d...