OraFAQ Forum: Server Administration » Oracle Reorganisation problem

Home » RDBMS Server » Server Administration » Oracle Reorganisation problem (Oracle 10g, Solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Reorganisation problem [message #539718]

Wed, 18 January 2012 04:41

aoikonom
Messages: 1
Registered: January 2012

Junior Member

I am trying to reoarganise a tablespace with Enterprise Manager from manual to automatic, but script generation gives the following warnng :

Quote:

Reorganization includes a table with a LONG column. To support reorganization of tables with LONG columns that are greater than 32Kbytes the external procedure MGMT$REORG_MOVELONGCOMMAND must be configured properly. It has been determined this external procedure is not currently configured as expected. Configure SQL*Net appropriately to allow it to call the external procedure service process.

I made changes suggested by //docs.oracle.com/cd/E11857_01/em.111/e11982/database_management.htm in the section Using Reorganize Objects with LONG Columns but the warning persists. I noticed however that $ORACLE_HOME/lib/libnmuc.so is an empty file (0 bytes).

Oracle Database 10g 10.1.0.2.0
Solaris (SunOS 5.9 Generic_117171-07 (64-bit))
Oracle home /data/lun1/oracle/product/10.1.0/db_1

{ORACLE_HOME}/network/admin/tnsnames.ora

# tnsnames.ora Network Configuration File: /usr/oracle/product/10.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

OASTHDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oasthdb)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = oast)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

{ORACLE_HOME}/network/admin/listener.ora

# listener.ora Network Configuration File: /usr/oracle/product/10.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/oracle/product/10.1.0/db_1)
      (PROGRAM = extproc)
      (ENVS=
            "EXTPROC_DLLS=ANY,
             LD_LIBRARY_PATH=/usr/lib:/usr/oracle/product/10.1.0/db_1/lib"
      )
    )
    (SID_DESC =
      (ORACLE_HOME = /usr/oracle/product/10.1.0/db_1)
      (SID_NAME = oast)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = oasthdb)(PORT = 1521))
      )
      (ADDRESS_LIST =
	(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

[Updated on: Wed, 18 January 2012 04:44] by Moderator

Report message to a moderator

Re: Oracle Reorganisation problem [message #539723 is a reply to message #539718]

Wed, 18 January 2012 04:46

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ Best way: convert LONG to CLOB, create a new correct tablespace and move the objects
2/ Next one: create a new correct tablespace and move the objects
3/ ...

Regards
Michel

Report message to a moderator

Previous Topic:	Index and Table rebuild method
Next Topic:	Un necessary tables present

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 04:46:23 CST 2024