asktom.oracle.comAsk TOM

Site Feedback Sign In Questions Office Hours Videos Resources Classes Ask The Oracle Mentors Recently Answered Ask a Question All Questions Recently Answered 2.0 #SELECTION# FAST out-of-place materialized view refresh problem I encountered a problem related to forcing the refresh procedure on the materialized view in a combined manner: - refresh_method = ’F’ - out_of_place = true DBMS_MVIEW.REFRESH(’FOO_MV’, out_of_place = true, atomic_refresh = false, method = ’F’); For the past few days, I hav #MISC# #ACTIONS# #SELECTION# How to retrieve single hierarchy from Multiple Hierarchies Hi, There are several examples of hierarchal queries using the employees-manager example. Recently i came across hierarchal scenario where the table was storing multiple hierarchies. example data: CREATE TABLE example ( Title VARCHAR2(50), ID NUMBER, Link_id NUMBER #MISC# #ACTIONS# #SELECTION# Is it possible to create a private user under a DB schema? We are writing to discuss an operational challenge that we are currently facing with the integration of Oracle Integration Cloud (OIC) and Oracle Autonomous Database within our organization. Our setup utilizes OIC as the primary integration layer, in conjunction with the Autonomo... #MISC# #ACTIONS# #SELECTION# Call shell script using stored procedure /function. Hi, I want to create a stored procedure / function which will call shell script and shell script will have command to copy the file from particular location of DB server to another location of DB server. I tried using the scheduler job same is working fine but i don’t want to use... #MISC# #ACTIONS# #SELECTION# Sequence issue Hi Tom , Not sure about category of this question but will explain the same We had come across one issue .. In pre staging server environment sequence column is generating incremented value as per the last record updated in a table via procedure (which is what we want and is fine... #MISC# #ACTIONS# Upcoming Office Hours All Upcoming Upcoming Office Hours report Oracle | Integrated Cloud Applications & Platform Services Facebook Twitter LinkedIn YouTube Oracle RSS Feed © Oracle Site Map Terms of Use and Privacy About AskTOM AskTOM 5.0.7 Built with love using Oracle APEX 5.0.7 Built with using Oracle APEX (opens in new window) ’);...