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.
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 ….
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.
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 184.108.40.206.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Starting Oracle Enterprise Manager 11g Database Control ………… started.