Oracle
in [SQL]
|
Cannot remote startup database if dynamically registered withthe listener? Woody Ling wrote: I get error message when I try to use sqlplus to startup my db remotely: sqlplus sys(a)xyzdb as sysdba ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I found that I cannot use sqlplus to remote startup my database without st... 18 Apr 2008 12:38
LOB Table space Hello, I made a table with 1 blob field, and a specific lob tablespace to store the lob column. If i insert a row with nothing in the blob field, 1 MB is reserved for it in the lob tablespace. The blob field is NULL. Do someone have any idea ? Olivier. ... 19 Apr 2008 06:34
Cannot remote startup database if dynamically registered with the listener? I get error message when I try to use sqlplus to startup my db remotely: sqlplus sys(a)xyzdb as sysdba ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I found that I cannot use sqlplus to remote startup my database without static entry "(SID_DESC=(GLOBAL_NAME...... 20 Apr 2008 21:58
calculate maximum size in bytes of a table row how can i calculate the maximum amount of bytes that can be occupied by a table row. The table might not have any data in it, i'm looking for a calculation based on the data types used for columns.All i found so far was algorithms to estimate the average size for existing rows. i'm trying to spool the contents of ... 18 Apr 2008 13:26
APPEND hint and index maintenance Sorry for asking what seems to be an obvious question: Records are inserted into a table A using INSERT /*+ APPEND */ into A SELECT * FROM B; There are indexes on table A, and these indexes are in VALID state (DBA_INDEXES.STATUS = 'VALID') before the insert. Questions: 1. Would these indexes be marked UNUSAB... 18 Apr 2008 18:14
query using index get no row? I had this two queries: select * from table where id = number; select /*+ NO_INDEX (table PK_IDX)*/ * from table where id = number; When query used index no row was returned. Index is on primary key column and status in user_indexes was 'VALID'. I rebuild index but problem is not fixed. I fixed problem w... 18 Apr 2008 15:50
help: agent install, wrong crs home typed Dear group, I installed GRID control 10203 successfully. On the client machine, i did ../agentDownload -b /url/local/oracle -c crs -n node1,node2 but our crs name is crs_home1, not crs, so the grid control does not show my cluster home. What should I do to fix this mistake? Thanks for your help ... 17 Apr 2008 23:40
RHEL4 Linux/MF CObol precompiler question- Hi- We're migating our OS from AIX (Oracle 9.2.0.6 & MF Cobol) to RHEL 4 (Oracle 10.2.0.1, also MF Cobol). Every program that compiles and runs on AIX seems to do the same on RHEL4. Every program except one, where the precompiler seems to be having a problem rejecting some (but not all!) sql exec directive... 22 Apr 2008 13:12
is isqlplus completely gone in 11g or what exactly? In the 11g New Features for Admin class I attended 2 weeks ago, the instructor specifically noted that isqlplus is still available in 11g. He explained that it is no longer installed by default but that you can do a custom install and get it operating in 11g. He rambled on about some of the security exposures th... 17 Apr 2008 23:40
OracleXE 10g listener service can't start after server joined domain and changed computer name. Amber wrote: Copy and paste the output you get here. SQL*PLUS: Release 10.2.0.1.0 - Production on........... Copyright........ Connected to an idel process. SQL> that is not copy/paste... Anyway, copy and paste this: startup ... 18 Apr 2008 13:26 |