Oracle DBMS_SNAPSHOT_UTL.SYNC_UP_LOG

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path

Warning: the objects were exported by userprod, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing userprod's objects into userdeliv. . importing table "table_name"
IMP-00058: ORACLE error 12008 encountered
ORA-12008: error in materialized view refresh path
ORA-00001: unique constraint (userdeliv.SYS_C0091970) violated
IMP-00028: partial import of previous table rolled back: 24224702 rows rolled back
"BEGIN SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('userprod,'table_name'); "
"END;"
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
ORA-06512: at "SYS.DBMS_ISNAPSHOT", line 108
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 1666
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully

I have a materialized view log on a table.
I imported rows of that table in a development schema and I don't understand with oracle doesn't try to refresh the log of userdeliv and instead it tryes to refresh the log of produser: "BEGIN SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('userprod,'table_name'); "

and I can't find anything about DBMS_SNAPSHOT_UTL.SYNC_UP_LOG on oracle documentation.

How Oracle process Snapshot log?

we are updating a column in a very large table that will result in a very large mlog$.The column is not a part of the snapshot. We have only one simple snapshot that references this table.The testing proved that even this column is not a part of the snapshot Oracle will have to process the mlog$ fil ...

Oracle Performance Issue: Wait event "log file sync" and "Execute to Parse %"

In one of our test environments users are complaining about slow response.In statspack report folowing are the top-5 wait eventsEvent Waits Time (cs) Wt Time ------------ -------log file parallel write 1,046 988 37.71log file sync 775 774 29.54db file scattered read 4,946 248 9.47db file parallel wr ...

Oracle Regarding Snapshot log extents

All,I have to do maintanace activity with snapshot for the blow reasonPurpose: To keep snapshot log extents down to a reasonable number.For segments where extents > 1, see if table is empty. If empty and the number of extents and/or space allocated is a big number, truncate the snapshot log table ...

Oracle log file sync / log file parallel write: difference?

Can anyone explain the difference between the log file sync and log file parallel write events?The textual descriptions in the Oracle documentation are maddeningly similar:http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/waitevents003.htm#sthref4482When I graph the two events side by s ...

Oracle TT0781: Cannot sync log file

My database crashed, and I am getting this error on tterror.log and any command I send to my database*** [TimesTen][TimesTen 7.0.6.0.0 ODBC Driver][TimesTen]TT20100: This connection required recovery due to an improper shutdown -- file "db.c", lineno 11583, procedure "sbDbConnect"*** ODBC Warning = ...

Oracle implementing snapshot replication using pl/sql and dbms_sql

I'm trying to implement snapshot refresh programmatically using a control table to trigger the event and a separate pl/sql stored procedure for each table refresh. I can drop and re-create the snapshots outside of pl/sql with no problem. Once in pl/sql, I'm using the dbms_sql package to wrap the sna ...

Oracle ORA-12034:materialized view log on "snapshot_name"younger than last refresh

We want to upgrade our database from version 8.1.7 to version10.0.2 and the hardware platform is different.So we use export/import.But when we import the source database data into the new , some of the materialized view cann't run normally.When the materialized view freshes ,it always raise the ORA- ...

Oracle How to delete archived log on the drive that is multiplex redo log .

Using Oracle 10g on window server 2003Archive log is on c: driveMultiplex redo archive log is on d: driveWhen I run rman backup with delete archive log option it delete from c: drive and not D: drive How can i delete from both location ? ...

Attn:Many portalstudio.oracle.com pages unavailable: Database Log In Failed

Sometimes I am unable to see most of the content in portalstudio.oracle.com, but sometimes it's OK. I often see the error message below, but often either the links or dead or I get another error message.######Database Log In Failed TNS is unable to connect to destination. Invalid TNS address supplie ...

Display the IBM Sync Log file in MAB application

I need my MAB built application to display the contents of the IBM Sync Log file during sync process, which is performed inside my app. Ideas are welcome. ...

Oracle 'INVALID' for a new log group member.

Hi. I am a new-born DBA, so please bear for the kind of questions.I earlier had only single-membered online redo log. I added members to each group to make it dupled. But all (3) new redo log files added are being marked as INVALID. The files ARE accessible to Oracle. The file creation statements (o ...

Oracle Where does the console log go for 8.1.7 JVM?

We are developing using BC4J deployed as EJB's under 8.1.7 Stuff deployed locally which outputs using "System.out.println(...)" appears on the local JVM console log, which is handy for simple debugging/timing purposes. But no sign of the output in the MTS trace file (ie in ORACLE_BASE/admin/<SID ...

Oracle Updateable snapshot

I have two sites for replication. I created snapshot log on master table. Then i created snapshot on local site.When i update the master table through dblink my snapshot is also updating. BUT, WHEN I UPDATE THE SNAPSHOT , ONLY SNAPSHOT IS GETTING UPDATED NOT THE MASTER TABLE.I ran catalog,catproc an ...

Oracle RMAN failure for "archive-log ... not found in controlfile"

Recovery Manager: Release 8.1.6.0.0 - ProductionRMAN> connect target sys/XXXX@cldb;2> connect catalog rman/XXXX@rmandb1;3> 4> resync catalog;5> 6> # Backup the database7> run {8> allocate channel ch1 type disk;9> backup incremental level 0 format10> '/tools/cm/clearques ...

CORBA - Oracle DBMS acting as Client in a relation Client - Server

Hi,I'de like to invoke some services in an Transaction Server from my Oracle 8i Database (8.1.6) wich is in another machine. Is this possible in Oracle, and if so, are there any resources explaining how can i achieve this? Note that the transaction in the database must wait for the confirmation of t ...

Oracle transaction with no redo log

Is it possible to set some property so that a pl/sql procedure does not generate any redo data? This is a clean up sort of procedure and i am not worried about crashes etc. It would be quite ok if i had to rerun the procedure. ...

Oracle DBMS Version 6.1 Reserve Words

Is "report" a reserve word for DBMS Version 6.1? ...

Oracle create snapshot results in different column sequence

I found a behaviour of the 'create snapshot' I would not expect.The setup is:Master site: Redhat Linux 6.2, Oracle EE 8.1.7.0.1 Snapshot sites: Windows 2000, Oracle PE 8.1.7.0.0The column sequence on the snapshot site is different to the column sequence on the master site. Most of the snapshots are ...

Oracle Hide the password "sqlplus log/pass"

I am using the following command and running through the shell script.Unix Prompt> sqlplus abc/abc @sqlplus_settings.sqlNow when I do ps -ef |grep abc. It shows me the username and password "abc".How can hide the password ...

Oracle PL/SQL utl file error 6512

get error messsage 6512; unhandled user defined exception when calling utl_file.fopen. My file is on the server and I am trying to read it. My util_file_dirin init.ora is set to *. When running the stored procedure from the server, it runs fine. When running from a windows 98 client to the NT server ...

Oracle DBMS

WE ARE PLANNING TO TUNE OUR STORED PROCEDURES.CAN ANYONE HELP ME OUT IN HOW TO USE THE DBMS_PROFILER PACKAGE SO THAT I CAN GENERATE A REPORT USING THE PACKAGE ...

Oracle Updatable Snapshot Reorg

Looking to develop a procedure to reorganize updatable snapshots that will preserve the fast refresh capability.I am hoping to use alter table move which will preserve the constraints and indexes.What are the steps needed to disable replication to perform this type of reorg?Oracle 8.1.6 on NT 40. ...

Bad spfile - Oracle won't start - online log dest

Hi, My Oracle 9i instance on Win2K will not start. The error I receive is "ORA-01261: Parameter db_create_online_log_dest_1 destination string cannot be translatedORA-01263: Name given for file destination directory is invalidOSD-04018: Unable to access the specified directory or device.O/S-Err ...

Oracle Updatable Snapshot Replication

Is possible implementing "updatable snapshot replication" with Oracle Standard Edition ?null ...

Research papers on oracle dbms

all looking for research papers on the oracle rdbms . If anyone has any or can find any of any sort it will be much appreciated . ...

Oracle <-> DB2 Bi-Directional Sync, Master-Master DB setup with differing vendors

I am working for an agency which needs to synchronize(bi-directional) a master-master database configuration (Oracle <-> DB2) between sites hosted in Washington ,DC and Europe.We are doing high level estimates right now of in-house development , Oracle Golden Gate and DBMOTO, MQ...etcDoes anyo ...

Oracle DBMS package run

Is there any provision to run a perticular procedure at a perticular time.and how.for example at night 12 oclock this process will run ...

Oracle DBMS JOB

I'd like to create a new job with dbms_job.submit. This job should start the procedure that I created. The procedure should start every 5 minutes. I looked into the dbmsjob.sql-script and found the examples with 'sysdate+x' as interval. What is the correct interval for minutes or seconds? Another qu ...

How can i connect from w2k to VMS Oracle DBMS

anybody an idee? How can i connect from w2k to VMS Oracle DBMS.thx for your helpSpassi ...

Oracle CREATE SNAPSHOT quirk

I have run into something strange and i was wondering if anyone else might have clue for me here. I am trying to run a Create Snapshot statement and i keep getting a ORA-01031 error. I have "Create any" granted on create view, create table, create snapshot, and create index as well as unlimited tabl ...