Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

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
What does it mean to be "Always On"?
LVL 5
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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
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
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
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
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
Technology Partners: We Want Your Opinion!
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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
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
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
Good Morning Experts,

I'm fairly new to SQL, so please bare with me.  Below is a query I'm attempted to use.  I think I'm missing something minor.  Any suggestions.

SELECT firstname||' '||lastname "USERID", UH.CURRENT_STATE
from User UH,
    (SELECT MAX(EVENT_DATE) AS maxdate, LTRIM(userid)
       FROM SECURITYLOG
       GROUP BY USERID) LastLogin
where UH.userid = LastLogin.userid and
Where UH.current_state = 'ACTIVE';
0
I have a query like this:
 SELECT
                      b.car_details_id,
                      sum(amount) as CGT,
                      wm_concat(to_char(payment_date,'mm/dd/yyyy')) as D_CGT
 from
                  ECAR_CAR_PAYMENT_DETAILS b

It returns an ora error like this:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 13
06502. 00000 -  "PL/SQL: numeric or value error%s"

The payment date usually exceeds the limit of varchar2. Is there a way to truncate it as long as the amount summed up is correct.
0
I am getting the below error when I try to connect throug ODBC.
Ora -12154: TNS:coud not resolve the connect identifier specified Driver's SQLSetConnectAltr failed
0
function B_51FormatTrigger return boolean is
   
  M_REC NUMBER(2);  
  M_AUTH VARCHAR2(10);
begin
M_REC :=0;
IF :invh_cust_code not in ('C00000') then
IF :invH_DT > TO_DATE('31/12/2017','DD/MM/YYYY') THEN
      IF NVL(:CUST_FLEX_07,'0') <> '0'  THEN
            IF NVL(:CS_TAX,-1) <0 THEN
          return (TRUE);
   else
                  return (FALSE);
   end if;
            ELSE
                  RETURN (TRUE);
END IF;
END IF;
else
      return (false);
      end if;
end
0
I have a sql server stored procedure that uses a try catch block and then does a rollback if an error occurs. Can someone show me how to do the same thing in Oracle Syntax?

CREATE OR REPLACE PROCEDURE MYPROC

AS

BEGIN TRY -- Close to top of my stored procedure



END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION


END CATCH
0
Hi Expert,

Happy New year to All !!!

I have a transaction table contains 1 million records . My requirement is meanwhile of transaction i want to filter only few specific record which need to store into another table . Please suggest the possible way with Oracle trigger or any other way .

Please let me know if required any additional info .

Thanks in Advance .
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.

I had this question after viewing Call Oracle Stored Proc from C# that returns RefCursor.

I have a store procedure like this :
PROCEDURE PRC_ABCD_GETALL (resultset_out OUT TYPES.cursorType)
AS
BEGIN
OPEN
resultset_out FOR SELECT * FROM ABCD;
END PRC_ABCD_GETALL;

and this procedure is in package and the package is like this

create or replace
PACKAGE        V4_EVT_PKG_ABCD_GENERAL
AS

   PROCEDURE PRC_ABCD_GETALL (resultset_out OUT TYPES.cursorType);

END V4_EVT_PKG_ABCD_GENERAL;

and the oracle data provider was system.data.oracleClient and I used this code
public static IEnumerable<PortalList> GetAll()
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand objComm = db.GetStoredProcCommand("package_name.sp", new object[1]);          
var result = new List<PortalList>();        
using (IDataReader rdr = db.ExecuteReader(objComm)){            
while (rdr.Read()){                  
result.Add(Construct(rdr));              
}          
}        
return result;
}
and now i found out that system.data.oracleClient is depricated and i want to use Oracle.DataAccess.Client as data provider
I wrote C# code for this but I am facing some errors like wrong number or types of arguments in call to 'PRC_ABCD_GETALL'
in this function PortalListRepository.GetAll();

private static IEnumerable<PortalList> GetAll(bool …
0
I have added a POST Built-in inside the code before Commit operation in Oracle Forms  11g, When i tries to Save Application get hanged and took nearly 5 minutes to proceed. This is because of  a POST Built-in inside the Code in  Oracle Forms.Kindly Assist.
0
Hi,

I have installed oracle instant client in c drive and oracle full client in d drive.I have updated the environmental variables path with d drive oracle client.

Now i dont need instant client in C drive,I need help in cleaning oracle instant client in C drive.Crystal reports should only look for D drive oracle client using OLE DB.

Thanks,
Vikram
0
I need to display output of CLOB type data which is stored in the Text (Table) type format. I can show Text (Table) type data of format Varchar using Pivot but getting error when I am using the same pivot to show CLOB type data. Isn't is possible to that?
0
Hi Experts,

I have created a database 11.2.0.4 in Linux machine and is up and running. Able to ping the database but not able to connect it remotely.

With sys I am able to connect it. But not allowing remotely. Any clue?
Getting below when trying to connect remotely.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
0
My question involves not only Oracle but Sql server and Sybase. I am wondering if there is a way to monitor database changes so to prevent catastrophic events so to speak in the database. By catastrophic events, below are some examples.
The reason I am asking this is that on my job I work with about 6 different databases. two are Oracle, two are Sybase and two are Sql server. I need to somehow monitor any catastrophic changes to the database. Is there a way to do that? I have an application that accesses the databases and of course the application will crash if certain catastrophic events occur. But sometimes running the application is not enough, so to somehow monitor any database changes would be great.


- Deletion of linked servers
- Deletion of user accounts
- Deletions from key tables
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.