• Is it safe and ‘recommend​ed’ to reclaim/sh​rink Oracle/sys​admin volumes in DOT 7 mode?

    We have created several flexvolumes such as 1 flex volume contains 1 qtree. these volumes are created in the similar way for oracle and Sys Admin's e.g oracle volume - /vol/oratla_data/oratla_data Sys Admin Volume - /vol/traces/traces These volumes are fully allocated volumes (not thin-provisioned)...

    curi0usV5 pointsBadges:
  • How to grow career as a CRM consultant

    Hi, I have started my career as a Oracle CRM consultant, currently working in sales cloud. I really want to know how is the market for CRM consultants and what courses or technologies would help in growing my career in CRM? Thanks Shweta

    shwetadixit95 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • Can we handle unstructured data with Oracle Enterprise Data Quality

    Is it possible to handle the unstructured data like videos or images in OEDQ?

    maddymk5 pointsBadges:
  • Fuzzy Oracle text string search

    When searching a string I need to fetch all the words present in the database from that string. e.g. " Today is very hot day", if I am having (Today/very/very hot/day/etc..) in my database, so this should fetch all the related results to that string.

    shubhanshusriv5 pointsBadges:
  • RAC patching: How to force sessions to connect to other node

    Hi experts, I have one query regarding applying a patch (interim,psu) in a 4 node RAC in rolling fashion. My question is while applying patch on one node I heard that we should down the instance and we will apply remaining nodes are up and running. At that time what happens about the running...

    sirajdba175 pointsBadges:
  • Help using oracle Analytical function.

    I am trying to create a query that will do two parallel select from the data available. I want to write one select statement using analytical functions, What I want to do is as follows: I one single query I want to find out the count of the transactions in the last 7 days from sysdate and last 6...

    Prativa0 pointsBadges:
  • Create a trigger to call a procedure

    HI, I am trying to create a trigger where is checks for a condition every time an insert or delete happens on the table and then calls a procedure. Any help is appreciated.PROCEDURE: ============ CREATE OR REPLACE PROCEDURE "GFMPNRT"."PP_CLEANUP_ALERTS_FOR_POC" (v_ACTION_LEVEL_KEY IN VARCHAR2,...

    Nagesh198540 pointsBadges:
  • Block SSH Authentication on Linux

    Scenario: We have multiple user in production server like Oracle, DatabaseUser.Concern: Because of a security concern, we don't want Oracle & DatabaseUser User to get SSH authentication. Who can we stop only specific user from SSH authentication? Is there any configuration change I need to make...

    NitinIND200 pointsBadges:
  • Running Oracle 10g form

    I can't get a form to run through the browser on my machine. I can compile ok, but when I run the form I get the "cant display page" error in IE. I have the listener running. What am I missing?

    Tdmcolumbus75 pointsBadges:
  • Receiving SQL error message: ORA-01722

    In Oracle / SQL, I keep getting an error message when I'm trying to an insert. Here's the message: ORA-01722: Invalid number error. What does that mean? What can I do about it? INSERT INTO CUSTOMER VALUES (1,'Michael','Claire','27 Smith St Caulfield','0419 853 694'); INSERT INTO CUSTOMER VALUES...

    ITKE392,540 pointsBadges:
  • How to get unique values from column without using Distinct keyword in Oracle?

    I have a table in which the column has duplicate values in it. If i need to get unique value from that column without using distinct keyword then what will be the query?

    Sheeldk5 pointsBadges:
  • Extract data from dmp-file without Oracle

    I need to extract data from a large ORACLE dmp-file (many users, many tables). My idea is to get in TXT or CSV. However, NXTract could not manage this because of the size (buffer overflow error). Is there any other tool out there that can help me...?

    ITKE392,540 pointsBadges:
  • Hedvig SDS (Software Defined)

    Hi All, tell me please what is your opinion about hedvig and can it replace really storage like EMC VNX and others? Our company is thinking of hedvig and wanted to know technically if it is worthy to deploy it and remove EMC storage, SAN environment. We use Oracle EBS Oracle Business Suite and with...

    Alzebdeh120 pointsBadges:
  • running oracle form

    Isave the form without space in directory name, I then compile it successfull. When I run the browser displays "ORACLE FORMS." what can I do to get it done? Please help me

    RAHIMSAID5 pointsBadges:
  • How to run Oracle 10g forms on browser

    Hello everyone, When I run form browser, it shows only Oracle forms. Please help me solve my problem.

    Scarletsys5 pointsBadges:
  • How to retrieve last record from given table without using rows function in Oracle

    I don't use rows function like row_num, rowid, rownumber. How can I do this in Oracle?

    Swatirupnar11808199210 pointsBadges:
  • How to insert a column values from one table to another without having common columns

    Hi i have a created a table with one additional column from another table.create table myemp as select EMP_ID, FIRST_NAME, LAST_NAME,cast(null as number(10)) as "CAST_ID", EMAIL ,PHONE_NUMBER, HIRE_DATE, JOB_ID ,SALARY ,COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ,C_ID, GENDER, AGE from...

    Dinesh13935 pointsBadges:
  • Oracle: Update two columns from other table having max date

    Here's what I have so far: UPDATE table2 SET (DATE, ENTRAMNT) = (SELECT MAX ( DATE), (B.ENTRAMNT) FROM TABLE1 B WHERE B.ACCTNUMR =TABLE1. ACCTNUMR WHERE EXISTS (SELECT * FROM TABLE1 B WHERE B.ACCTNUMR = TABLE1.ACCTNUMR) This does not work.

    235235235250 pointsBadges:
  • Which one is better to start career: Oracle DB or SAP Basis?

    Hi, this is shiva. Recently I got a job in a MNC company. I have a choice to choose domain Oracle DB or SAP Basis for 3 months training. Basically my background is Non IT. So little confusion which one to accept to start career as a beginner and better for future. I hope I will get answers as soon...

    singamsiva19935 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following