Query Tablespace For Flashback Enabled / Disabled
Jun 16, 2011Since tablespaces can be enabled/disbaled for flashback is there a query that can tell me the flashback status of each tablespace in my DB.
View 2 Replies
ADVERTISEMENT
How To Audit When A Constraint Is Disabled / Enabled Or Dropped
Sep 3, 2013Is it possible to audit when a constraint is disabled, enabled or dropped? Sometimes I wonder why some constraints are missing. To make sure someone is dropping I would like to audit that action. Further, I would need to compare schemas to realize if some constraints are missing. As it names are generated automatically by oracle, how could I easily run a select to compare the constraints that does not match between schemas?
View 10 Replies View RelatedForms :: Disabled List Item Will Be Enabled Accordingly Just By Clicking
Feb 4, 2013I have a problem in oracle forms. I have a block that displays five records in list item. On load, it will query two data in my table. So the list item (poplist) one and two enabled. (The default of oracle forms - List item one and two are enabled and the rest are disabled because one and two have data).
My problem was, what work around will I gonna do so that if I pressed the mouse in the third list item it will automatically enabled (for a new record) and if I pressed the list item one or two the third item will stay disable (even the fourth and fifth) because simply the user wants to update the item one or two in the list.
Forms :: SUBMIT Buttons Which Is Disabled / Gets Enabled Automatically
Apr 3, 2012I have a scroll bar in my form. When i scroll the bar, one of SUBMIT buttons which is disabled gets enabled automatically. Do we have any triggers on scroll bar where i can disable the button again.
View 4 Replies View RelatedForms :: A Button Has To Be Disabled In Query Mode (F11)
Apr 3, 2012Am developing a custom form. I have a block with 5 Items and one button(SUBMIT). When I go in query mode (F11), SUBMIT button to be disabled. How do i achieve this.
View 22 Replies View RelatedQuery On Index Move Into Particular Tablespace?
Sep 3, 2010I have already created large no of indexes on my Database without specifying specific tablespace, now I would like to move all the created indexes into particular tablespace.
View 3 Replies View RelatedServer Administration :: How To Query A Tablespace Being Used By Which Object
Jul 6, 2013My Oracle db have this tablespace named INDX which is 80% full. I tried to query on the table, user using it but there is no one using this tablespace
May I know if there is a query that i can used to find out which dba_object is consuming the 80% of this tablespace.
SQL & PL/SQL :: Query To Get Default Tablespace Of Current User?
Oct 27, 2010I need query to retrive the default tablespace of the current user, when the user is not a dba, i.e. user doesn't have access to dba_users table.
View 2 Replies View RelatedWhy Database Trigger Can Became DISABLED
Apr 30, 2013We have an application, using ddl database trigger on oracle database.Trigger depends on package and several tables, package depends on user defined function.It works on different customer sites well, but for one customer (11g?), sometimes (cannot determine when and why), trigger became disabled.
I know, that trigger can became invalid, when its dependencies changed (i think in this situation oralce probably try to re-compile it). I understand that it can changed to be invalidwhen dependencies are not valid.I know I can alter trigger to became disabled manually.
But when it can became disabledwithout explicit alter statement be run!? Are there some conditions / circumstance when Oracle changed the trigger to be disabled?We'll ask the customer DBA team to enable audit on trigger, but it will take time to be done..
Tablespace Query - Output In Terms Of Maxsize And Not Size Allocated
Oct 11, 2012Tablespace freespace query which will give output in terms of maxsize and not size allocated ?
View 14 Replies View RelatedHow To List Disabled Database Instances
Nov 2, 2011Currently, the only way I can find of doing so is to try to disable an instance, and if it is already disabled, it warns you that its disabled. This is not exatly an ideal solution! How do I simply run a query or issue a crs command to list all disabled database instances.
View 1 Replies View RelatedSQL Performance Analyzer Link Disabled
Apr 10, 2012Oracle Enterprise Manager 11g, navigating to the Performance tab for our test database. The "SQL Performance Analyzer" link is not apparent (as is all the other links).
I checked the "setup", in particular, the Management Pack Access ... all of these have checks by them ...
Database Change Management Pack
Database Configuration Management Pack
Database Diagnostics Pack
Data Masking Pack
Database Tuning Pack
Provisioning Pack
Pack Access Agreed.
Also, checked the value of the "control_management_pack_access" which reads "DIAGNOSTIC+TUNING"
How to get the "SQL Performance Analyzer" link enabled? Apparently, according to one of my colleagues, they used it about a month ago, so I don't know what could have happened between then and now.
Forms :: All Block Fields Are Disabled
Dec 11, 2011I am using Forms 6i in Application. In Form, After i enter the data and saved then,if i retrieve the data by using Ctrl+F11, all the fields of data block turns to be disabled (insert not allowed, update not allowed) of course i am getting the data.If i close the application, and open freshly it works good (insert allowed, update allowed).
View 1 Replies View RelatedPoor Performance With Free Tablespace Checking Query Generated By DB Artisan?
Jun 12, 2012Our production DB version is 11.2.0.1 and we do use DBArtisian. Everyday morning we check table space usage using that tool and it generates the below listed query. It used to run in 15 secs. But since one week it is running for 5/6/8 mins. I have updated the statistics on sys objects and tuning advisor created the execution plan. So, now it is running in 2 mins. Nothing has been changed in the DB configuration. I see the same query running in secs in dev environment. understand what might be the issue and how could I improve the performance of this query.
SELECT SUB.TABLESPACE_NAME, SUB.STATUS, SUB.EXTENT_MANAGEMENT, SUB.SEGMENT_SPACE_MANAGEMENT, SUB.TOTAL_SPACE_MB, SUB.USED_SPACE_MB, SUB.FREE_SPACE_MB, SUB.PERCENT_FREE_SPACE, SUB.CONTENTS, SUB.TABLESPACE_GROUP, CASE WHEN SUB.TABLESPACE_NAME = P.VALUE AND SUB.CONTENTS = 'UNDO' THEN 'YES' ELSE 'NO' END
[code]...
Save Password Disabled In Login Screen
Dec 6, 2011I have Toad 9.6.1 already installed on my machine and have now installed Toad 10.6 . unfortunately the Save Passwords option on the Connection screen is disabled. how do I enable that option.
View 2 Replies View RelatedForms :: Fields Not Getting Disabled In Mouse Click?
Apr 11, 2011I am using the below code to disable forms field in fdtlblk.mdt_rqr = 'NO'
but I can go there with mouse click ( for tab and enter it is working fine ) .
but for mouse click it is not working .
if (:fdtlblk.mdt_rqr = 'NO') then
go_item('fdtlblk.section_loss');
set_item_property('FUP_RCVD_DT',enabled,property_false);
[Code]....
Server Administration :: Disabled Triggers And Constraints
Oct 29, 2010What should I do with those disabled CONSTRAINTS (most were those file starts with LOGMNR) & TRIGGERS found on our production dB? Are there any impact once I enable those?
View 2 Replies View RelatedXML DB :: How To Secure Files Stored Where TDE Enabled
Nov 29, 2012I want to secure files that I saved in xml db with TDE, but tablespace encryption(tde) is not supported on the sysaux tablespace.
Is there any way to move the tables where XML DB saves data to another tablespace where TDE is enabled?
XE :: ORA-00439 / Feature Not Enabled / Partitioning In 10g
Dec 3, 2012ORA-00439: feature not enabled: Partitioning...
how to enable partitioning in database....
my version is......
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production.
How To Use Flashback Table
Jun 11, 2012I have used FLASHBACK TABLE option in my oracle 10g database.
It works successfully but the indexes got system generated name after flashback table option.
how i get all the indexes with same name which was before flashback.
SQL & PL/SQL :: ORA-01994 - GRANT Failed / Password File Missing Or Disabled
Apr 5, 2012When I create the orapwd file the sys user is not in the file,The problem started when I tried to grant sysdba privileges to sys
[oracle@bg2mo08i3 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Apr 5 18:47:06 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
SQL> grant sysdba to sys;
grant sysdba to sys
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
SQL> shutdown immediate;
From the postings I read I shutdown the DB and I created a new orapwd file:
$ orapwd file=$ORACLE_HOME/dbs/orapwSID password=password entries=30 force=y
SQL> startup;
Started the DB, verified that the password parameter is set to EXCLUSIVE.
SQL>show parameter password;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL>
SQL> select * from v$pwfile_users;
no rows selected
SQL>
Shouldn't the sys user be listed in the v$pwfile_users?
[oracle@bg2mo08i3 dbs]$ ls -l ora*
-rw-r----- 1 oracle oinstall 1536 Apr 5 18:02 orapwSID
Are these permissions and ownership correct?
I can connect using sys's password: SQL> connect sys/sysPASSWORD as sysdba Connected
ORA-00439 Feature Not Enabled - Bitmap Index
Jul 11, 2012I am using Oracle 10g XE (express edition). If I try to create a bitmap index, I get an error
ORA-00439 feature not enabled: Bit mapped Indexes
How do I solve this problem and create a bitmap index?
Security :: How To Check Audit Enabled For Particular Schema
Jan 11, 2012 how to check that audit is enabled for any particular schema.
The below is my audit parameter from database level:-
SQL>SHOW PARAMETER AUDIT
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /db17/dbdump/xxxx/adump
audit_sys_operations boolean TRUE
audit_syslog_level string
audit_trail string DB_EXTENDED
Security :: Possible To Get List Of Tables On Which Audits Enabled
Apr 19, 2013Is it possible to get a list of tables in a schema on which Audits are enabled.
View 2 Replies View RelatedPL/SQL :: Using Flashback Technology In Application
Oct 5, 2012Can I use flashback in application, especially DBMS_FLASHBACK.TRANSACTION_BACKOUT. I import some information (from files) in my database and after that I want to revert that transaction(delete imported data). I did some test I took xid of the transaction from v$transaction and then executed
DBMS_FLASHBACK.TRANSACTION_BACKOUT
with that XID for parameter. Everything is fine but that time there was only one transaction, when there are many transaction how can I get the exact XID. I can use dbms_transaction.local_transaction_id to get information for transaction which is running. And when i tried to use flashback that way a deadlock occur and db killed the other transaction.
No Flashback For Pluggable Databases?
May 9, 2013I've just found out that 12cR1 will not (in all likelihood) allow "flashback database" for pluggable DBs. Am I the only one disappointed by that ? I use flashback db (+replay) a lot to revert and replay automated tests and I had plans to consolidate tenths of test environments into PDBs.
View 3 Replies View RelatedFlashback Data Archive?
Aug 27, 2012I heard about flaskback data archive. can i get some short example to understand in practical way
View 11 Replies View RelatedFlashback On Specific Tables
May 14, 2013I'am using Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit with the following:
db_flashback_retention_target 1440
undo_management AUTO
undo_retention 900
Is it possible to enable flashback only to some specific tables?
For example, we are only interested in the capability of flashback tables scott.emp and scott.dept, no more.
Process To Refresh Schema In DataGuard Enabled Environment
Feb 21, 2013We have a non-production Oracle 10g Cluster running on Linux, with DataGuard (logical standby). From time to time, we need to refresh the schema on primary, but to do so as always caused problems with the logical standby. Our DBAs can never get it to complete successfully. They have tried a bunch of different methods (even provided from Oracle), but it does not work. e have a bunch of skip statements on the
Everytime, we need to refresh the schema, we have to build the entire database (primary and logical standby) from production RMAN backup. As you can imagine this is a very time consuming ordeal. There has got to be a way this process can be completed in a timely manner.
I was thinking of the following....
1) shut down dataguard, log shipping
2) lock user, kill sessions, drop user from primary
3) lock user, kill sessions, drop user from logical standby
4) run impdb on production export file on primary
5) run impdb on production export file on logical standby
6) re-enable dataguard, log shipping
7) confirm logs being applied, databases in sync
We are only replicating the one schema to the logical standby. I am not clear on how redo logs would be applied to the logical standby. There are hundreds of them @ 100 mb each, so I would think if we do this independently, I could somehow sync primary and logical standby after the imports complete.
SQL & PL/SQL :: How To Append Data Into Macro-enabled Excel File
Aug 18, 2010My requirement is to export Oracle table's data into an already existing excel file with Macros (.xlsm) using a procedure. I am able to write/append the data into the simple .xls file. But I am searching whether any way of appending into .xlsm file. "how can we append the data into a Macro-enabled excel file?".
View 3 Replies View Related