Replication :: How To Remove Entry From Dba_repgroup

Mar 19, 2012

SELECT * FROM dba_repgroup;
returns a single row sname='VL_REPG', gname='VL_REPG', owner='PUBLIC'.

How do I get rid of it?

select * from dba_registered_mview_groups;
returns
no rows selected
select * from dba_objects where object_name = 'VL_REG';
returns
no rows selected

I triedSQL> l
1 BEGIN
2 dbms_repcat.comment_on_mview_repsites(gowner => 'PUBLIC', gname => 'VL_REPG', COMMENT => 'asdf');
3* END;
SQL> /
BEGIN
*
ERROR at line 1:
ORA-23314: database is not a materialized view site for "PUBLIC"."VL_REPG"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 7376
ORA-06512: at "SYS.DBMS_REPCAT", line 509
ORA-06512: at line 2

how I get rid of this dba_repgroup.

View 2 Replies


ADVERTISEMENT

Server Administration :: How To Remove Deleted Entry From Sys.ts$

Oct 15, 2011

### Changes made ###
1 week before we did a change on tablespace segment management - from MANUAL to AUTO by following method:
1. create INVD2 & INVX2 & LOBD tablespace.
2. Move TABLE from INVD to INVD2.
3. Rebuild INDEX from INVX to INVX2.
4. Move LOBSEGMENT from INVD to LOBD tablespace.
5. After confirm no segments exist in old tablespace, offline and drop INVD & INVX.
6. Change default tablespace for INV user to INVD2.
7. RENAME TABLESPACE INVD2 to INVD, INVX2 to INVX.
8. Change default tablespace for INV user to INVD back.
9. Run Gather Schema Stat for INV using UNIX scheduler which work usually. However, error ended with ORA-03113 & ORA-03114.
10. Manual execute with same statement the following day, procedure completed successfull.

After 1 week later, inventory forms detected error FRM-40735 in all forms. Checked the gather schema stat job was run in the morning before user feedback..

AFter refer notes from metalink, I understand this is a bug where RENAME of the tablespace could not rename as the previous one, as the deleted entry is still exist in sys.ts$?

There is no segments exist in the deleted tablespace, or any user default tablespace is assigned to the deleted tablespace.

My Question:How can we delete the deleted entry from sys.ts$?And should we rename the tablespace from INVD to INVD3 (or can we use back INVD2) to avoid any unforseen error again?

View 4 Replies View Related

SQL & PL/SQL :: Print NULL Entry Along With NOT NULL Entry

May 30, 2010

Suppose that, I have two tables: emp, dept
emp records the empid, emp_name, deptid
dept records the deptid, dept_name

Here is a record, it's a president or some special position in company, so it's deptid is set to NULL. Here comes the question, how can I print all the emp_name with their deptartment name?

I know how to print all the emp_name with their department name if they have dept_id, but is that possible that I merge the record with dept_id NULL?

View 9 Replies View Related

Replication :: Oracle Streams / Tried Schema Replication Through Enterprise Manager Grid Control

Feb 22, 2012

Actually am trying to replicate two db servers from one in hong kong and another in china. when am trying to establish the replication, am getting error 'ORA-04052: error occurred when looking up remote object' like this...

but the same way i have tried in my local network, it is working fine.i have tried schema replication through enterprise manager grid control..

View 6 Replies View Related

Replication :: Network Requirements For Oracle Multi Master Replication?

Apr 1, 2010

what are the recommended network requirements for implementing Oracle Multi Master replication.

View 1 Replies View Related

Replication :: Setup Database Replication With Updatable Materialized View?

Sep 4, 2009

i need to set up a central server with all the master tables and two other local database which will hold the updatable materialized view of the master table...the databases must be synchronized with central server..and user will work on the materialized view database...

View 10 Replies View Related

Replication :: Setting Replication Table Does Not Exist Or Is Invalid

Aug 21, 2008

I want to set up advance replication for 3 master site (multimaster) I created 3 master site named orc1,orc2,orc3 and followed up oracle replication management of API book instruction I created 2 tables(tes1,test2) in hr schema in all 3 master site with the same data. then I created the following steps

1-CONNECT repadmin/repadmin@orc1

2-Create the master group named hr_test_repg

BEGIN
DBMS_REPCAT.CREATE_MASTER_REPGROUP(
gname => 'hr_test_repg');
END;
/

4-add tables test1 and test2 to the group

BEGIN
DBMS_REPCAT.CREATE_MASTER_REPOBJECT(
gname => 'hr_test_repg',
type => 'TABLE',
oname => 'test1',

[code]....

I could create DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT for test2 but not for test1 and it produces error

RROR at line 1:
RA-23309: object hr.test1 of type TABLE exists
RA-06512: at "SYS.DBMS_SYS_ERROR", line 105
RA-06512: at "SYS.DBMS_REPCAT_MAS", line 2552
RA-06512: at "SYS.DBMS_REPCAT", line 562
RA-06512: at line 2

View 5 Replies View Related

Replication :: Selective Incremental Replication Between Two Instances?

Aug 4, 2009

I have one 10g database in other country. I want part of their db (selected tables or tablespaces) and import that data to my 10g DB and i want keep to date this data.

I know two ways

1. Data Pump Imp/Emp via FTP, but i can't send only data that have changed (incremental), i must pumping whole selected part of database (i want only new data from their DB, but consistanse with my DB)

2. RMAN etc. or other archivisation tool, i can do incremental achivisation, but can i send files to another instances (my db) and load only that data? Can i do that with SQL*Loader?

View 1 Replies View Related

Replication :: Bi-Directional Replication Through Golden Gate?

Aug 22, 2010

For using replication in our production, here i am testing golden gate as replication tool. I tested all scenario in Uni direction ( source to destination). Now have to test replication with DDL support in Bi-Direction. Not getting any Doc for doing replication in Bi-direction( Two Way). If any one has done the same, then please share limitation of replication in Bi-direction through Golden Gate.

View 7 Replies View Related

Replication :: Refreshing The Tables In Multimaster Replication?

Oct 14, 2008

I have 8 databases in a multi master replication. I want to refresh the tables in the replication.

View 3 Replies View Related

Replication :: Getting Error In Configuration Of Replication Between Two Databases

Jan 28, 2011

I Have configured the replication between two database's at table level. After few miniuts of successful configuration of replication between two db's at table level, I am getting the ORA-00001: unique constraint (%s_PK) violated error in dba_apply_error.

I checked constraint name,type and status on table replicated is same on both source and destination db.

View 4 Replies View Related

Replication :: Should Target DB In Replication Be In Archive-log Mode

Jul 26, 2008

I am implementing one-way replication between 2 databases.

Do people leave the target database in archive-log mode? Do they backup the target database?

View 4 Replies View Related

Check For Entry Before Submission

Mar 27, 2007

How do i check the oracle database for an entry of the same type before i submit an entry.

basically i am taking information from a form and passing it into php which in turn uses oracle to store it in a database, how can i check that there is no entry of the same type in the database?

View 1 Replies View Related

Loop Back Entry

Jun 1, 2013

How the loop back entry in /etc/hosts relates to listener?

View 1 Replies View Related

SQL & PL/SQL :: Distinct Timestamp - One Entry Per Day?

Apr 21, 2010

how can I distinct this query to get just one entry for one day.

this query:

select to_date(to_char(TIMESTAMP, 'YYYY-MON-DD HH24.MI.SS'), 'YYYY-MON-DD HH24.MI.SS') datum from event_table where id=15 ORDER by timestamp

returns:
Datum
01-MAY-09
01-MAY-09
01-MAY-09
..
..
..
02-MAY-09
02-MAY-09
.
.

but i want to have:

Datum
01-MAY-09
02-MAY-09
03-MAY-09
.
.

View 5 Replies View Related

Forms :: Restricting Entry From Keyboard?

Jan 28, 2010

i am working on attendance system using barcode scanner.

i want the user can only mark his/her attendance by scanning the attendance card.and cannot use keyboard.

View 9 Replies View Related

PL/SQL :: Obtains A List Of Paired Entry

Jun 4, 2013

Variation of a post I entered last week.I have 2 queries, 1 obtains a list of paired entries, and the other for a given pair of entries returns a list of common locations.Both these queries behave exactly as I expect (although trimmed significantly for this example)With C++ code, i can recursively work through the results from query 1, and plug them into query 2, but this has a large time overhead.Preference would be to nest the queries so result is extracted during 1 connection, and not constantly requerying the database for additional sequences.

SELECT     SWTT_HEADER.THR_ID AS S_HDR, DWTT_HEADER.THR_ID AS D_HDR
FROM         RTDEV.TRIP_HEADERS SWTT_HEADER INNER JOIN
                      RTDEV.TRIP_HEADERS DWTT_HEADER ON SWTT_HEADER.TRIP_NAME = DWTT_HEADER.TRIP_NAME
WHERE     (SWTT_HEADER.TME_ID IN (1)) AND (DWTT_HEADER.TME_ID IN

(2))Query 1 above gives me exactly the trip pairs I need, can range from 1 pair to a few thousand..Query 2 below gives me the common locations for a specific pair as extracted line by line from query 1.What I am looking for, is how to combine these 2 queries so that the values of THR_ID in query 2 are recursively pulled from query 1.

SELECT DISTINCT DWTT_BODIES.MASTER_NODE AS LOCN
   FROM RTDEV.TRIP_HEADERS SWTT_HEADER
        INNER JOIN RTDEV.TRIP_HEADERS DWTT_HEADER
           ON SWTT_HEADER.TRIP_NAME = DWTT_HEADER.TRIP_NAME
        [code]...

From the sample data, i expect query 1 to return pairs 1,9 2,10, 3,11 4,12 5,13 6,14 7,15 and 8,16
Entering 1 and 9 (first pair) as the THR_ID values in query 2 will yield B,C , as these 2 locations are common to both trips.
Entering 2 and 10 (2nd pair) as the THR_ID values in query 2 will yield G,H , as these 2 locations are common to both trips.

The aim is to achieve B,C,G,H from a single query.I figure if I can write C++ code for it, there has to be an SQL shorthand?

View 10 Replies View Related

Forms :: Oracle Form Entry?

Feb 25, 2010

i am new to oracle form , i am using orcale 10g forms, i have following requirements.

1-I have a Data Block names Hes_Modules which is connected to a table HES_MODULES having following fields (modid,moddescr).

i want when form open it should show all enteries in table, My form conatin 5 fields and scrollbar.After form open it should allow to update and insert the reords in form

View 3 Replies View Related

Forms :: Order Entry Application?

Mar 9, 2011

where i could get the order entry application wich is found in oracle 10g forms book ?

View 4 Replies View Related

Replication :: How To Make Replication For Destination Only

Apr 1, 2013

How can i make replication at one way For destination only. Not for destination and target.

View 5 Replies View Related

Replication :: Oracle Replication Between Different Versions?

Sep 17, 2008

I need to do a Oracle replication between databases. One resides on Oracle 8i which needs to be replicated to a database on Oracle 10G.

Is oracle replication supported between dissimilar versions of Oracle?

View 3 Replies View Related

Replication :: Impact Of Triggers On Replication

Oct 28, 2009

I am using prebuilt MV to perform replication of about 300-400 master tables from one database to another database. I am wondering about the impacts on triggers in general replication.

IS there a general rule to enable/disable a trigger before a refresh.

View 1 Replies View Related

Replication :: Oracle 8i Asynchronous Replication

Apr 9, 2012

I want to configured A Synchronous replication in oracle 8i. Noe using GUI i am bale to create replication but whatever i modify it remain in the transaction i have to manually run the job ,

I also tried to configured continuous asynchronous configuration by setting delay rate 500000. but it was also not working.

View 2 Replies View Related

Replication :: One Way Replication From MS Sql Server To Oracle 10g

Feb 11, 2010

Is it possible to replicate table data on real time from sql server (2005 32 bit or sql server 2000 32 bit)to oracle 10g running on linux 64 bit? If yes then what are the steps.

It will be one way replication from sql server to oracle. Which option is best sql server dts or Oracle Stream replication to replicate table data.

View 3 Replies View Related

Cannot Connect To Database After Switchover Without Making Changes In TNS Entry

Nov 19, 2011

I have an issue of not able to connect to the database after switchover without making changes in TNS entry after the switchover when I try to connect to then the primary database (which is standby before ) , the tns entry has entries for both the primary and secondary but the order of the primay and seconday database is to be changed manually till then it keep showing ERROR: ORA-01033: ORACLE initialization or shutdown in progress.

View 5 Replies View Related

Networking And Gateways :: Deletion Of LDAP Entry

Nov 25, 2010

We had an escalation wherein one of team members accidentally deleted an LDAP entry for a database. We use Oracle Net Manager to add/delete the connect descriptor.

Are there any logs using which we can find out as to who deleted the entry.

View 1 Replies View Related

Forms :: Avoid Duplicate At Entry Level

May 17, 2011

How can i avoid duplicate entry at entry level in form rather than when i pressed save button

View 2 Replies View Related

Application Express :: Data Entry Validation

Feb 25, 2013

I have to check if an entered item is identical to a previous entered item.

Tried to use the Page Level Validation but am confused with the way to do it.

P.S> The issue is that the entered item should be identical to part of the previous item (i.e. substr(P5_item, 1, 8)...)

View 3 Replies View Related

Server Administration :: Cannot Audit Entry In Dump

Jul 26, 2012

I am trying to enable auditing as

SQL> alter system set audit_trail=OS SCOPE=SPFILE;

System altered.

SQL> STARTUP FORCE
ORACLE instance started.

Total System Global Area 171966464 bytes
Fixed Size 2019320 bytes
Variable Size 113246216 bytes
Database Buffers 50331648 bytes
Redo Buffers 6369280 bytes
Database mounted.
Database opened.

SQL> show parameter audit

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /u01/app/oracle/admin/orcl/adu
mp
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string OS
SQL>

SQL> create user apexos identified by abc1;

User created.

SQL> grant connect, resource to apexos;

Grant succeeded.

SQL> audit select table, insert table by apexos by access;

Audit succeeded.

SQL> audit table by apexos by access;

SQL> SELECT audit_option, failure, success, user_name
FROM dba_stmt_audit_opts;

AUDIT_OPTION FAILURE SUCCESS USER_NAME
---------------------------------------- ---------- ---------- ------------------------------
TABLE BY ACCESS BY ACCESS APEXOS
SELECT TABLE BY ACCESS BY ACCESS APEXOS
INSERT TABLE BY ACCESS BY ACCESS APEXOS

cONN APPOS/ABC1

SQL> CREATE TABLE TAB1 (ID NUMBER, NAME VARCHAR2(20));

Table created.

SQL> insert into tab1 values (10, 'Michel');

1 row created.

SQL> insert into tab1 values (30, 'Andrew');

1 row created.

SQL> select * from tab1;

ID NAME
---------- --------------------
10 Michel
30 Andrew

SQL> /

ID NAME
---------- --------------------
10 Michel
30 Andrew

SQL>

SQL> select username, timestamp, action_name, action, SES_ACTIONs, sql_text
2 from USER_audit_trail where username='APEXOS';

no rows selected

SQL>

I also did not find any file contiaing the above statement as audit record in
/u01/app/oracle/admin/orcl/adump.

There are numerous old file in the /u01/app/oracle/admin/orcl/adump locaton. But When I executed the sql statement then that time no audit file was not generated in the location.

how to find audit record.

View 5 Replies View Related

Forms :: GO-BLOCK USES - Save Entry In All At Same Time?

May 16, 2011

I have a form with three block when i finish entry in 3rd block i use go_block for going to 2nd one but as i fired it oracle ask me for save trasaction

Actually i want to save entry in all form at same time

View 3 Replies View Related







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