There is actually no easy way to reorganize the data in a tablespace in Oracle11g.
You can't just use a command like ALTER TABLESPACE REORGANIZE or REORGANIZE TABLESPACE because there is no.
oracle howto avoid query oracle9i database solution 11 rdbms sql 92 tutorial statement 11g ddl search Oracle12c hints ask learn how sqlplus hint tuning dml slow query job max min decode outer join in explained how to example test production examples oracle11g oracle10g instruction command select update insert delete 12c merge pl/sql pl sql 2008 parse tsql convert migrate ora create tips table view tutorial speed find jobs flashback cluster find 12
Tuesday, February 2, 2010
Monday, February 1, 2010
TNS-12508: TNS:listener could not resolve the COMMAND given
TNS-12508: TNS:listener could not resolve the COMMAND given
this error could indicate that you have typed the wrong command in lsnrctl or it could indicate that the parameter:
ADMIN_RESTRICTIONS_YOURLISTENERNAME = ON
is set in listener.ora (located in $ORACLE_HOME/network/admin) and you don't have permission to adminster the listener. With this parameter set it is only the user oracle that is allowed to run commands against the listener.
Subscribe to:
Posts (Atom)