SQL & PL/SQL :: How To Disable Procedure On Oracle
Oct 18, 2010how to disable procedure on oracle
View 3 Replies
ADVERTISEMENT
SQL & PL/SQL :: Disable Oracle 11 Audit (AUD)
May 31, 2012is it possible to disable audit logging (audit_file)? (Ora 11)
View 27 Replies View RelatedDisable Archiving In Session Level Oracle 11g Rel 2?
Jul 30, 2013I just want to write some data in a particular table,But I dont want it to be archivedSo is it possible to disable archiving in session level Oracle 11g Rel 2
View 3 Replies View RelatedReports & Discoverer :: How To Disable Printing Option In Oracle 10g
Sep 17, 2012By setting the parameters in set_report_object_property parameters we can disable the printing option in 11g. Do we have some kind of option , to do the same in 10g.
View 1 Replies View RelatedReports & Discoverer :: Disable Print Option In Oracle 10g?
Apr 11, 2010I want to disable print option in oracle reports 10g while it is opening in browser.Internet explorer version is 6.
View 3 Replies View RelatedEnable / Disable Archive Mode From The Pfile In Oracle 10g?
Jul 12, 2012I am using oracle 10g. Is there any mechanism to / parameter to enable or disable archive log mode? can I enable arching directly from pfile without touching the startup process?
View 2 Replies View RelatedForms :: How To Enable / Disable Keyboard Shortcuts In Oracle Apps
May 12, 2010How do we need to enable or disable the keyboard shortcuts in Oracle Apps like Shift+F6 for duplicate record, also how do I change the functionality, I mean suppose I want Key-M to do the same function as shift+F6.
View 2 Replies View RelatedDba_Jobs Disable Script
Aug 2, 2010I am trying to get a working script that could just go and mark all dba_jobs to BROKEN ==> TRUE
"execute dbms_job.broken(jobno,true)" using a pl/sql script
I have the working structure of the script except for the fact that the goal is not achieved. I came to know that the ALTER SESSION SET CURRENT_SCHEMA does not take effect when used with the DBMS_JOB API.
Is there an alternative I can get this working.
CODE<--------- part of the script : START
FOR l_job_users IN job_users LOOP
execute immediate 'alter session set current_schema='||l_job_users.LOG_USER;
DBMS_OUTPUT.PUT_LINE(current_user);
FOR l_jobs IN jobs(l_job_users.LOG_USER) LOOP
[code].....
Enable / Disable Auditing From PHP
Dec 15, 2010In PL/SQL Plus, i can enable/disable auditing when i connect as sysdba by using these command:
SQL> ALTER SYSTEM SET audit_trail=db SCOPE=SPFILE
SQL> shutdown
SQL> startup
I've done it successfully with PL/SQL Plus command line. But in PHP, how can i do that?How to execute "shutdown" and "startup" from PHP?
I've found this code for connect to oracle as sysdba:
oci_connect("/", "", null, null, OCI_SYSDBA);
From the following link:
[URL]......
But, i still can't execute "shutdown", "startup";
Forms :: How To Disable Function Key F4 In 6i
Feb 22, 2012How to Disable Function key F4 in forms 6i for example in forms i want that no body copy full row with F4 Key pls guide me where to apply key F4 trigger in forms.
View 1 Replies View RelatedSecurity :: How To Disable Sql Login
May 28, 2012How to disable a user's sql login? To ellaborate, I want a user to login through a certain application only with his userid on database level & not through "sqlplus username@dbname".
Is it possible? If no, then what can be done to achieve below.
I have a userid which has all the update, delete privileges on it. That id needs to be configured in the application alongwith the password. So in order to avoid misuse of that id I want to block its sql access.
I am not sure whether this can be achieved or not.
Forms :: Radio Box Disable
Dec 1, 2010I have a Radio Box Item field in Form, It contain Three Radio Buttons.
During the User Login Some of the users Not Require to Touch Any of the Three Radio. Thus i Require to Disable that Radio Button to That User. How to Disable the Particular Radio Button.
How To Disable FlashcacheMode - Writeback
Nov 1, 2012I'm trying to disable the new write flash cache feature that came with the latest Exadata patch on our Quarter RAC X2-2
The procedure i'm trying to follow is as described below:
1. CellCLI> alter cell flashcache all flush
2. CellCLI> drop flashcache
3. CellCLI> alter cell shutdown services cellsrv
4. CellCLI> alter cell flashCacheMode=Writethrough
5. CellCLI> alter cell startup services cellsrv
My problem is that when i'm running 1. i receive a syntax error.The only doc i could find describing how to go back from WriteBack mode is[URL]...
Forms :: How To Disable Shift+ Tab
Jul 22, 2010I wanna disable shift+tab key function not to be able to go to previous item. What should I do?
View 1 Replies View RelatedForms :: Disable The Commutation Tab?
May 11, 2011the software i use in oracle 10g is for calculating the pensionary benefits. Those who retire voluntary or on superannuation gets pension, commutation and gratuity.
for those death cases only family pension and gratuity is eligible.
my problem is when i give the pension case as family pension the commutation tab also gets visible and it allows the users to enter values for commutation even though they are not eligible.
i would like to know if i can disable the commutation tab once i enter the pension case as family pension.
Drop Or Disable A Scheduled Job
Oct 11, 2012I have a job running under HUMADM user and would like disable or drop it.I do not have the login credentials of HUMADM user but can log into the database as system/sys user.
When I run the below commands as sys/system user it says humadmjob must be a job or it is not running.This is because it is looking for the job under sys/system user.
exec DBMS_SCHEDULER.drop_job (job_name => 'humadmjob');
exec DBMS_SCHEDULER.stop_job (job_name => 'humadmjob');
SELECT owner, job_name, job_class, enabled FROM dba_scheduler_jobs;
OWNER JOB_NAME JOB_CLASS ENABLED
====== ========= ======= ======
HUMADM HUMADMJOB DEFAULT_JOB_CLASS TRUE
how to stop/disable this job? My oracle version is Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
REVOKE ROLE - Disable All Privileges?
Mar 1, 2012I am observing a strange behavior for the ROLES:
The DBA granted the RESOURCE role for my user USER1:
GRANT RESOURCE TO USER1;
The USER1 logged and activated the role RESOURCE.
CONN USER1/USER1
SET ROLE RESOURCE;
... it has some privileges in database ( UNLIMITED TABLESPACE for example that grant to him create table in any tablespace).
Now I created a new tablespace, but the user1 cannot use this new tablespace.So I will to revoke the RESOURCE for the USER1:REVOKE RESOURCE TO USER1;
It seems ok, but the user USER1 can still create tables in the new tablespace.I repared that UNLIMITED TABLESPACE still active, and the REVOKE RESOURCE just will have effect in the next LOGON of the USER1.
How can I REVOKE the ROLE and disable all the privileges from it immediately?
Disable All The Services For Node D Temporarily?
Dec 28, 2010There are 4 nodes in a RAC environment A,B,C,D..For instance i want to disable all the services for node D temporarily and hand over the Node D to the system admin guys and after the maintainance is done I want to restart the services again on node D..
View 1 Replies View RelatedSQL & PL/SQL :: How To Disable Or Enable All Constraints In A Table
Apr 8, 2010I knew, how to enable or disable a constraint on a table.
>alter table <table_name> disable constraint <constraint_name>;
But if we know all the data is correct, it's better to disable all constraints to improve the performance.
We are allowed to Disable or Enable only a single constraint.
Enable or Disable All Constraints.
Forms :: Disable Save Button In 6i
Jul 22, 2011I am working on form 6i. I want to disable the 'SAVE' button which can be seen in the menu (front end).
View 2 Replies View RelatedSQL & PL/SQL :: Temporary Disable All Constraint In Particular Table?
Jan 7, 2012i have one table HR.employees
SQL> desc hr.employees
Name Null? Type
----------------------------------------- -------- ----------------------------
EMPLOYEE_ID NOT NULL NUMBER(6)
FIRST_NAME VARCHAR2(20)
LAST_NAME NOT NULL VARCHAR2(25)
EMAIL NOT NULL VARCHAR2(25)
PHONE_NUMBER VARCHAR2(20)
HIRE_DATE NOT NULL DATE
JOB_ID NOT NULL VARCHAR2(10)
SALARY NUMBER(8,2)
COMMISSION_PCT NUMBER(2,2)
MANAGER_ID NUMBER(6)
DEPARTMENT_ID NUMBER(4)
SQL>
in this table i want to temporary disable all constraint in this employees table
Forms :: Disable Fields Using Personalization
Oct 2, 2010I am working on Oracle Apps 11i. Need Forms Personalization.
Client requirement: Selected user should only see Office Phone Number for all the people in the organization when he enters the Phones form.
Means, the client is having around 10 Lookup values for Phones (Like Mobile (Office), Mobile (Personal), Office (fax), Office No. etc). Now, they want to give access to admin, only to update the Phone numbers related to Office. So, when the admin logs-in to the phone form of a employee, that admin should not be able to see other phone numbers of that Employee.
Is it possible using Forms Personalisation?
SQL & PL/SQL :: Difference Between Disable Constraint And No Validate
Aug 22, 2010Is there any logical difference between DISABLE CONSTRAINT and DISABLE NOVALIDATE, in order to accept any new values into the table regardless of violating anything?
View 2 Replies View RelatedForms :: Disable Function Keys In 6i?
Apr 3, 2006how to disable function keys in forms6i(i.e., i want to deactivate the default function keys when running a form)
View 5 Replies View RelatedSQL & PL/SQL :: How To Delete Data Without Disable Constraints
Feb 14, 2013I want to delete data from say 100 tables without disable the constraints.
Tables having foreign key.. which is giving error if I select table randomly to delete.
I want to know the query which will give me the sequence of all tables based upon dependencies, so that If i delete the data on that sequence, it wont give me child record exists error.
How To Disable Index In Partition Table
Aug 11, 2010I am trying to disable the index i am getting the error like
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
the table have partition. how to disable the index in partition table.
Forms :: How To Disable Radio Button
Jul 16, 2013I have some doubts about Radio buttons,
1) how to validate radio buttons in WHEN-RADIO-CHANGED?
2) how to disable a radio button?
3) how to disable a text item when a radio button is un-checked.
4) how to assign default value to radio button like(1,2,3...) or(A,B,CD,...)
Spatial :: How To Disable Triggers Per Session
Mar 1, 2013I recently stumbled upon a post for an undocumented golden gate procedure that I find VERY useful when repairing / simplifying spatial data as a DBA without causing user triggers to fire and do unnecessary work, etc. Anything with foo in the name must be good, right? ;-)
HINT: Oracle please make this a documented feature!
This will disable triggers – just for a session – no system wide changes or trigger mods needed! Yes, fire needs to be set to true - to disable the triggers from firing.
exec sys.dbms_xstream_gg.set_foo_trigger_session_contxt(fire=>true);
Note, you will need execute permissions on sys.dbms_xstream_gg first.See for more info: URL.....
Forms :: Disable SAVE Button
Apr 20, 2010I have created a form using data block wizard and lay out wizard. I want to disable the SAVE button, I gave the following in Triggers WHEN-NEW-FORM-INSTANCE
set_item_property('SAVE',visible,property_false);
but when I run the form it displays this message at the bottom of the screen
Frm 41045:Cannot find item invalidID.
SQL & PL/SQL :: Disable Jobs Scheduled By User
Sep 13, 2010changing the user for a job.
There are 2 jobs which are scheduled in database by a user XX.
Now I need to make these scheduled jobs run by user YY.
In order to do this do I need to disable the jobs scheduled by XX and then create same jobs as before under the new user YY.