Monthly Archives: July 2014

A Round trip with Oracle Particioning


We are going to make a trip arround partiotioning in Oracle, why use partitioning?, types, despartitioning, how check some info about particioned tables…allways usefull tips for use day to day at work.

Continue reading

Advertisements

Oracle 10g Client on Windows 7

So we want use old sqlplusw, cause is light, fast than any sql developer for some admin duties, but wait! ORACLE baned this software since Oracle 11g, but no problem you can donwload from here 10.2.0.4 client. This client bring a compatibility problem with windows 7 for solve ….

Continue reading

Solution to: ORA-1691: unable to extend lobsegment

This ORA happens allways a lob segement cannot extended itself to fit the new data being inserted.
Tipical solution is extending the data file and adding a datafile, but sometimes, not often, error only apears in alert log (no client side) when space taken by the lob segment is allocated for reuse, before the undo retention period is expired.

Continue reading

Oracle Enterprise Manager Console

First ,easy, before EM we start with database and listener up, then start Enterprise Manager:

[oracle@isc ~]$ ORACLE_SID=TEST; export ORACLE_SID
[oracle@isc ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.

https://isc.localdomain:1158/em/console/aboutApplication

Starting Oracle Enterprise Manager 11g Database Control ………… started.

Continue reading