ORA-12014: table 'DBA' does not contain a primary key constraint

Advertisement
Hai
when implementing basic replication i got the below error.
ORA-12014: table 'DBA' does not contain a primary key constraint
I was wondering primary key is enable at remote table
Any idea about this
Regards
mohan
I am giving below example
AT master site
global_names=false in init.ora file
sql>create table dba(no number primary key);
table created
and create snapshot log
sql>create snapshot log on m1;
materilized view created
AT SNAPSHOT SITE
1.Create service using net8 stiring name like n1
2.create database link
sql>create public database link m3 connect to system identified by manager using 'n1';
Database link created.
3.when creating snapshot site i got below error
SQL> create snapshot snap1 refresh fast start with sysdate next sysdate+1/(24*60
*60) as select * from [email protected];
create snapshot snap1 refresh fast start with sysdate next sysdate+1/(24*60*60)
as select * from [email protected]
ERROR at line 1:
ORA-12014: table 'DBA' does not contain a primary key constraint
Advertisement

Replay

Hello,
Please repost this question in the appropriate section of the Discussion Forum.
This forum is for general suggestions and feedback about the OTN site.
You can also use our new offering called OTN Service Network:
For Oracle Advice/Minimal Support (fee based) on the Oracle Database Server, Oracle9i Application Server Containers for J2EE (OC4J), Oracle9i JDeveloper, Reports, Forums, SQL*Plus, and PL/SQL, please go to: http://www.oracle.com/go/?&Src=912386&Act=45
For customers with paid support (Metalink) please go to:
http://www.oracle.com/support/metalink
Regards,
OTN

SAP:E:000:Table 'T100 ' does not contain an entry for ' 000'?

Gurus, when user is updating size grid in matl master, the third party legacy system is reciving the bwlow error: SAP:E:000:Table 'T100 ' does not contain an entry for ' 000' could u all pls advise as why this error occured? Thanks in advance..t100 i

Getting ADFv: Rowkey does not have any primary key attributes

Hi I am using 11.1.1.5.0 version of JDeveloper. The ViewObject has DistaccountId,OperatingUnit,PricingCategoryId,PartyId as Primary Key and the EntityObject also has DistaccountId,OperatingUnit,PricingCategoryId,PartyId as Primary Key and my Table al

Can EJB 3.0 beans be used with tables that do not have a primary key?

Can a EJB 3.0 persistence bean be used with tables that do not have a primary key defined? I am building a test application based on the HowTo - Building EJB 3.0 Faces App paper posted after Openworld (schalk). The issue I am running into when trying

ADFS - The metadata does not contain the signing key needed for the entity to be configured as a claims provider trust

Our customer has provided us with federated metadata.xml file. When we go to import and create the claims provider trust we receive this error message: I have performed considerable Google search to be able to tell the customer what is missing. Can y

Incorrectly defined logical table source (for fact table Facts) does not

Hi, I have two Dimensions A and B. A is joined to B by a foreign Key. The report works if I pull B. Column1, A.Column2. The report is throwing an error if i try to change the order of the columns like this. A.Column2, B. Column1. error : Error Codes:

How can I replicate a source table that doesn't have any primary keys?

We have transactional replication setup in our workplace. In the source database, there are some tables that do not have any primary key. 1) How can I get these tables to replicate in the current scenario? 2) Is it possible to introduce foreign eleme

Managed System Configuration ! The table does not contain any data !

Hi, In Sol Man Setup , Managed System Configuration, in phase 6 - Create Logical Componets - There is no Product Version and Product Instance Available. The message is :  " The table does not contain any data " How can correct this problem ? Tha

Dump showing that table does not contain any elements.

Hi All, I have a table, with lead select.Based on the row selected, corresponding values of the row are filled in the input fields.        I filter the table and only those rows are displayed which has status "waiting". Now the problem is when t

Error:   Table TEMPLATE_HEADER does not fit into window.

Hello Experts , I met a very strange problem. I am printing a process order using smartform. for other process nrs , print perfect. But only for a certain precess nr, I got a popup error 'Table TEMPLATE_HEADER does not fit into window.' At beginning

Standard Data Collection Failing with Error ORA-04054: database link  does not exist.

Hi Gurus, When I am running Standard Data Collection in ASCP(APS) instance R12.1.3, its failing with error : ORA-04054: database link  does not exist. There is no such Database link exits which is showing in above error. Also the database link name i

Trying to access row values in a table which does not have any rows yet

try{                          MappedRecord importParams = recordFactory.createMappedRecord("CONTAINER_OF_IMPORT_PARAMS");                          IFunction function1 = client.getFunctionsMetaData().getFunction(funModGetDet);                    

ORA-02149: Specified partition does not exist

ORA-31693: Table data object "aaaa"."bbbbb":"P_2012112216" failed to load/unload and is being skipped due to error: ORA-02149: Specified partition does not exist SQL> select partition_name from dba_tab_partitions where tab

LOG BZA= table PATCHHIST  does not exist on database

Dear Friends, I am installing SAP R/3 4.7 using import method and in the last step of the installation RFC logon module (post procesing) getting the error FRF-00063 RFC logon failed with invalid interface. below is the R3trans log 4 ETW000 Connected

Dowload problem - This software does not contain support for the system lan

when i try to downoad a new version of itunes a message appears "This software does not contain support for the system language". I have checked the language and it is english and i don't know what is wrong. Anothe thing is that when i want itun

Error msg, "Maximum selection does not contain value 9999999999.

Hi, I am getting this error wile doing Reclassification of HFM Movement. Error msg, "Maximum selection does not contain value 9999999999 of subassignment HFM CD2 & Asset Type "                                          in the Data Monitor, (

Cannot connect: ORA-12505 error (listener does not know SID..)

I have an Oracle 10g installation insde a VM with private IP (192.168.109.128) and I'm trying to access it from the host operating system with aqua data studio, but get ORA-12505 error (listener does not currently know of SID...). The identical error

Context node does not contain any elements

Hi Masters,                  I create a node dynamically from structure using CL_WD_DEMO_DYN_MODEL->create_nodeinfo_from_struct method. my code as nd_field_info = nd_field->get_node_info( ). wd_this->zwd_assist->create_nodeinfo_from_struct( EX

InfoObject FORWAGENT does not contain alpa-conforming value 100.........

HI ALL, Can someone through some light on resolving the issue "InfoObject FORWAGENT does not contain alpa-conforming value 100............" In "Details Tab" of the monitor screen Requests (messages): Everything OK Extraction (messages)

ORA-20211: Active job does not exist, cannot link to job record.

Getting the above error while executing OWB mapping in production environment. Details of the error : ORA-20211: Active job does not exist, cannot link to job record. ORA-06512: at "RADRUN.WB_RT_MAPAUDIT", line 1278 ORA-06512: at "RADRUN.WB