Maximum Tables Supported

Jan 3, 2013

We are having a production database configured in oracle 10.2.0.4 ( standard edition) and its contains near to 50000 tables . The database is accumulated by more than 100 tables everyday, and my question is is there is any table limits in oracle database ? especially in standard edition ??

View 8 Replies


ADVERTISEMENT

SQL & PL/SQL :: FORALL INSERT Not Supported On Remote Tables?

Nov 4, 2012

how to transfer a large amount of data from remote table by db link into the local table.

I try to do that by plsq below but I got error:

PLS-00739: FORALL INSERT/UPDATE/DELETE not supported on remote tables

DECLARE
type t_varchar is table of varchar2(100);
l_data t_varchar ;
CURSOR r IS
SELECT id
FROM TMP_MAPE_WEB_ID;
BEGIN

[code]....

View 6 Replies View Related

Semantic Technologies :: Maximum Node ID Larger Than Java Maximum Integer Value

Mar 7, 2013

I'm currently doing migration from Oracle 10gR2 RDF to Oracle 11gR2 Semantic Technology.I followed the steps on the documentation and successfully created the network using the following:

-----
EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tblspace');
CREATE TABLE rdf_network_trace (id NUMBER, triple SDO_RDF_TRIPLE_S);
--Created SEQUENCE andTRIGGER FOR rdf_network_trace id
[code]....

when I looked at my Node Ids, they were like +635762253807433724+, +6118969225776891730+. The problem is, I am not the one who is assigning Node Ids, They were automatically generated when inserting TRIPLE data to the rdf table.

Did I miss something when I created my network?

View 11 Replies View Related

Distributed Operation Not Supported

Jun 12, 2013

I am using the dblink to merge the data. I am using the following merge statement.

merge into APP_USER.USR_NEW_RIGHTS@NEW_RIGHTS t
Using (select 'test' GRANTEE,'TESTxxx'ROLE from dual ) s
on (t.GRANTEE = s.GRANTEE and t.ROLE = s.ROLE)
when not matched then
insert (ID,GRANTEE,ROLE,XRIGHT,COMPANY,OWNER,TABLENAME)
values ('','test','TESTxxx',null, null, null, null);

I know that I have to set a commit and it's working when I insert information's with a normal insert statement via database link, but it seems that merging doesn't work.

View 1 Replies View Related

What Type Of Storage Is Supported By ASM

May 25, 2012

what type of storage is supported by ASM? I know of RAW storage but does it run on something else?

We are running on Power7, AIX 6.1.

View 1 Replies View Related

How To Determine Number Of TPS Supported On Solaris

Mar 24, 2013

How to calculate the number of TPS supported by any solaris server for example one server with below configuration .

Sun Blade X6270 with two 4-core processors
2 x 300 GB internal disk drives

View 1 Replies View Related

Forms :: Reports 4.5 Supported On Database 9i

Feb 29, 2008

IS Oracle Forms/Reports 4.5 supported on database 9i?

My application is running on Form/Reprots 4.5 and 7.3.4 database in WIN2003 server. we have upgraded the database to 9i Release 2. After the upgrade terminate, i become unable to connect to my database from my application forms 4.5.

TNSNAME is OK.
Listener is OK.

Can i connect from Forms/Reports 4.5 to 9i Release 2 Oracle database?

View 28 Replies View Related

Forms :: Plugin Is Not Supported Error

Jul 14, 2013

I am having a problem in the process of run the Form on web browser.We learned builder Use the Oracle 10g and Oracle Developer Suite 10g

View 6 Replies View Related

SQL & PL/SQL :: ORA-02064 - Distributed Operation Not Supported?

Apr 20, 2011

When I try to call a database procedure written in Oracle 8.1.7.4.0 with OUT parameter and COMMIT statement from my Oracle 10g environment, I am getting error like "ORA-02064: distributed operation not supported".

I cannot omit OUT/COMMIT statement from the procedure because it is also updating another table from called procedure. I have tried some solutions from my end, but it is not working and same error generating. Like:

1) Moved the update statement with COMMIT statement to another procedure and calling that procedure from main called procedure
2) Creating a job to run the newly created procedure and submit the job from called procedureetc.

View -1 Replies View Related

Forms :: Supported IE Browser Version For 10g

Oct 9, 2013

Currently i am using IE 6 for running my forms 10g, I like to know upto which IE Versions i can update so it must not affect my Oracle forms 10g running.

i like to update to IE 8, but it must not affect my forms runtime functionality!

View 3 Replies View Related

RAC & Failsafe :: Is Oracle 11G Supported On VMWARE

Jan 17, 2012

Is Oracle Failsafe 11G supported on VMWARE, we plan to create a cluster of two vm servers, is it a supported configuration?

View 4 Replies View Related

Forms :: Reports 4.5 Supported On Database 10g

Mar 11, 2010

Does Oracle Forms/Reports 4.5 supported on database 10g? We have legacy application in Forms4.5 we are planning to migrate backend from 9i to 10g.

View 7 Replies View Related

ODP.NET :: Is Failover Supported In Managed Driver

Nov 7, 2013

I can see that some failover events etc aren't supported (Differences between the ODP.NET Managed Driver and Unmanaged Driver), but is failover supported at all? I don't need to get notified, just to get the failover (clustered node switching) working. Is it supported in the managed driver?

View 1 Replies View Related

Networking And Gateways :: How Many Listener Supported In One Database

May 30, 2010

How many listener we can have in one database? How many users can be support by one listener?

View 3 Replies View Related

Performance Tuning :: AWR Report In 11g Standard Not Supported?

Jan 15, 2011

I was trying to generate AWR report, but the report which got generated consist most of the sections without data. Later i came to know that AWR report is not fully supported in 11g? Is that true?

View 6 Replies View Related

Forms :: ORA-12703 Character Set Conversion Is Not Supported

Jan 29, 2013

There are two application servers we have, one is windows based with 10g and linux based 11gr2. Our main login form throwing error message in linux server 'ora-12703 this character set conversion is not supported'. The same coding form in 10g running without any problem. Both application servers accessing the same oracle db server 11gr2.

View 3 Replies View Related

SQL & PL/SQL :: Version Of Java Supported By Oracle Database 11g And 10g

Feb 22, 2011

what version of java is supported by Oracle Database 10g and 11g. Actually i am writing a User Defined Function in Java and was asking this question to know which version of java i need to compile the source file before uploading the jar.

View 2 Replies View Related

What Object Oriented Extensions Are Supported By Oracle

Jan 13, 2007

"What object oriented extensions are supported by oracle?"

View 1 Replies View Related

SQL & PL/SQL :: Expression Not Supported Error For Query Rewrite

Aug 13, 2013

I am trying to create a materialized view with the following script :

CREATE MATERIALIZED VIEW "MRT"."MV_RV_SMALL_BUSINESS"
(
"batch_id"
,"small_business_flag"
,"account_count"
,"naics_count"
,"mra_count"
[code].......

IT GIVES ME THE FOLLOWING ERROR:

SQL Error: ORA-30353: expression not supported for query rewrite
30353. 00000 - "expression not supported for query rewrite"
*Cause: The select clause referenced UID, USER, ROWNUM, SYSDATE,
CURRENT_TIMESTAMP, MAXVALUE, a sequence number, a bind variable,
correlation variable, a set result,a trigger return variable, a
parallel table queue column, collection iterator, etc.

View 2 Replies View Related

SQL & PL/SQL :: ORA-14652 / Reference Partitioning FOREIGN KEY Not Supported

Mar 30, 2011

I am trying to use reference partitioning the parent table records moved using the row movement . but the child table records are not moving below is my sample .

CREATE TABLE ref_parent1 (
table_name VARCHAR2(30),
order_date DATE,
num_rows NUMBER);
INSERT INTO ref_parent1 VALUES ('TEST',SYSDATE,100);
INSERT INTO ref_parent1 VALUES ('TEST1',SYSDATE,1000);
INSERT INTO ref_parent1 VALUES ('TEST2',SYSDATE,1000);
COMMIT;

[code]....

ORA-14652: reference partitioning FOREIGN KEY IS NOT supported

View 4 Replies View Related

Installation :: Database 10.2.0.3.0 Supported Redhat Linux 64 Bit OS?

Oct 2, 2012

We have 3 databases with version 10.2.0.3.0 running on RHEL AS 4.5 32 bit operating system. We are planning to move these databases to RHEL 64 bit Operating system.

let me know the highest 64 bit RHEL version supported by these databases(10.2.0.3). Will it support with RHEL 5.5 64 bit version?

View 7 Replies View Related

Server Administration :: Are Parallel Queries Supported In Oracle XE

Nov 18, 2010

I'm not sure is parallel query supported in xe ?

View 2 Replies View Related

Exadata :: Find ACFS Supported But Is Not Mentioned For DBFS

Apr 23, 2013

Does RMAN backupset (backup to ) on DBFS is supported. I can find ACFS supported but is not mentioned for DBFS. My current customer is thinking backup to DBFS then copy to tape as the interim solution before getting ZFS next year.

View 5 Replies View Related

Automatic Storage Management :: Is ASMLIB Supported By RHEL6

Jan 29, 2013

SO: RHEL6
RDBMS: 11.2.0.3
Standalone Server

I'll install a Oracle Database 11gR2 with ASM on RHEL6 (standalone, not RAC).

Is ASMLIB supported by RHEL6?

View 20 Replies View Related

Is Oracle Client Install On Network Location Supported

Nov 29, 2010

I've looked in several places, OTN, Google, various DBA forums to figure out if the way we have a client installed on a network drive is supported by Oracle - short of asking them if it's supported.

The configuration we have is a full 10g R2 client installed on a network drive, and the various environment variables (Oracle_Home, TNS_ADMIN, etc.) point to that network location for use by client machines (I'm also trying to see if the Instant client is supported on a network location as well.) We've had this set up for years which has served us well.

A co-worker remembers years ago that this set up wasn't supported, Oracle 8 or so was his thought as to what version was used then. Another coworker at an Oracle conference asked this same question and was told that it was supported, however we can't find any documentation to that effect.

Now the question arises as to whether or not using a client installed on a networked drive is a supported configuration for 10g R2 or higher, and if so, where it would be documented.

We are in the process of changing network topology and are reviewing whether this configuration is still the right thing for us or if clients should be installed locally to where they are used.

View 2 Replies View Related

RAC/ASM Clusterware Installation :: Running 64bit JVM Not Supported On Platform?

Apr 24, 2013

I am trying to install grid infrastructure on oracle linux 6.3 at Virtual box.I am getting error Running a 64-bit JVM is not supported on this platform while verifying cluster trough cluvfy

runcluvfy.sh stage -pre crsinst -n host1 -verbose
Running a 64-bit JVM is not supported on this platform.

I have checked java version is 64 bit installed on machine

[root@rac1 grid]# java -version
java version "1.6.0_24"
OpenJDK Runtime Environment (IcedTea6 1.11.1) (rhel-1.45.1.11.1.el6-x86_64)
OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode)

View 2 Replies View Related

Real Application Clusters :: 2 Node - Multiple Databases Supported

May 15, 2013

if multiple databases on one 2 nodes RAC is supported ? Explain me the inconvenient to have multiple databases on RAC ?

View 14 Replies View Related

Enterprise Search :: Supported SES11g security Module With WCC11g

May 24, 2013

My customer is using latest SES11g with WCC11g, the WCC11g has ACL security module, in SES document, it mentioned only security group and account module in WCC is supported when using SES, but somebody tested SES did work with WCC with ACL security module, is there any document in SES mentioned this is a supported feature?

View 0 Replies View Related

Express Edition (XE) :: Oracle 11g On Linux Mint - MEMORY_TARGET Not Supported On This System

Feb 5, 2013

I decided to use Oracle 11g XE on Linux Mint. I read this tutorial Oracle 11gR2 Express Edition on Linux Ubuntu 11.10 howto included the seventh part. However, I did a minor change in the script given. Indeed, since Ubuntu 12.04, a bug appeared. So I use the following script :

cat > /etc/init.d/oracle-shm <<-EOF
#! /bin/sh
# /etc/init.d/oracle-shm
#
#
case "$1" in
start)

[code]...

I already uninstalled and reinstalled Oracle 3-4 times, but nothing else happened. When I want to configure oracle-xe, I have a such message :

Starting Oracle Net Listener...Done
Configuring database...
Database Configuration failed.  Look into /u01/app/oracle/product/11.2.0/xe/config/log for detailsAnd this is the content of the file postDBCreation.log :
begin
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

[code]...

View 3 Replies View Related

SQL & PL/SQL :: Find Maximum Value In A Row?

Mar 28, 2012

I need to find the maxmimum value in a row, which consists 4 fields.

Columns: field_1, field_2, field_3, field_4

values : 2 , 4, 5, 1

the output should be field_3 =5

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved