I am trying to execute procedure using dbms scheduler.but i am getting below errors
ORA-06550: line ORA-06550: line 1, column 407:
PLS-00103: Encountered the symbol "AMANORATEST" when expecting one of the following:
:= . ( @ % ; immediate
The symbol ":=" was substituted for "AMANORATEST" to continue.
, column :
but procedure is executing fine with sql commmand line.
I have the table is partitioned.
Can I set the table table to "alter table x enable row movement" even when it is index organized table?
How do I know if the table is INDEX ORGANIZED TABLE.
In 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";
I facing the below issue while enable the audit on table.
SQL> audit delete on test;
audit delete on test
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01400: cannot insert NULL into ("SYS"."AUDIT_DDL"."DICT_OBJ_TYPE")
ORA-06512: at line 2
===
Related Information
===
SQL> select version from v$instance;
VERSION
-----------------
11.2.0.2.0
SQL> show parameter audit;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /orasw/product/11.2.0
/rdbms/audit
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string DB
SQL> SELECT TABLESPACE_NAME,owner from dba_tables where table_name='AUD$';
TABLESPACE_NAME OWNER
------------------------------ ------------------------------
AUDIT_DATA SYS
I have Apex 4.1.1.00.23 and I want enable Session State Protection (just for testing and for learning how this works).
When I go to Home --> Application Builder --> Application 121 --> Shared Components --> Session State Protection and I click Set protection button I get to the page where I have 3 options (Disable, enable and Configure SSP).
After clicking on enable option, I get to page [URL].......
There is no Finish or submit or complete or confirm button, only cancel and previous (print screen is on picture). I found out that SSP is already enabled so I can't enable it again. But other question is still open, how to get it now to work in real.
I have a table, it has 3 terabytes of data. We are sure whatever the data we have in that table is valid. I need to add the index to table it should be enabled and need not to be validated for existing data.
I am using following command
CREATE INDEX U_IXN_MTRS_ORGIDMTRNOMTRTYPEID ON MTRS (nlssort(METERNO), METERTYPEID) TABLESPACE OLTP_IDX_TS ENABLE NOVALIDATE;
it is giving me problem
ORA-02158: invalid CREATE INDEX option error
1.) Whatever statics/data should we gather to compare the database performance before and after enable the audit on database level?
2.) How can we enable audit on database level?
3.)what is pros and crons of enable audit database level?
I need to know if PARALLEL is enabled in my session. Would this be a session parameter or something else? Is there a view I have to query or some SQL*Plus command to execute?
P.S. Is there a way to correct the title spelling after submitting.
How to enable auditing in oracle ?
View 2 Replies View RelatedI 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.
I have installed database in one server. I would like to enable AWR into it. Statistics_level is set to Typical. While running the below script to enable the AWR, its gives error -
SQL> exec dbms_scheduler.enable('GATHER_STATS_JOBS');
BEGIN dbms_scheduler.enable('GATHER_STATS_JOBS'); END;
*
ERROR at line 1:
ORA-27476: "SYS.GATHER_STATS_JOBS" does not exist
ORA-06512: at "SYS.DBMS_ISCHED", line 4343
ORA-06512: at "SYS.DBMS_SCHEDULER", line 2802
ORA-06512: at line 1
make AWR automatical generation.
Is there any way to enable the constraint with out validating for the existing information.
As We can accomplish the same functionality when we are adding the constraint for the first time.
Ex: alter table scott.emp add constraint fk_deptno foreign key(deptno) references scott.dept(deptno) enable novalidate
The above SQL statement will enable the constraint with out validating for the existing information. So there is possibility of data will be there only in the child table but not in the parent table for existing information.
But in the future it will not allow to do so,if the constraint is in ENABLE staus.So i am just trying to disable the constraint to insert only into child table & trying to enable it with NOVALIDATE option .
But the following exception is coming .
SQL> alter table scott.emp ENABLE constraint fk_deptno enable NOVALIDATE;
alter table scott.emp ENABLE constraint fk_deptno enable NOVALIDATE
ORA-00905: missing keyword
SQL> alter table scott.emp ENABLE constraint fk_deptno NOVALIDATE;
alter table scott.emp ENABLE constraint fk_deptno NOVALIDATE
ORA-00933: SQL command not properly ended
Instead of dropping & recreating the same constraint , is there any alternate way to do this ?
I have a job that runs the following commands for each table in a schema.. (I just inherited it ugggg)
alter table ODS.ODS_MONTHLY_MF_AUM enable row movement;
alter table ODS.ODS_MONTHLY_MF_AUM shrink space;
alter table ODS.ODS_MONTHLY_MF_AUM disable row movement;
On occassion I get this error when enabling row movement
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
Other than dealing with apps that depend on ROWID's is there any negative impact to always keeping row movement enabled for tables.
Secondly, does any body have a script that can determine if the space really needs to be shrunk for a table.
How can I enable NOLOGGING in an External Table ?
My Table FT_PRICE_COST_MASTER is taking a long time(more than 1 hour) to excute inside the procedure. The statement is:
SELECT SUBSTR(m.sr_no,1,16) SR_NO, m.SKU_CODE, m.location_code, m.start_date, m.end_date, m.COST, m.tax, m.octroi, m.freight, m.cash_disc, m.scheme_disc, m.mrp, m.csp, m.rsp1_qty, m.rsp1_value, m.rsp2_qty, m.rsp2_value, m.rsp3_qty, m.rsp3_value, m.net_cost, m.final_cost, m.current_margin, m.pc_effect, m.created_by, m.creation_date, m.modified_by, m.modification_date, m.change_ind, m.tax_code,
[code]......
When I am recreating the External table with NOLOGGING keyword at the bottom of the synatx, it's showing "operation not supported". Else are there any other points that I should look to increase the execution time of the above statement ?
i enable auditing on the database 10.2 for users,
once i query SQL> SELECT username,
extended_timestamp,
owner,
obj_name,
action_name
FROM dba_audit_trail
WHERE owner = <Username>
there are many many rows , my question is , are you enable to truncate it from time to time , if not ,is it effect on the performance of the database ?
how to enable dbms_job to run on every day at 4am excluding Fridays.
View 7 Replies View RelatedI have a production database with 2 node Physical RAC ENV on two separate machines , and we are going to enable audit trail parameter to DB values to capture all failed login attempts on a database.
we have done this on our testing ENV but dont know the procedure to deploy this steps on 2 node RAC ENV . I have done the below steps on our standalone testing ENV
1.Log in as SYS and connect with the SYSDBA privilege.
oUser Name: SYS
oPassword: Enter your password.
oConnect As: SYSDBA
2.To enable audit on DB use below command
SQL>alter system set audit_trail=DB scope=SPFILE;
3.Then restart the database.
4.After successful startup use the below command to capture log
SQL> audit create session whenever not successful;
steps to enable audit_trail to capture failed login attempts on two node RAC ENV.
I'm using toad 9.2.7.5 to do my plsql development. How I can enable the Profiling option so that I can analyse the performance of my stuff - currently the grey profiler icon is greyed out
View 1 Replies View Relatedfor defragment of a table,
after enable it:
alter table test enable row movement;
do i need to:
alter table test disable row movement; ??
I have a form with a block at header level. Once you save your header, there is a second block at line level. I want to be able to enter only one record at header level and line-level.
Also if you search on an instance which already has a record at line-level then i want the insert button to be greyed out.
Similarly once you create your first record at line-level the Insert button should be greyed out.
i want to tune my plsql code using dbms_profiler.
but dbms_profiler is disabled in my TOAD.
i have GRANT on this pkg. even though i have it disabled. how should i enable it??
I am working on oracle ebs r12 and wants to enable text field (amount column in attachment) which is disable into form. How can i meet this requirement.
View 3 Replies View Relatedhow to disable and enable all constraints pertaining to one table at once. I want to disable them at once and also enable them at once. I make use of TOAD.
View 14 Replies View RelatedI am trying to enable OLTP compression on tables and at tablespace level for the tables
Steps I am following are:
1. Move indexes to its own tablespace
2. enable OLTP compression at table level:
alter table table_name move compress for OLTP
3. Rebuild indexes
4. Issue I have is what to do with tables with LOB columns
ALTER TABLE lob_table MOVE LOB (LOB_COL) STORE AS (TABLESPACE index_tbsp); -- Is this correct?
5. alter tablespace data_tablespace default compress for OLTP;
I have a question, is the sequence of steps correct. For tables with LOB columns do we needto move lobindex to index tablespace. Beacuse lobsegment and lobindex are created in data tablespace?
we use Oracle11gR2 on Win2008R2 .By erroneous operation of OracleDB, there was trouble that we could not log in to Application(Oracle Insight) running on Oracle11gR2. I looked up and understand by running the below ALTER DATABASE ADD SUPPLEMENTAL LOG DATA we can find the SQL statement that was executed in the past from SQL_REDO column of V$ LOGMNR_CONTENTS table, undo SQL statement to rollback from SQL_UNDO column of V$ LOGMNR_CONTENTS table. But , we are concerned about the adverse effect of enabling the supplemental log because it is production environment . I heard the contents of the REDO log will increase if we enable supplemental log.
Q1-How much the REDO log would increase roughly if you enable supplemental log ? ( I am concerned about the issue of the capacity of the REDO log and the problem of DB performance . )
Q2-Is it necessary to restart the DB instance to enable supplemental logging after executing the below ?ALTER DATABASE ADD SUPPLEMENTAL LOG DATA.
Q3-Is there any other adverse effect we should care if you enable supplemental log ?
Q4-Logminer is usable if DB is running on no-archive mode ? In my understanding , it is possible if you enable supplemental log and have the REDO logs we would like to analyze.
what happen in standby when enable flashback in the primary database?
View 1 Replies View RelatedI have one tabular block on the canvas and there is one check box on this block. I want that when I uncheck this checkbox, one item on the current record gets disabled.
i manage to turn all the records enabled or disabled.
I am attaching a dummy form in which I have tried. Checkbox is acting on field :ecc_no.
The DB table for the same is:
CREATE TABLE ECC_MASTER
(
PARTY_TYPE CHAR(1 BYTE) NOT NULL,
PARTY_CODE CHAR(5 BYTE) NOT NULL,
ECC_NO VARCHAR2(25 BYTE) NOT NULL,
RANGE_DIVISION VARCHAR2(30 BYTE),
EMP_NO NUMBER(4) NOT NULL,
[code]....
I have a scenario wherein i want to enable / disable a block based upon value of one of its column value. i.e., if value of approval status in
(IN ( 'INCOMPLETE' , 'RETURNED' , 'REJECTED' ) THEN
SET_BLOCK_PROPERTY('RFN_HEADERS_ALL', UPDATE_ALLOWED, PROPERTY_TRUE);
SET_BLOCK_PROPERTY('RFN_LINES_ALL', UPDATE_ALLOWED, PROPERTY_TRUE);
SET_BLOCK_PROPERTY('RFN_HEADERS_ALL', DELETE_ALLOWED, PROPERTY_TRUE);
SET_BLOCK_PROPERTY('RFN_LINES_ALL', DELETE_ALLOWED, PROPERTY_TRUE);
else.....
but the code is not working in pre-query, pre-select or post-query
Enable / Disable menu items for different users.
how to create different users give in demo files i am using 10gforms.
How to enable firewall for Oracle Database..? Is it db specific..? or If I implement the firewall It will be applicable to all the databases in the server which are using same oracle home..?
View 7 Replies View Related