SQL & PL/SQL :: Enable Row Movement On IOT?

Nov 11, 2011

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.

View 3 Replies


ADVERTISEMENT

Server Administration :: Enable Row Movement?

Jul 3, 2012

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.

View 13 Replies View Related

Server Administration :: Enable / Disable Row Movement

Oct 20, 2011

for defragment of a table,

after enable it:

alter table test enable row movement;

do i need to:

alter table test disable row movement; ??

View 3 Replies View Related

SQL & PL/SQL :: Row-movement And Fragmentation?

May 29, 2012

find out whether the rowmovement option in a partitioned table will cause fragmentation or not?

View 3 Replies View Related

Server Administration :: How To Test Row Movement

Sep 6, 2011

How to test row movement? I want to a row data reside in two different blocks. how to do the test?

View 13 Replies View Related

PL/SQL :: Creation Of Stock Movement Report

Nov 8, 2012

I want to create a Stock Movement Report of a Health Management System in Oracle Report Builder 6i, as per following columns.

Sr. No Medicine Name Entry Date Opening Stock Stock In Stock Out Stock on-Hand
1 Mefnac DS 14-Aug-2012 50 450 50 450
15-Aug-2012 450 0 100 350
16-Aug-2012 350 50 400 500

Stock-In would be an aggregate sum of purchased quantity against particular medicine in a specific date.
Stock-Out would be an aggregate sum of issued quantity against particular medicne in a specific date.

View 1 Replies View Related

Exadata :: Compression And Partition Row Movement?

Mar 6, 2013

If I have a Partitioned Table set as COMPRESS FOR QUERY/ARCHIVE HIGH what would be the impact when a row in Partition X has to move to Partition Y?

View 3 Replies View Related

Reports & Discoverer :: Oracle Report Dynamic Text Movement

Jan 11, 2011

I have one report requirement like below diagrams, My report having one repeating frame and one dynamic LOGO field. My repeating frame have 2 field say item_no, and item_name. This repeating frame will grow based on the items say min 1 to max 8 items.

My dynamic logo has some min and max movement position, Say in the below diagram my dynamic logo min movement position is line no 6 and max movement position is 9.

Suppose i have only 1 or 2 or 3 or 4 or 5 items then LOGO should fit in the line no 6, if i have 6 items then logo should come in the 7th line, if i have 7 items then logo should come in the 8th line ect.,like that max 8 item will come in the report, if items are 8 then logo should fit in the 9th line number.
----------------
1|*****ITEM1****|
2|**************|
3|**************|
4|**************|
5|**************|
6|*****LOGO*****|-- MIN LOGO POSITION
7|**************|
[code]......

View 1 Replies View Related

SQL & PL/SQL :: Enable To Run Procedure Through Job?

Mar 30, 2011

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.

View 1 Replies View Related

Enable / Disable Auditing From PHP

Dec 15, 2010

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";

View 4 Replies View Related

Unable To Enable The Audit

Jul 5, 2012

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

View 4 Replies View Related

Application Express :: 4.1.1.00.23 - How To Enable SSP

Feb 20, 2013

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.

View 0 Replies View Related

SQL & PL/SQL :: Add Index Enable No Validate

Nov 1, 2011

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

View 4 Replies View Related

Enable Audit On Database Level?

Aug 27, 2013

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?

View 1 Replies View Related

How To Check If Parallel Enable In Session

Aug 18, 2010

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.

View 3 Replies View Related

Security :: How To Enable Auditing In Oracle

Dec 8, 2011

How to enable auditing in oracle ?

View 2 Replies View Related

SQL & PL/SQL :: How To Disable Or Enable All Constraints In A Table

Apr 8, 2010

I 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.

View 11 Replies View Related

Performance Tuning :: How To Enable AWR In Oracle 10g

Jul 12, 2013

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.

View 3 Replies View Related

SQL & PL/SQL :: Enabling Constraint With Enable No Validate?

Sep 5, 2013

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 ?

View 3 Replies View Related

SQL & PL/SQL :: How To Enable NOLOGGING In External Tables

Jun 16, 2011

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 ?

View 2 Replies View Related

Security :: Enable Auditing For Users?

Oct 10, 2012

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 ?

View 3 Replies View Related

PL/SQL :: Enable Dbms_job To Run On Every Day At 4am Excluding Fridays?

Jun 7, 2013

how to enable dbms_job to run on every day at 4am excluding Fridays.

View 7 Replies View Related

RAC & Failsafe :: Enable Audit_trail On 2 Node RAC ENV On Oracle10g

Nov 23, 2011

I 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.

View 4 Replies View Related

Client Tools :: How To Enable Profiler In Toad

Oct 2, 2010

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 Related

Forms :: Enable Insert Button For 1 Record Only?

Apr 3, 2013

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.

View 1 Replies View Related

Client Tools :: Way To Enable Dbms Profiler

Mar 4, 2010

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??

View 17 Replies View Related

Forms :: EBS Form Text Field Enable

Jul 17, 2013

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 Related

Client Tools :: Disable And Enable Constraints?

Feb 7, 2011

how 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 Related

Exadata :: Enable OLTP Compression On Tables

Sep 2, 2012

I 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?

View 2 Replies View Related

How Much REDO Would Increase If Enable Supplemental Logging

Nov 8, 2013

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.

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved