Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

Oracle Database

78K

Solutions

25K

Contributors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Share tech news, updates, or what's on your mind.

Sign up to Post

Experts on Flashback and recyclebin needed here. We're having to do capacity planning.  When I query dba_recyclebin I see 102 rows of stuff from various schemas.
What effect, if any, does recyclebin contents have on datafile size?  We do not have any OS  data files physically located  in the flash recovery area that has been configured.  Flash recovery is configured, but turned off.  What is the relation between recyclebin and flash recovery if any?  I want to purge the recyclebin to recoup space, but I'm not sure that it will. How can I tell whether the stuff in recyclebin is needed?

$ cd flash_recovery_area
$ ls -la
total 8
drwxrwxr-x+ 2 oracle dba 4096 Feb 28  2012 .
drwxr-xr-x  8 oracle dba 4096 Oct 16  2016 ..
$ pwd
/u04/flash_recovery_area
$


SQL> show parameter db_recovery_file_dest;

NAME                                 TYPE                                         VALUE
------------------------------------ -------------------------------------------- ------------------------------
db_recovery_file_dest                string                                       /u04/flash_recovery_area
db_recovery_file_dest_size           big integer                                  2G
SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------------------------------------------------------------
NO

SQL> select value from v$parameter where name = 'recyclebin';

VALUE
0
Nothing ever in the clear!
LVL 1
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

I am trying the below in apex ldap authentication

LDAP Host : ldap.xxx.com
Port : 389
Use SSL : No SSL
Use Exact Distinguished Name (DN) : Yes
Distinguished Name (DN) String (Value Required) : %LDAP_USER%
LDAP Username Edit Function : return replace(substr(:USERNAME,1,instr(:USERNAME,'@')-1),'.','_')

The same I am using in plsql as below, and no issues.

l_retval := DBMS_LDAP.search_s(ld => l_session,
base => l_ldap_base,
scope => DBMS_LDAP.SCOPE_SUBTREE,
filter =>'cn='||replace(substr(i.u,1,instr(i.u,'@')-1),'.','_')||'',
--filter => 'uid=ADRIVER',
attrs => l_attrs,
attronly => 0,
res => l_message);

Problem is when I use LDAP for authentication in APEX, I am getting the subject error
0
Issue we faced :
 Recently one of our production team member was rainsing move order and he picked quarantine Lot and moved it to production. As there we no restrictions it passed through all phases.
 One challenge is for that particular product we do not have a specific quarantine location assingned in oracle so far .

 Quest: Do you think adding  virtual quarantine location will restrict the movement? Is there a way to stop it being picked in move order or is there a way to flag in move order that it is  quarantine item ?

We are using oracle e business suite r 12.

Thanks
0
Hi
i have new Desktop , windows 10 - 64 bit
dint have any oracle product installed
only i have connection path to the oracle server of the company
the question is :
what is the requirement to connect MS Access to Oracle Database Via ODBC
IS IT REQUIRED TO INSTALL local Oracle database on my desktop
0
How can I restrict move order so quarantine item is not moved to production
0
I am in process of adding new item status to existing one. What all key fields , transactions I need to check and consider before making any chnages.

Thanks
0
My select date is 04-Sep-2017 then 8 weeks future date should display

Style , Dept,Class,Subclass,04-Sep-17      11-Sep-17      18-Sep-17      25-Sep-17      02-Oct-17      09-Oct-17      16-Oct-17      23-Oct-17      
                                                                                          
                                                                                          
                                                                                          
Note:  Have to use only SQL query from Oracle database.
0
Hello,
I have multiple tables with insert, update. When one of table inert or update failed don't want to save the data in all table.
Means Transaction should be either completely  successful or it may failed. How to incorporate this in form.
I have to use rollback in form procedure or any other option.

thank you
0
Hi,

My compnay has agreed to sponsor Oracle training in supply chain management as we are using oracle e business suite  R12 version for our supply chain.

However it will not be a full subject training but have been asked to identify key topics to cover due to budget restrain.

Would be great if someonce can suggest what I should opt for to get maximum out of this training. (Mine is healthcare company ).

Some in mind are Material Master Data, BOM, Planning, work orders .

May thanks
Meenu
0
In oracle form 10g,I have implement one task,I have to read text file and extract the useful data like name DOB CRN no etc and display it on form,i have to create LOV of CRN no which is present only in text file,
,if we choose CRN no then form should display information related to that CRN

My thought on it
1)create procedure to read file and extract data put it on temp table
2)used that temp table in oracle from to create LOV and display information
Can you please suggest me on this? is there any other way to do that
Thank you
0
Get your Disaster Recovery as a Service basics
LVL 1
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

hi i have upgrade the liabrary from 6i to 11g the foolowing code work in 6i but when i compile in 11g is giving error check attachment
erro0987.jpg
tpapi1Bdy.txt
tpapi1Spec.txt
0
I am trying to add new link server to oracle db in SSMS. I've installed oracle client 12c 64 bit.
I can connect to the oracle db via SQL developer when I enter the tnsnames directory but not mgt studio, when adding a new linked server. This confirms all service names passwords and firewall rules, content of tnsname.ora are correct. I get "ORA-12154 tns could not resolve the connect identifier specified" immediately so its not finding the tnsnames.ora file.

So I have also checked the following:
I have amended the provider options to allow inprocess.

My tnanames.ora and sqlnet.ora files are in c:\oracle\product\12.2.0\client_1\network\admin\

I have names.directory_path= (Tnsnames) in my sqlnet.ora file.

If I do a tnsping tnsentry it uses the above sqlnet.ora as parameter file bit I get
tns-03505: failed to resolve name error

Ive check the path in environment variables. In regedit, the path of Inprocserver32 of the oracle clsid is c:\oracle\product\12.2.0\client_1\bin\oraOlEDB12.dll

Ive restarted SQL services.

How can I get SQL mgt studio to point.to my tnsnames file.?  Is there anywhere in regedit that tells SQL of the file location
0
Hi,
we have a planned maintenance for our production environment (WINDOWS SERVER 2008 R2) scheduled in a weeks time from the time of this post. Windows cluster is configured for two nodes on an ACTIVE/PASSIVE basis. Going by the company planned maintenance policies all nodes are expected to be shutdown . Oracle database 11gR2 is running on the primary node. Kindly advise on the best procedure to shutdown and startup the cluster after maintenance is completed.

Also do i shutdown the database manually through the 'SHUTDOWN IMMEDIATE' command?

Kind regards.
0
Ours is pharma products and expiration date is imp. but on one particular batch no expiration date was picked. What can be the reason?

Earliest response would be grateful.

I am using oracle e business suite R12 vversion.

Thanks
minzee
0
i have data file like this

gender
-------
---------------------F--------------------------
--------------M--------------------------------
F----------------------------------------------
-----------------------------M--------------------
---------------------F--------------------------
--------------M--------------------------------
F----------------------------------------------
-----------------------------M--------------------

now, i want to load the data like

Gender
-----------
F
M
F
M
F
M
F
M

like this by using sql loder control file

any one help me plsee
0
Where to define product lifecycle phases in oracle e business suite R 12
0
Hi,
How do I create a unique constraint against 2 columns and nulls included
I found it before but can't remember the syntax..

      alter table "DB_BASIC_PARM_USE" add constraint
      "DB_BASIC_PARM_USE_CON" unique ("PROJECT_ID",nvl(MY_NUM,-1))
      /  
I want
insert into mytable project_id 1, my_num 2  --- inserted successfully
insert into mytable project_id 1, my_num 2 should cause constraint violation
insert into mytable project_id 1, my_num null  --- inserted successfully ALLOWS ONLY ONE NULL COMBINATION
insert into mytable project_id 1, my_num null should FAIL cause constraint violation
insert into mytable project_id 1, my_num 3  --- inserted successfully
insert into mytable project_id 1, my_num 4  --- inserted successfully
insert into mytable project_id 1, my_num null should FAIL cause constraint violation
insert into mytable project_id 2, my_num null  --- inserted successfully ALLOWS ONLY ONE NULL COMBINATION

thank you,
Bill
0
We are trying to connect to an older Oracle 8i database from SQL 2014 64 bit  running on Windows 2012 64 bit. We were able to connect from a 32 bit sql 2005 server. I do not have the 10g 64 bit client which i believe i need.   Questions are , what can i do to connect the database ? is there some other files i need? is there a 10g 64 bit client anywhere ? Oracle does not have them on there public site.
0
We had oracle licenses for our environment
And we run through upgrade project so we had change the component used within the environment
We need to decide what license should we have and which we should release
New env is oracle rac db two nodes
Weblogic and forms and reports +ohs installed on two nodes
Works async
0
Important Lessons on Recovering from Petya
LVL 10
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

How do i disable all DB links in oracle database .
can you show with example . I am using SQl developer tool
0
I had this question after viewing ODBC in excel 2016 in Windows 10 via VBA.

Any of you find the solution, please hep what was it?

Many thanks
0
i have developed small application in oracle 10g forms 6i .it's working rightly but i want to acess that application from another client pc which reside on different network how it can be done .
plz help me.
0
i have 2 tables like

T1                       T2
-----                     ----

id  name              id  name                            
---  -------               ---- -------

10  xyz
20  abc

in this the first tabe (T1) id column data type is number

and second column(T2) id column data type is varchar2

Now,

I want to insert data from table T1 to T2

how can i insert
0
hello,
i am working on oracle 6i forms.i have a form named as ''add_inventory_item" now what i want is to store data through this form into database by using barcode scanner. how it can be possible?
please guide me,thanks in advance.
0
Hello Experts,

I have a view which is created based on a sql. Now I am trying to convert the same VIEW to materialized view.
Now using the same SQL I am getting the below error :

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1

 Lines highlighted are :
     a.Fieldwork_Complete_Actual,
          CASE
            WHEN TRUNC (DAY_DATE) = TRUNC (LAST_DAY (SYSDATE))
             THEN
                'CURRENT'
             ELSE
                'HISTORY'
          END
             F_DATA_TYPE
     FROM (SELECT A.*,

Open in new window



And the SQL has 3 views where column "DAY_DATE" is used and the data type is date.
0

Oracle Database

78K

Solutions

25K

Contributors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.