Im using oracle forms 10g. i want to take backup of user's table.
i.e, scott user has 4 tables. if i login as scott user and select the tables what i have to take backup using check box and click a backup button,the selected tables backup and stored in .MDB(MS Access).
I have build a sw containing 20 forms & 35 reports. I have created users table.
Now I want to assign different rights to different users like update, view , update, print, delete etc etc. Enable disable add/delete/update buttons on basis of user rights.
I am trying to write an update statement which updates the User IDs in one table with the User IDs in another table. However I need to update statement to ignore any duplicates that are in the tables.
I need to populate records from a child table when the user clicks on a record in the header table..The difficulty is that the user needs to be able to edit a field from the child table and there could be 1 to many records. When the user makes a change , I don't want the 'do you want to save changes' error to appear..
the user will only be able to update field 'amt'.When the user clicks on 'declaration_no' from the header table,other records will be displayed. URL.....
- we have user id parameter.can we update the parameter(:parameter.p_userid) before firing "WHEN NEW FORM INSTANCE TRIGGER"(when new form instance trigger contain code for tree node), for login another canvas as per user rights?
- i have created a login form in one canvas.
- also tree node Hierarchy form created on another canvas. now we want to login through login screen, after login only those forms should show in tree Hierarchy which users have rights. for this purpose we want to pass the parameter of userid before connecting to tree node form through the following query
SELECT COUNT (*) INTO v_count FROM usersinfo WHERE usersname = :USERBLOCK.usernames AND passwords = :USERBLOCK.passwords ;
[code]...
Every thing is working but when we click on button in login form at that time parameter.p_userid will return null. because above code is define on button click in login screen, i cannot understand where i need to define the above code .
I have migrated my database to oracle and while migration i have followed all instructions and migrated to oracle.the connection and user having my tables and all object is
con name: orcltestcon user: orcltestuser and password: orcltestuser.
I want to turn on ARCHIVELOG Mode ON.
1) Is it good practice to turn on archivelog. also tel me cases where it is good. 2) to turn on ARCHIVELOG , with which command i should connect.
1) CONNECT SYS/<password> AS SYSDBA; or 2) CONNECT orcltestuser/orcletestuser AS SYSDBA.
On production server i have the production database and i have another instance for recovery catalog database.and on DR server i have only one instance for production database .In the scenario of recovery,
- i did export for recovery catalog user - i have latest rman backup for production database
On the DR server as i mention up , i have only on instance , my question is , i need to create another instance for recovery catalog user to import it ? or on the same target database on DR i can import the recovery catalog ?
I am trying to take backup of the user tstcvs of cvmdb database but it fails due to some reason [oracle@cvs ~]$ exp
Export: Release 10.2.0.1.0 - Production on Tue Jan 3 12:37:06 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Username: sys/sysdba@cvsdbm as sysdba
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options Enter array fetch buffer size: 4096 >
Export file: expdat.dmp > 3-1-12-tstcvs
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 2
Export grants (yes/no): yes >
Export table data (yes/no): yes >
Compress extents (yes/no): yes >
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion)
About to export specified users ... User to be exported: (RETURN to quit) > tstcvs
User to be exported: (RETURN to quit) >
. exporting pre-schema procedural objects and actions . exporting foreign function library names for user TSTCVS . exporting PUBLIC type synonyms . exporting private type synonyms
I am not able to take backup of table which is partitioned.Whenever i start the backup it was hanging with wait event "asynch descriptor resize", so I tried to create another table using original table ( like create table BASE_TABLE AS SELECT * FROM BASE_TABLE), but it is also hanging with same wait event.
I stumbled about some weird 11gR2 behavior (running on AIX).When I performed a join between a table with user based content (parts belonging to an sourcing scope) and a base table (parts available) whereas the parts have to fulfill a special regular expression, it showed that the same query is faster when using outer join than inner join (about 0.7sec vs. 20sec; which makes me believe that regexp_like works wrong when involved in an inner join).
i tried the same statement with a standard like (but not fulfilling the same condition).This time performance was as expected (inner join outperforming outer join).
Oracle version information Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production PL/SQL Release 11.2.0.2.0 - Production CORE 11.2.0.2.0 Production TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 - Production [code]...
I can see it, the execution plan for the "inner join" doesn't show so much more costs than the one for the outer (but why at all is does an inner join cost more?) ...The execution plan for both "not like" is the same and (surprisingly ;-) ) similar to "outer-regexp".
I hope sample data are not needed as there would be needed a lot...this is the second time I came across the "plan worse but execution time better" phenomenon.
I am using pay user tables to store the balance values.
Example:
IF rec.balance_name = 'Gross Earnings' THEN l_gross := bal_function(g_assg_id,rec.balance_name,'_ASG_GRE_YTD',p_effct_date); END IF;
from the above I should not hardcode ('Gross Earnings ) value, so I placed this value in pay user table that can be changed by different clients. how do i refer user table values for the right earnings/net/overtime pay values that can be placed in user table.
How to Insert all user names into a table from sql for example when i use select * from all_users command it displays all user names i want that how we transfer these user names into a table.
I have an issue on selecting data from a nested table owned by other user.
I have given select access on stc_irb_usr.stc_loy_settlebillpay_map_main to anthr user adminofs.
But when I try to query, it says insufficient privileges. adminofs is able to select other columns which are not nested.
I have given "grant execute on STC_IRB_USR.STC_BILLPAY_MAP_TAB_TYPE to adminofs;" but it did not
select * from stc_irb_usr.stc_loy_settlebillpay_map_main where rownum<3;
ERROR: OCI-21700: object does not exist or is marked for delete
SQL> desc stc_irb_usr.stc_loy_settlebillpay_map_main Name Null? Type ----------------------------------------- -------- ---------------------------- BATCH_NUM NOT NULL NUMBER ACCOUNT_NUM NOT NULL VARCHAR2(40) PAY_BILL_SEQ_MAP STC_IRB_USR.STC_BILLPAY_MAP_
[Code]....
Name Null? Type ----------------------------------------- -------- ---------------------------- ALLOCATING_CREDIT_SEQ NUMBER ALLOCATION_ENTITY_SEQ NUMBER ALLOCATING_CREDIT_DATE DATE ALLOCATING_CREDIT_TYPE VARCHAR2(20) ALLOCATION_ENTITY_DATE DATE
the above query is giving the value of current QTD(on the basis of V_REPORT_DATE)..I need to integrate the same as user want the output as table type and he can also give some filter conditions.
That is I have created the User Defined Data Type as following. CREATE OR REPLACE TYPE Bit_Type AS OBJECT(Bit NUMBER(1,0));
After completing this creation of new UDT, I am trying to create the table with this UDT as follows, CREATE OR REPLACE TABLE Sample_Bit ( RegID Bit_Type);
I received an Error Message like: SQL Error: ORA-22913: must specify table name for nested table column or attribute 22913. 00000 - "must specify table name for nested table column or attribute" *Cause: The storage clause is not specified for a nested table column or attribute. *Action: Specify the nested table storage clause for the nested table column or attribute.
a table structure is modified every now and then because of which the few packages get uncompiled. is there any way to monitor which user has changed table structure.