Oracle Database

78K

Solutions

104

Articles & Videos

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

16/08/2015 16:00:47:720000---> convert this to date to timestamp format.please help me out.
0
Free Tool: IP Lookup
LVL 9
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I need to create a primary key (number type) for a table that previously did not have one and then number the fields starting at 1.  Can somebody give me the ALTER STATEMENT sql code to to this?
0
Informatica Client Installation issue on windows --- >

Registry Key : HKEY_LOCAL_MACHINE\SOFTWARE\Informatica 9.0.1\Client
Value Name : PC_CLIENT_HOME
Data : C:\Informatica_Client\clients\PowerCenterClient\client
Configuring files
=================
C:\Informatica_Client\clients\PowerCenterClient\client\custom-configurator\customwizard.bat
C:\Informatica_Client\clients\PowerCenterClient\client\custom-configurator\customwizard.properties
C:\Informatica_Client\clients\PowerCenterClient\CommandLineUtilities\MM\mmcmd\mmcmd.bat
C:\Informatica_Client\clients\PowerCenterClient\CommandLineUtilities\MM\mmBackupUtil\backupCmdLine.bat
Installing o2003pia.msi
=================================

Command Executed
----------------
"C:\Windows\SysWOW64\msiexec.exe" /i "C:\OBIEE_Software\Informatica_client\V26112-01_1of2\901HF2_Client_Installer_win32-x86_DOCS_KEY\901HF2\source\clients\PowerCenterClient\visio\Office2003PIA\o2003pia.msi" /qn

Output of execution
-------------------
Output :
C:\Users\Administrator\AppData\Local\Temp\17\I1498234176\Windows>"C:\Windows\SysWOW64\msiexec.exe" /i "C:\OBIEE_Software\Informatica_client\V26112-01_1of2\901HF2_Client_Installer_win32-x86_DOCS_KEY\901HF2\source\clients\PowerCenterClient\visio\Office2003PIA\o2003pia.msi" /qn


The system cannot be open the specified device or file specified


Create Shortcut:          C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Informatica 9.0.1\Client\PowerCenter Client\PowerCenter Mapping…
0
Hello Experts

This file chk_fs.log came to weigh almost 1GB, I see that only saves this information:

PL / SQL procedure successfully completed.


PL / SQL procedure successfully completed.

The problem is that I do not have disk space, what can I do?
chk_fs.log
0
Hi ,

SQL> /

COMP_ID    COMP_NAME                      VERSION                        STATUS
---------- ------------------------------ ------------------------------ --------------------------------------------
DV         Oracle Database Vault          11.2.0.3.0                     INVALID
OLS        Oracle Label Security          11.2.0.3.0                     VALID
XDB        Oracle XML Database            11.2.0.3.0                     VALID
OWM        Oracle Workspace Manager       11.2.0.3.0                     VALID
CATALOG    Oracle Database Catalog Views  11.2.0.3.0                     VALID
CATPROC    Oracle Database Packages and T 11.2.0.3.0                     VALID
           ypes


How do i make my vault component to valid state . I tried with multiple options .

OS - Solaris

Thanks,
VInay Palaparthy
0
Good Afternoon, I would like to get some assistance with something I'm trying to do. I have a query that queries a table and gets various project information from that table, and it works fine. I have another table that has many comments about each project, so I have a one to many situation. My problem is that all UI want to retrieve from that second table is the last comment entered. I store the date of the last comment so I thought I would be able to do some sort of retrieval with a max date but not sure how to go about it. Ultimately I'm building a spreadsheet so the query is being built to populate the spreadsheet. Everything works fine till I had the 'proj_reason_closed' field. That the field that has many entries for each project.

SELECT DISTINCT proj_no,
spl,
capces_location,
capces_state,
capces_description,
maxdate,
proj_closed_reason,
ob_date_sort

FROM  (SELECT DISTINCT

       current_bulk_filter.proj_no,
       current_bulk_filter.capces_location,
       current_bulk_filter.capces_description,
       current_bulk_filter.capces_state,
       current_bulk_filter.spl,
       capces_support_data.ob_date_sort,
       spend_plan_history.proj_closed_reason,
       x2.maxdate

      FROM   mca.current_bulk_filter

left join mca.spend_plan_history
        ON ( current_bulk_filter.proj_no = spend_plan_history.proj_no and
             )

WHERE ......
0
Hello All,

I wrote small query where select query will fetch the status of one ORder . If the order status is not 1 it will update the status to another status. If not found it will handle the exception.
I am made one script.In the comment can you help in recitfiying the script asap. Need this script in this format only.



DECLARE
       
        v_REFERENCE_CODE varchar2(30);
        v_status_lkp varchar2(30);
        cursor ObsoleteSalesOrder is
               select a.REFERENCE_CODE,a.status_lkp from BASE_SALES_ORDER a,BASE_SALES_ORDER_LINE b where
                    a.SALES_ORDER_ID =b.SALES_ORDER_ID
                    and a.REFERENCE_CODE ='10132834';
       
BEGIN
open ObsoleteSalesOrder;
loop
fetch ObsoleteSalesOrder into v_REFERENCE_CODE,v_status_lkp;
exit when ObsoleteSalesOrder%notfound;
loop
if v_status_lkp !=1

--Do Below update
update base_sales_order set obsolete_flag = 1 where reference_code IN ('10132834');
update base_sales_order_line set obsolete_flag = 1 where sales_order_id
IN (select sales_order_id from base_sales_order where reference_code IN ('10132834'));
commit;
DBMS_OUTPUT.PUT_LINE('SalesOrder MArked it obsolete');

else if v_status = 1
DBMS_OUTPUT.PUT_LINE('SalesOrder is in obsolete');

else
DBMS_OUTPUT.PUT_LINE ('No sales ORder Found');

--Exception handling
end loop;
--Exception handling
else
end loop;
--Exception Handling
close ObsoleteSalesOrder;            
end;
/
0
hi i got the following report where i add two column to summary the total of two column
1 after i edit the report am now geting more page than original report
2 the report is showing wrong total
beforeedit.jpg
afteredit.jpg
0
pdate ra_customer_trx_all tr1
set interface_header_attribute3= (select unique asg.delivery_id
from ra_customer_trx_lines_all ral, wsh_delivery_details det, wsh_delivery_assignments asg
where ral.interface_line_context='ORDER ENTRY' and ral.interface_line_attribute2='US Delivery Order Type'
and ral.interface_line_attribute3='0' and ral.interface_line_attribute6 is not null
and det.source_line_id=ral.interface_line_attribute6
and det.delivery_detail_id=asg.delivery_detail_id
and tr1.customer_trx_id= ral.customer_trx_id
)
where customer_trx_id in(SELECT unique ral.customer_trx_id
  FROM ra_customer_trx_lines_all ral,
       wsh_delivery_details      det,
       wsh_delivery_assignments  asg
 WHERE     ral.interface_line_context = 'ORDER ENTRY'
       AND ral.interface_line_attribute2 = 'US Delivery Order Type'
       AND ral.interface_line_attribute3 = '0'
       AND ral.interface_line_attribute6 IS NOT NULL
       AND det.source_line_id = ral.interface_line_attribute6
       AND det.delivery_detail_id = asg.delivery_detail_id)
and org_id= 151;  


this update is not working
single row subquerry returns more than 1 row
0
Hello All,

I am in a situation to push database audit XML logs to syslog server. Audit logs are getting generated when Audit_Trail is set to OS. The same is not happening when Audit_Trail is set to XML,EXTENDED. Please advice on this.

SQL> select banner from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production


SQL> show parameter audit
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /u01/appldrch/DRCH_DB_audit_lo
                                                 g
audit_sys_operations                 boolean     TRUE
audit_syslog_level                   string      LOCAL1
audit_trail                          string      XML, EXTENDED

[root@appsdr ~]# cat /etc/syslog.conf
local1.warning /var/log/audit.log


Thank You.

regards,
John Marshal.A
0
Free Tool: Path Explorer
LVL 9
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Hi,
I have .rep file in 10 G. is there is any converter available to convert it to .rdf.
Or any other option to open .rep file using oracle 10g report builder
0
Hi expert,
my Oracle version is 12.1 and during Oracle import datapump I get the folowing error:

. . imported "SYS"."NACL$_IMP"                        0 KB       0 rows
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MARKER
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PROCACT_INSTANCE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
ORA-39083: Object type TABLE:"RAD_OWN"."TAB_RAD" failed to create with error:
ORA-01882: timezone region not found
Failing sql is:
CREATE TABLE "RAD_OWN"."TAB_RAD" ("RADAC" NUMBER(*,0) NOT NULL ENABLE, "ACCTSESSI" VARCHAR2(64 BYTE) NOT NULL ENABLE, "ACCTUN" VARCHAR2(32 BYTE), "USERNAME" VARCHAR2(64 BYTE) NOT NULL ENABLE, "GROUPNAME" VARCHAR2(32 BYTE), "REALM" VARCHAR2(30 BYTE), "NASIPADDRESS" VARCHAR2(15 BYTE) NOT NULL ENABLE, "NASPORTID" VARCHAR2(15 BYTE),
ORA-39083: Object type TABLE:"PPB"."TRIP_ERR" failed to create with error:
ORA-00922: missing or invalid option
Failing sql is:
CREATE TABLE "PPB"."TRIP_ERR" ("ID" NUMBER(19,0) NOT NULL ENABLE, "VEHICLE_ID" NUMBER(10,0), "MESSAGE_TYPE" VARCHAR2(500 BYTE), "TRIPPOINT_START_TRIGGER" NUMBER(19,0), "TRIPPOINT_STOP_TRIGGER" NUMBER(19,0), "PACKET_ID" NUMBER(19,0), "INSERTTIMESTAMP" DATE NOT NULL ENABLE, "ANALYSYS_RESULT" VARCHAR2(500 BYTE), "ANALYSYS_T
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "PPUB"."TB_P"      64.19 GB 771212642 rows


How do I fix this error and be able to import the .dmp file …
0
I am doing CSV upload on Asp.net and its taking more than 1 hour to upload, So I has set sessiontimeout as 2 hour, I have set time out in below places:
1) In web.config :<sessionState timeout="120"></sessionState>
2) In web.config: <httpRuntime maxRequestLength="1048576" executionTimeout="7200" />
3) In .aspx page :     <asp:ScriptManager ID="scrpt1" runat="server" AsyncPostBackTimeout="7200">
                            </asp:ScriptManager>
4) In IIS: Application Pool have sesstion timeout as 120min
5) In IIS: In Website Advance setting set session timeout as 120 min.

   Still my page get blank after 1 hour and If i try to refresh then it shows Session Timeout, However my CSV Upload continue to work on database and it completes all upload in database in 2hour but Page get expired. Please help asap.

   FYI I am using IIS 7 on Windows server 2008 machine.

Regards,
Sudhanshu
0
Microsoft provides a development SQL server that can run on your laptop or PC for developers to work against. I can put a Northwind database on such for example, and devise queries against it. I am looking for similar tools that I can do so for these database formats, if there is such an animal...

DB2
Oracle
SAP
AS400
0
I have 2 tables
table 1

NAME        CHANGE_NAME
----------       -----------------
AVINASH    ABINASH
SAHU          SAHOO
ALIBHA       ALIVA
BAPUN       NULL
RAZA          RAJA
BAPU         BABU

table2

UPDATE_NAME(primary key)
----------------------
AVINASH
SAHU
ALIBHA
BAPUN
RAZA
BAPU

and i want to update the table2 and the o/p will be
table2

UPDATE_NAME
---------
ABINASH
SAHOO
ALIVA
BAPUN
RAJA
BABU
what will be the SQL query??

Thanks in Advance
0
Hi I have created .Net datatables and inserted around 10,000 rows into that, What I am looking is inserting that datatable values
in to Oracle Table directly. I am doing this to improve speed because If i insert data row by row from CSV to Oracle table then It takes 3hours to insert. Please help for correct solutions.
0
Hii expert...
I have 3 table having same no of column  and different data set including nulls .

I want to  copy all the 3 table data into a new table which also having same no of columns, please share some demo code .

Thanks in advance
0
I am able to find last refresh time from dba_mviews, but how or from where I will get the next refresh time info of each materialized views ?
0
From Windows10 client, I received the error “ORA-12638: Credential retrieval failed” when I was trying to establish a connection to Oracle12c database using Oracle12c sqlplus. The error occur only when the attempt login, Windows account, is not under the same domain as the database.

On Windows7 client, ORA-12638 error NEVER occurs, whether the client and server domains are the same or different.

 Configuration:
    - SQLNET.AUTHENTICATION_SERVICES is set to NTS
    - Oracle Home user is Local System.

 Environment (64-bit):
    - Oracle Client 12.1.0.2 running on Windows 10 Enterprise version  
    - Oracle Database EE 12.1.0.2 running on Windows Server 2012 R2 Standard version

From SQLNet client trace file, Kerberos authentication returned an error in InitializeSecurityContext as shown below.

naun5authent: SPP is KERBEROS 
naun5authent: SSPI: 0x80090342 error in InitializeSecurityContext 
naun5authent: exit 
naunauthent: exit 
nau_ccn: get credentials function failed 
nau_ccn: failed with error 12638 

Open in new window

I can connect without the error by changing SQLNET.AUTHENTICATION_SERVICES to NONE.  However, this workaround is not feasible per my security policy.

Question:
    1)  Do you have any suggestion/solution on the “SSPI: 0x80090342 error in InitializeSecurityContext” ?
    2)  Is there any difference between Windows 7 and Windows 10 regarding Kerberos authentication ?
0
On Demand Webinar - Networking for the Cloud Era
LVL 9
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Hello Experts,

I have some servers where almost 80% of RAM has been allocated for SGA resulting in swapping. As far as I am concerned, we can either get more memory or reduce SGA. First choice is easy. However, I want to see what the actual SGA consumption history. For example, I have a server which got 12 GB RAM and 10GB SGA. How can I check how much of the 10GB SGA is actually being used or the usage history over a month.

I tried looking on net and found a query someone posted but I am not sure it is actually telling me the consumption. Can anyone please tell me how we can get actual SGA consumption history?

<<Truncated output for readability>>
select sn.INSTANCE_NUMBER, sga.allo sga, pga.allo pga,(sga.allo+pga.allo) tot,
  2  trunc(SN.END_INTERVAL_TIME,'mi') time
  3    from
  4  (select snap_id,INSTANCE_NUMBER,round(sum(bytes)/1024/1024/1024,3) allo
  5     from DBA_HIST_SGASTAT
  6    group by snap_id,INSTANCE_NUMBER) sga
  7  ,(select snap_id,INSTANCE_NUMBER,round(sum(value)/1024/1024/1024,3) allo
  8      from DBA_HIST_PGASTAT where name = 'total PGA allocated'
  9     group by snap_id,INSTANCE_NUMBER) pga
, dba_hist_snapshot sn
where sn.snap_id=sga.snap_id
 10   11   12    and sn.INSTANCE_NUMBER=sga.INSTANCE_NUMBER
  and sn.snap_id=pga.snap_id
 13   14    and sn.INSTANCE_NUMBER=pga.INSTANCE_NUMBER
 15  order by sn.snap_id desc, sn.INSTANCE_NUMBER
 16  ;

INSTANCE_NUMBER        SGA        PGA        TOT TIME
--------------- ---------- ---------- 

Open in new window

0
We have a local oracle database 12c.

Another remote system (mysql/java) needs to post a record of data each time a transaction is executed by a user to our local database.

The way it will work is the remote system will call a web service in local database (https) and submits data using CSV format.

Can CSV format support web services and one to many table relationships?

My thinking is that it is fixed-size format and difficult to parse of you have one customre order with multiple line items or none.

Most of the web service I developed were using XML format before.
0
could not able to recover database block , which is having corruption type is NOLOGGING
0
I want to export Oracle table to CSV through some scheduler automatically. Is it possible? If Yes then Please let me know.
0
Hi ,

In my application, I'm fetching a date field and want to convert to DD-MM-YYYY format and write to a file.
I tried using TO_CHAR('date field','DD-MM-YYYY')-     but display as 'DD/MM/YYYY' instead of 'DD-MM-YYYY'
when I tried with TO_CHAR(TO_DATE(date field,'DD-MM-YYYY'),'DD-MM-YYYY') - display as 'DD-MM-00YY' (showing '00' for the 1st two digits in the year) ex: 13-06-0017

Appreciate your help on this.

Thanks!
0
I am learning Angular, Node, npm, deployd, mongodb, etc.  I am making my way through a book titled "Pro AngularJS" by Adam Freeman.

on page 120 I am attempting to prepare the data for a "real world" application called "sportsstore".

I was instructed to install a module called "deployd" which apparently is used for modelling  API's for web applications.

I did that and when I try to start start the "deployd" service I get an error:

C:\PROGRA~2\deployd>dpd -p 5500 sportsstore\app.dpd --mongod
starting deployd v0.8.9...
internal/child_process.js:289
  var err = this._handle.spawn(options);
                         ^

TypeError: Bad argument
    at TypeError (native)
    at ChildProcess.spawn (internal/child_process.js:289:26)
    at exports.spawn (child_process.js:380:9)
    at Object.exports.restart (C:\Users\knowlton\AppData\Roaming\npm\node_modules\deployd\lib\util\mongod.js:38:14)
    at Command.start (C:\Users\knowlton\AppData\Roaming\npm\node_modules\deployd\bin\dpd:149:16)
    at Command.listener (C:\Users\knowlton\AppData\Roaming\npm\node_modules\deployd\node_modules\commander\index.js:301:8)
    at emitOne (events.js:96:13)
    at Command.emit (events.js:188:7)
    at Command.parseArgs (C:\Users\knowlton\AppData\Roaming\npm\node_modules\deployd\node_modules\commander\index.js:617:12)
    at Command.parse (C:\Users\knowlton\AppData\Roaming\npm\node_modules\deployd\node_modules\commander\index.js:458:21)
    at Object.<anonymous> 

Open in new window

0

Oracle Database

78K

Solutions

104

Articles & Videos

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.