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

Hello expert,
This is bit urgent.
I have table  claims_A with about 10 columns.
There about  2.6 million records in the table.
I have just inserted about 5000 records in the table and just realized there were 18 duplicate records in my insert statement.
so now I have 18 duplicates records  ClaimsA
What I urgently need to do is just delete these  specific 18 duplicate records that I added.
Is there a fast script that can do it?
Mind you there could be many other duplicate records (other than what I added) but I only want to remove the duplicate that I added.
Is there quick way to do this?
Thank you.
al
0
Concerto's Cloud Advisory Services
LVL 5
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Hi,

I tried to change the LOT control of an item by activating PArent and child lot in item master however when tryign to generate parent LOT the fild is still greyed out. I have chrcked and there are no pre exisitng open transaction or reservation for this.
Could you please suggest what could be the reason.

Thanks
0
I can clearly see the file:

[oid bin]$ ls -xl lsn*
-rwxr-xr-x. 1 775 oracle  65053 Jun 30  2014 lsnodes
-rwxr-x--x. 1 775 oracle 155872 Jan 31  2017 lsnrctl
-rwxr-xr-x. 1 775 oracle      0 Jul  6  2015 lsnrctl0

but get this:

[oid bin]$ lsnrctl status
bash: lsnrctl: command not found

I am new to Linux, but executed:
 sudo chown -R 775 /oracle directory name

still no love....

What gives?
0
Hi experts
We're exporting oraclle table content in a fixed record length *.csv file.
SELECT
 'A' || nvl2(field1,rpad(field1,10,' '),lpad('?',144,' '))
 ||  nvl2(field2,rpad(field2,10,' '),lpad('?',40,' '))
 ||  nvl2(code1,rpad(MANDANTENCODE,5,' '),lpad('?',5,' ')) || 'B'
from table1;
The issue is the following, that some records have in field1 or field2 nonprintable characters for example ‎‚¿‘ HEX  BF
the effect is that this according column does not have the expected size.
example correct record
Asämple    sample2   33   B
wrong record where the column field1 is only 9 characters long instead of 10
As¿ple    sample2   33   B

seems that rpad fails with non expected characters

Thanks for a solution
0
experiencing a rash of issues trying to install Oracle client on new 64bit Windows 10 PCs.  We need the 32bit 11g client.  Everything I see at Oracle installs the database as well as the client.

Have never used the instant client, but this installation does not need the appserver, impdp, expdp, etc... Just the basic client to connect tools to the database.  Sql Developer, TOAD, etc.  Non-DBA user

Any and all pointers to the right package, pointers on installation, etc, appreciated.  Have seen notes on visual studio -- is that needed previous to client installation?
0
Hi Expert,

How can i create a table using plsql  procedure where table & column name should be input parameter !!

Thanks in Advance
0
Item Org Creation Navigation: Setup and Maintenance > Manage Item Organization
Now we are going to create an Item Organization
For creating an Item Organization we should select the particular Implementation Project and Type the keyword ‘%item%org%’ and select the Manage Item Organization and select the go to task button highlighted in the image:
To create a new Item Organization, select the create ‘+’ button.
0
Hi,
I get problem like

SP2-0042: unknown command "UNION" - rest of line ignored.
)
*
ERROR at line 412:
ORA-00933: SQL command not properly ended

Open in new window

to attached query. What to adjust?
MMAN0.SQL
0
I just downloaded Oracle.ManagedDataAccess Version(4.122.1.0) via Nuget Package, and I'm developing using Visual Studio 2013, and the project framework is 4.0

Here is the problem I'm having. I'm able to connect to an Oracle database when I provide information like the host, port, and service name. However, I'm not able to connect when I just use the data source name. In other words....

Data Source=MySOURCE;User Id=MyId;Password=MyPass
-The above works with System.Data.OracleClient
-The above does not work with that Oracle.ManagedDataAccess dll.

The only way I can use the Oracle.ManagedDataAccess.dll is if I do something like this...

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myserver@something.com)(PORT=XXXX)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=NameXXX)));User Id=MyId;Password=MyPass


Any way to get around this with the Oracle.ManagedDataAccess dll?

This is the error I get....

Oracle.ManagedDataAccess.Client.OracleException: ORA-12154: TNS:could not resolve the connect
identifier specified ---> OracleInternal.Network.NetworkException: ORA-12154: TNS:could not
resolve the connect identifier specified
0
I am trying create a bulk insert of a csv file into Oracle Sql, I found this code on line, does Oracle allow for Bulk Inserts or is there another way to import data from a csv file?  is there an actual download file for SQL LOADER UTILTIY?

Thanks,

Karen
USE PROD
GO
BULK INSERT ORG_CHART
FROM '\\data\Metrics_Data_Repository\Org Charts Docs\Mgr_OrgChart_Data_kfs.csv'
WITH
  (
  FIELDTERMINATOR = ','
  , ROWTERMINATOR ='\n'
  )
GO

SELECT *
FROM ORG_CHART;

Open in new window

0
Free Tool: SSL Checker
LVL 11
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Hi Expert,

Is there a way in Oracle pl/sql that I can create a data-structure like java Hash-map which can have a record type as value and String as index.

Thanks in Advance
0
UPDATE_structure_code
SET ORGANIZATION = 'IT'+'&'+'DA'
WHERE ORGANIZATION = 'IT$DA';

I am getting error on the set statement - what is the proper syntax to include the ampersand in my text?
0
Hello,

i've just just taken over management of an oracle 10g database and i've noticed there are no backups in place in the event of hardware or operating system failure.

I'm looking for the best way to schedule automatic backups of an oracle 10g database to a remote location.

I'm looking for a complete backup as the database has tables, views, packages, functions and triggers all of which i need backed up.

Preferably i'd need my backup destination to be either a remote server on vlan, a remote ftp server or possibly an AWS S3 bucket.

What would other oracle database administrators suggest?
1
I using the code below and would like to concatenate the C_COMPLETE_REQUEST_RECVD_DT in the following format;
FY YY

Output:

FY 02
FY 14
FY 14
FY 15
FY 15
FY 15
FY 15
FY 15


,Case WHEN EXTRACT(MONTH FROM C_COMPLETE_REQUEST_RECVD_DT) < 10 THEN EXTRACT(YEAR FROM C_COMPLETE_REQUEST_RECVD_DT) ELSE EXTRACT(YEAR FROM C_COMPLETE_REQUEST_RECVD_DT)+1 END AS FY

Open in new window

0
Hello,

I am new to Oracle Express and OLAP. We are currently using Oracle Express 6.3.4 on Oracle 11.2.0.4 Enterprise Edition 64 bit on AIX. We have plans to upgrade Oracle Express to Oracle OLAP as Oracle Express has met end of life and is no longer supported by Oracle.

Although, I saw links describing how to go about this migration/upgrading from Express 6.3 to OLAP in Oracle 10g, need pointers on how to get this done in Oracle 11g. Appreciate any pointers on this. Thanks in advance.

Regards,
Ranjith M V
0
Wel I cannot  export the following  big table and the expdp log is as follow:

;;
Export: Release 12.1.0.1.0 - Production on Tue Jan 16 10:46:02 2018

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
Starting "SYS"."SYS_EXPORT_TABLE_04":  "/******** AS SYSDBA" directory=EXPRMAN dumpfile=dmpSGCIPROD160118.dmp logfile=dmpSGCIPROD160118.log TABLES=SGCEIPROD.GININFORMES CLUSTER=N
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 58.30 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
ORA-31693: Table data object "SGCEIPROD"."GININFORMES" failed to load/unload and is being skipped due to error:
ORA-02354: …
0
In my query, we are using the following code:
spool c:\Work\PS PR Register 2018.csv

Select /*csv*/prd.EMPLOYEE, etc...

The query is working fine, but I wanted to know if there was a way to omit the sql that always shows ups at the beginning of the code? Also, is there a way to remove the column headings as well?
0
I have got an Oracle 11 backup . But it is more than 10 .bck files ( ranging from 9gb to 2 MB .   There is no script. But I have a Oracle database created for a different purpose. How do I raise the oracle backup there ?
0
Oracle Corp has a bunch of really good training videos.  I'm trying to find where these exist, and specifically interested in a "Upgrade from Oracle RAC database 11g to 12c".  Can anyone help me locate video from Oracle Corp?  I know there are a lot utube videos from an array of sources out there, but I am specifically looking for video from Oracle.
0
Free Tool: Port Scanner
LVL 11
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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've installed oracle database 10g express edition on windows 10 & 32bit operating system. But I can't proceed after that. There's shown nothing.
0
Dear Experts,

I need to select all records that contain a string in all tables of the database.
I find quite a few entries on the internet and also in EE, but none "works" for me.

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production.
How can we I get started on that?

Thanks for your help.
W.
0
Hi,

Is there a way to set up a variable that is stored and used again and again in the database (Oracle).  I want to set the financial Year to 2017.  It's used over and over again in stored procedures and views etc...  When it's changed, it should be changed in everything.

Like a global variable but where do you declare it etc...


Kind regards,
Caoimhe
0
HI,

we try to run Mcafee DB scanner to scan for Oracle DB security related issue.

and the permission for the account connect to the Oracle DB is control by this script:

-- necessary to be able to connect to the database
grant create session to &vausername;

-- necessary for DML triggers delay time
grant execute on dbms_lock to &vausername;

-- the following grants is needed for checks:
-- ORACONF353, ORACONF347
create or replace view sys.x_$ksppi as select * from sys.x$ksppi;
create or replace view sys.x_$ksppcv as select * from sys.x$ksppcv;

grant select on sys.x_$ksppi to &vausername;
grant select on sys.x_$ksppcv to &vausername;

-- grant the privileges to be able to read database link passwords
-- and old database passwords stored in user_history$ (optional)
grant select on sys.link$ to &vausername;
grant select on sys.user_history$ to &vausername;
-- required for several CIS benchmark checks
grant execute on sys.dbms_crypto to &vausername;

Open in new window


do you think the above permission allow writing anything to the Oracle DB?
0
I'm looking at revising a 32-bit bitmask operation based on a NUMBER field to 256-bit based on a RAW datatype.

The statement I was using for 32-bit shown below was to determine which bits were switched on compared to a lookup table with varchar(2) values :

bitand(number, power(2,lookup_value)) = power(2,lookup_value)

How would I write something equivalent for the RAW datatype?

UTL_RAW.BIT_AND(raw, (utl_raw.cast_to_raw(lookup_value))) = utl_raw.cast_to_raw(lookup_value)

was my first attempt but that comes up blank.

Any pointers would be appreciated.
0
This is related to earlier question on "How-to-get-output-displaying-as-rows-to-columns".

The query below is using pivot function to display out columns and performing a SUM on interval data.

The pivot function works alright, but the SUMing appears to not work as the values are not adding up correctly.

Query:
WITH opdays as
       ( --
         select opday as opdaystart,                           -- opday is derived from the inner Select query
                (opday + 1) - (1 / 86400) as opdaystop,       -- opdaystop is derived by adding a day and subtract a second from that day
                trunc(to_date('1/1/2010 00:00:00', 'mm/dd/yyyy hh24:mi:ss')) as FirstDayStarttime,    -- gv_firstdaystarttime = TRUNC(p_firstday) where firstday will be parameter passed in from appworx
                trunc(to_date('1/1/2010 00:00:00', 'mm/dd/yyyy hh24:mi:ss')) + 1 - (1 / 86400) as FirstDayStoptime,      -- gv_firstDaystoptime = TRUNC(p_firstday) + 1 - (1 / 86400), add a day and subtract a second from firstday
                trunc(to_date('1/3/2010 00:00:00', 'mm/dd/yyyy hh24:mi:ss')) as LastDayStarttime,      -- gv_lastdaystarttime = TRUNC(p_lastday) where lastday will be parameter passed in from appworx
                trunc(to_date('1/3/2010 00:00:00', 'mm/dd/yyyy hh24:mi:ss')) + 1 - (1 / 86400) as LastDayStoptime         -- gv_lastdaystoptime = TRUNC(p_lastday) + 1 - (1 / 86400), add a day and subtract a second from lastday
         from (--  
                 

Open in new window

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.