Search results for query: *

I am new to associative arrays. Here I am trying to do the equivalent of the folowing: create table mytable as select n1,padding from T1 where rownum <=5; Table created. And join this table with T1 and the get the first 10 matching records 1 SELECT * FROM 2 ( 3 SELECT 4...

I have a table t that I created as follows: CREATE TABLE T AS ( SELECT a.* ,RPAD('*',4000,'*') AS PADDING1 ,RPAD('*',4000,'*') AS PADDING2 FROM ALL_OBJECTS a ) ORDER BY dbms_random.random; ALTER TABLE T ADD CONSTRAINT T_PK PRIMARY KEY (object_id); this table has...

Oracle does not seem to like: CREATE TABLE T AS (SELECT *,RPAD('*',4000,'*) FROM ALL_OBJECTS) ORDR BY dbms_raddom.random * ERROR at line 1: ORA-00923: FROM keyword not found where expected However I think the only way is to do: CREATE TABLE T AS (SELECT * FROM...

Hi, I created a table T1 with index as follows: CREATE TABLE T1 ( n1 NUMBER(5) NOT NULL, ind_pad VARCHAR2(40) NOT NULL, n2 NUMBER(5) NOT NULL, small_vc VARCHAR2(10) NOT NULL...

I have been given a sample code to test. The code is as follows: create table t as select * from (select * from all_objects order by dbms_random.random); alter table t add constraint t_pk primary key (object_id; 1 declare 2 type array is table of t%rowtype index by binary_integer; 3...

I have Oracle 11.2.0.1.0 - 64bit I created a table called T1 as follows: select DBMS_METADATA.GET_DDL('TABLE','T1') from DUAL; CREATE TABLE "MICH"."T1" ( "N1" NUMBER(5,0) NOT NULL ENABLE, "IND_PAD" VARCHAR2(40) NOT NULL ENABLE, "N2" NUMBER(5,0) NOT NULL ENABLE...

Guys, I am getting this message in my alert file Errors in file /u01/app/oracle/diag/rdbms/mydb/mydb/trace/mydb_smon_7194.trc (incident=220642): ORA-00600: internal error code, arguments: [13013], [5001], [267], [8459028], [2], [8459028], [17], [], [], [], [], [] Incident details in...

Is there any dictionary table or view in Oracle that will provde the description of all data types that is available Oracle? Thanks, Learner

This is a simple SQL that tries to replace 1024*1024 with a bind variable. Finding out table and index size for a table in MB The easy one 1 select substr(segment_name,1,30) AS "Object", 2 sum(bytes)/1024/1024 AS "Size/MB" 3 from user_extents where segment_name in...

Can you please tell me what integer base Oracle operates. For example is this unsigned integer? With UNSIGNED INTEGER you have a max value of 4294967295. However, if I perform the following maths, Oracle does not seem to mind! select 4294967295 * 4294967295 from dual; 4294967295*4294967295...

I thought to open this as a question but by the time I had installed Oracle Grid on a standalone server and tried to create an ASM instance on Linux red hat ES 5.2, I had somehow resolved the problem. The problem was that I could install the ASM drivers, create ASMlib and assign volumes. I...

Hi, I am trying to create a database in 11g. I have already installed the software on red hat ES 5.2. Software installs fine. When I try to create the database I get the following: ORA-12705: Cannot access NLS data files or invalid environment specified Now I have unset NLS_LANG parameter and...

We are considering using Oracle partitioning option. This is an optional feature of Oracle Enterprise Edition. I believe it is priced per CPU. Any ideas what the ballpark figure per CPU is and how much it will cost us? Thanks

A developer has requested us to drop and recreated a DEV database using character set AL32UTF8 as o[pposed to UTF8. What are the pros and crons of using AL32UTF8 character set? I have heard some compatibiliyy issues with the client character set. For example connectivity with OLTP, JDBC, OLETP...

Hi, Anyone has any ideas how much Oracle RAC cost per CPU? We are interested in it but currently looking at the budgeting etc before going to Oracle sales

Hi, Because of DTS, I have just uninstalled and reinstalled the Oracle client from v9 to v9.2. However, I am getting the below error The description for Event ID ( 5376 ) in Source ( PMT_DataServiceLib ) cannot be found. The local computer may not have the necessary registry information or...

Hi, Has anyone used Oracle's Automatic Storage Management (ASM) with Veritas Cluster Server (VCS) or any other Veritas product? Veritas/Symantec are telling us that Oracle's ASM is not supported by Veritas and we cannot use it. I need to know if there are sites that have used Veritas products...

Hi, Has anyone had experience of creating Oracle RAC on IBM's dedicated LPARs. Oracle RAC will require a dedicated network adapter for interconnect. Thanks

As you are aware a part of Oracle installtion on UNIX hosts requires that the DBA has root access. This is not necessarily a technical problem but a procedure matter. I have a view that DBAs should not have root access and UNIX guys should not put DBA hat on, otherwise you will end up in all...

I got this error on my Oracle 10g running on Red Hat ES3 with disk groups using ASM raw partitions. The alert log of the instance shows Sun Oct 22 11:53:00 2006 Errors in file /u01/app/oracle/admin/mydb/bdump/mydb_asmb_3005.trc: ORA-15064: communication failure with ASM instance ORA-03113...