dblink - Scheduling a job in oracle to drop and create table -


I am trying to delete and create a table using a scheduled job. How do you do this? 

  drop table registration; You are probably looking to obtain physically, select the table entry * Registration_mv @ D3PROD_KMDW to    
 
 
 View instead of table?  Create physical visual registration in the form of registration * MV @ d3prod_kmdw   
 as registered * registration and then refresh it in the job  
  dbms_mview.refresh ('Registration');   
 This is better than leaving and making the table because PL / SQL objects will be invalid after leaving the table. With Mview it will be silent and without loss

Comments

Post a Comment

Popular posts from this blog

Android - Facebook GraphUser has no email attribute -

I checked online sources about this issue and checked it twice - but I still get the email attribute Can not Facebook Response As indicated on the launch, I have applied the permissions ("original_third", "email", "user_bridade") to read on the login buttons. Also set the same permissions when creating a session (session .createFromExistingAccessToken). However, on the callback function, when the GraphUser and Response object is logged, I was still not able to retrieve the user's email. Why the error still persists, what are the possible reasons for this? Am I missing some steps? ** onCreate () ** ((Login button) ViewById (R.id.dialog_generic_footer_button_fblogin)) .setPublishPermissions (FBSessionV2.getPermissions ()); String & gt; GetPermissions () {if (permissions.ISTT)} {PERMISSIONS.add ("basic_info"); PERMISSIONS.add ("email"); PERMISSIONS.add ("publish_actions"); PERMISSIONS.add ("user_birthda...
Read more

Opencart and VQMOD issue: Could not load controller in vq2-system_engine_controller.php -

I am using Opencart 1.5.6.1 and VQMOD 2.4.1. I have installed the Ewe Rapid 3.0 extension now and at checkout, I get this error: Notice: Error: Controller payment / EVE could not be loaded! On line 47 trigger_error ('Error: Could not load controller'. ($) At $ ($) ... \ vqmod \ vqcache \ vq2-system_engine_controller.php in line children! '!'); I'm not sure whether this is anything with the VQMD or EVE extension. How to fix this? Steps to try: Check if you have a eway.php in the list / controller / payment folder Verify the square name of that file: Class Controller Payment and Controller { . Check file permissions. It's a good day!
Read more

deployment - How to upload Parent child SSIS package to server -

Image
Hi all I am very new to SSIS I got some SSIS package developed by some other person, this flat after package mapping. Reads data from files and stores in the database. Flow: 1) To first extract the package into the flat file and in the table in the store 2) Then it calls the child package using the package package. 3) Then baby packages do some calculations and update the database table. The SSIS database is using environment variables to get information. Everything is working fine, but now I want to deploy it to the package on my client's server. Q: Do I need to copy and paste from the bin folder and paste it on the client machine? What I tried: I copy the file from the bin folder and keep it on my local computer. Then I prepare a job in MSSQL and run the work. The package runs completely but later I changed the location of my project and the problem started, the work stopped. Problem: An error says that the location of the hair package is not available (as I have changed ...
Read more