I want to ask will be a beta refresh for managed provider soon. I reported a few bugs, one of them is a stopper and I wander are they fixed ?
Bug: Oracle Managed Provider and BindByName
and
Bug: Oracle Managed Provider and comments in SQL
I have one database which is recently upgraded from oracle 8.1.5 to oracle 10.2.0.4.The database is having around 300 tablespace and total size of the database is 1.5 TB.
The database was created in oracle 8i and all the teblespace were DMT(Dictionary Managed Tablespace) .Usually after up gradation all the tablespace are in DMT mode. Now my requirement is to convert all the tablespace into LMT (Locally Managed Tablespace) so that I can AVAIL ALL THE FEATURES OF LMT.
This database is a mission critical database and very less downtime can be allowed.
How we can create dictionary managed temporary tablespace in Oracle 10g.
SQL> create temporary tablespace temp
2 tempfile '+GWDAAS04_TEMP_DG01/pimsb_gw/tempfile/temp01.dbf' size 500m
3 extent management dictionary;
create temporary tablespace temp
ERROR at line 1:
ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE
we have a client side application, on Windows and Oracle 10g R2.We use OLEDB templates from MFC (CDynamic Paramete rAccessor).There is a long query (4610 char) what provider return E_UNEXPECTED HRESULT (from execute, before the bind).
No detailed info from provider (GetErrorRecords() return E_FAIL).If I copy this query into SQL* Plus, it run without error.There is an almost the same query run successfull, the difference is only in two added order by and alias column.
recordset properties was:
stPropSet.AddProperty(DBPROP_BOOKMARKS, true);
stPropSet.AddProperty(DBPROP_CANSCROLLBACKWARDS, true);
stPropSet.AddProperty(DBPROP_CANFETCHBACKWARDS, true);
stPropSet.AddProperty(DBPROP_QUICKRESTART, true);
[code]...
connection string is:
"Provider=OraOLEDB.Oracle;User ID=user;Password=pw;Data Source=foto1;ChunkSize=4000"
We just upgraded one of our databases to 11g on a new server. The 3rd party application that accesses the db is 32 bit. The software needs to be running on the db server in order for some transactions to occur. Since the oracle client on the db server is 64bit do we need to install a 32 bit client as well. As of right now we are getting an error in the software when trying to connect to the db that says "Test failed. provider cannot be found. it may not be properly installed." This is a live production server so uninstalling and reinstalling oracle is not really an option at this time (unless absolutely necessary). How will installing a 32 bit oracle client effect everything (if that is the route we need to take).
View 3 Replies View RelatedI am getting ORA -32320 when I tried to fast fresh MVs that were truncated.I am able to complete refresh all MVs. However, some MVs are still giving me ORA-32320 when I try to do fast refresh even after complete refresh.
DBMS_MVIEW.EXPLAIN_PLAN says the MVIEW can be fast refreshed.
ERROR at line 1:
ORA-32320: REFRESH FAST of "dev"."Claim_line" unsupported after cointainer table
PMOPs
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 841
ORA-06512: at line 1
Quote:ORA-32320:
REFRESH FAST of "string"."string" unsupported after container table PMOPs Cause: A Partition Maintenance Operation (PMOP) has been performed on the materialized view, and no materialized view supports fast refersh after container table PMOPs. Action: Use REFRESH COMPLETE. Note: you can determine why your materialized view does not support fast refresh after PMOPs using the DBMS_MVIEW.EXPLAIN_MVIEW() API.
how to again make the MVs fast refreshable?
I've got one database which was Initially upgraded from Oracle 8i to 10.2.04 running on windows. Most of the tabespaces are Dictionary managed. Do you think moving them to locally managed tablespace would give me better performance?
if Yes, what approach I should apply to move them to locally managed? I would like to do this with minimum/no downtime.
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 RelatedFor a locally managed tabelspace, the dropped segment is changed to a Temp. Segment, to prevent bitmap from being updated.
View 2 Replies View Relatedthis query works ok in oracle.dataAccess but not in Oracle.ManagedDataAccess.Connector does not raise an error. It just stalls.
Dim PKRetrieveCommand As New OracleCommand : PKRetrieveCommand.Connection = JobConnection
PKRetrieveCommand.CommandText = " INSERT INTO TMP_SEQ (FIELD1) VALUES (DBOID_SEQ.NEXTVAL) RETURNING FIELD1 INTO :dboid"
PKRetrieveCommand.Parameters.Add("dboid", OracleDbType.Decimal, ParameterDirection.Output)
PKRetrieveCommand.ArrayBindCount = allInserts.Length
PKRetrieveCommand.ExecuteNonQuery()TMP_SEQ
Is a temporary table that deletes rows on commit, Field1 is a numeric type and DBOID_SEQ. is a sequence.
when i press the save button in my application the record will be saved but the value in my "display item" wont be refreshed. when i minimize the form designer and maximize it again, the "display item" is refreshed.
so i am searching for a "refresh" function
SYNCHRONIZE;
redisplay;
these functions doesn't work.
My standby database was working fine which was running in maximum performance mode .Suddenly i found that logs are not being applied though archived logs are received from primary database.i issued the command in mount mode: alter database recover managed standby database disconnect from session;
altered database this command runs successfully. but MRP process in not initiated which i confirmed with the query (select process,status from v$managed_standby;)
I am trying to use oracle wallet with the new odp.net managed driver, but I am getting
"invalid username/password".
As the wallet itself is ok (it works with the unmanaged client), seems to me that this new provider is not fully compatible with Oracle Wallet. Is this true? I am trying this:
<oracle.manageddataaccess.client> <version number="*"> <settings> <setting name="tns_admin" value="D:oracleproduct11.2.0client_1
etworkadmin" /> <setting name="WALLET_LOCATION" value="D:oraclewallets" /> </settings> </version> </oracle.manageddataaccess.client>
My materialized view has to get refreshed as part of a scheduled package. When I refresh the materialized view manually using the following statement,
DBMS_MVIEW.REFRESH('info.sales_fact_load_mv', 'C');
it is working fine. However, when I use the same statement in the package which is scheduled to run every morning, it is not working. What could be the reason?
I'd like to set up a new Oracle Materialzed View to automatically default to refresh FAST every hour. I have no trouble setting this up in the CREATE MATERIALIZED VIEW statement. However, we will occasionally be performing table maintenance on the table referenced by the MV. At that time I would like to use dbms_mview.REFRESH to execute a refresh ON COMMAND (either F or C depending on the operation weperformed on the table). I have read that this will override the automatic refresh every hour that was set up for the MV when it was created. However - wil the override be permanent? Or will the MV continue to automaticaly FAST refresh every hour after the ON COMMAND refresh is completed?
View 1 Replies View RelatedHow to find applied_time in standby database managed recovery mode (*PHYSICAL STANDBY*).
View 3 Replies View Relatedwe want to truncate a oracle Table in the Oracle DB. After the truncate the fact table will be loaded again. After the new load in the fact table we want to tell the times ten db to refresh the cache table. The cache Table is a user owned read-only cache group with no autorefresh. We want to tell times ten in a PL/SQL Block from Oracle DB that starts the refresh from the cache group in times ten. The refresh should not be a autorefresh because the refresh should only start if the fact table will new loaded after the truncate.
View 1 Replies View RelatedI would like to know whats the difference between these backups methods:
Image Copy:
BACKUP AS COPY TABLESPACE users;
and
User managed copy:
SQL> ALTER DATABASE BEGIN BACKUP;
... cp users.dbf file
SQL> ALTER DATABASE END BACKUP;
I know that Oracle catalog the image copies in control file and RC automatically.
I will have to proceed with Oracle 9 database refresh from production server to integration server. 5 biggest schemas must be exported and imported. They constitute 97% space used in a database. This is very big database so I would like to be sure that everything will go smoothly. That is why i want to ask you some questions.
Have you got any clues for me before I start with exp/imp? From my side i will tell you that I will have to exp/imp schema by schema because there is small space both on production and integration disk for a dump. First thing I thought are dependencies between schemas that are exported and that which are not, and also between schemas that are exported/imported one by one.
This is procedure that I plan:
For every schema that is to be refreshed
{
1. Export schema with ROWS=N CONSTRAINTS=Y
2. EXPORT schema with ROWS=y CONSTRAINTS=N
3. Import schema from step one
4. Disable all the foreign key constraints using ALTER TABLE DISABLE CONSTRAINT.
5. Import schema with rows
}
ALTER TABLE ENABLE CONSTRAINT
With above procedure i think that I will avoid problems with dependencies between schemas exported/imported one by one. But my concern is if there are any dependencies between those schemas and schemas that are not exported. Is there an way to check it before refresh ?
How can we refresh a database ?
View 3 Replies View RelatedI have 5 MViews that I want to refresh in two occassions, every sundays and at the 1st of the month. I created a Refresh Group for the weekly and that work fine. But when I tried to created the second Refresh Group for the monthly I get a "materialized view is already in a refresh group".
You can only have a materialized view in one refresh group? What options to I have to refresh it in different intervals?
I have a created a materialized view which is based on a view on remote database. Now how do I refresh the view.
Materialized view is created by
CREATE MATERIALIZED VIEW mv_employee_name
AS SELECT EMPLID, EMPL_NAME
FROM VEMPDATA@REMOTEDB
WHERE REGION = 'US';
how the refersh happens or how do I specify the refresh clause.
REFRESH FAST option is looking for VIEW LOG on the master table but in this case its a remote view, so I cannot create any object on remote db.
A scheduler job is there to refresh some materialized views. All the views are run under single job name. Some mviews are not refreshing and those are not refreshing in the next run too.if we run those mviews manually then they are working fine from then . after some days those views which i told before are not refreshing and this happens frequently and i check the job_run_details views also and i am not seeing any errors in that.
View 6 Replies View RelatedIs there any function to refresh all views and functions in oracle.
View 4 Replies View RelatedI have n number of materialized views in my schema ..I want to refresh all M_views at once by using cursor
View 3 Replies View RelatedHow to refresh a view and where is a log located?
View 2 Replies View RelatedDuring the MV refresh we are getting the following error and not able to fix it .
SQL> EXECUTE DBMS_MVIEW.REFRESH('EMP','F');
BEGIN DBMS_MVIEW.REFRESH('EMP','F'); END;
*
ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-01400: cannot insert NULL into ("XYZ"."EMP"."DESCRIPTION")
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2426
ORA-06512: at line 1
The above column:- Emp.Description is a 'CLOB NOT NULL' .
We have created the MV using the below script
create materialized view EMP refresh on demand for update as select *from ABC.EMP@DBLINK;
My MVIEW has a refresh rate (sysdate + 1 ) + 24/24 So how often it gets refreshed .
View 3 Replies View Relatedi already created metalized view
now i want to set MV as incremental refresh option?
is it possible to set this attribute after mv created..?
I have created a materialized view log on table testing_mview_rev in 11g:
SQL> CREATE MATERIALIZED VIEW LOG ON testing_mview_rev WITH ROWID;
Materialized view log created.
And a MV on it in 10g:
SQL> create materialized view testing_mview_1_rev REFRESH Force start with (sysdate) next (sysdate+1/1440) with rowid as select * from testing_mview_rev@S58_TO_S56;
Materialized view created.
Now this is suppose to automatically refresh itself every minute but refresh is failing. However manual refresh is working fine.
what I have missed here. is there any other way to schedule the MV to run every minute?