1
  • Store image from a directory into Oracle database using SQL

    I have a directory containing 1000s of photos which I have to upload into Oracle 9i DB. I need to use only SQL plus for this. I want a simple material to upload all those photos.

    cmuraz5 pointsBadges:
  • iSQLPlus creating packages with multiple procedures in it

    Hi, I am a bit stuck i need to create a package which has a number of different procedures in it. The procedures work on their own however whenever i try to put them into a package they then don't work and i get the error package created with complication errors, however when i type show errors...

    Cazza8855 pointsBadges:
  • Running SQL PLUS on a server

    Can I use mapped drives and environment variables to run SQLPLUS from a local machine(without any Oracle products) to a server. The mapped server has the Oracle products? Example: W - map to my Oracle server C drive EV = w:oracleora92binsqlplusw cmd : start %EV% I'm trying to host out of Oracle...

    Lynrobbins5 pointsBadges:
  • Copy Table in SQLPLUS

    How to copy a table from an access database using sqlplus

    VB and Access5 pointsBadges:
  • How do I find the timestamp associated with HWM of processes/sessions in Oracle 10g on AIX

    The following SQL produces a very useful report of current resource utilization at the time of the query and the HWM since the database was started. What SQL can I add to list the time of the HWM? Database & ‘OS = Oracle 10.2.0.4 running on AIX 5.3.0.0 5300-09 64-bit. Thanks, Bruce col...

    Csybjf15 pointsBadges:
  • How to implement oracle single sign-on with a legacy application

    I have set up a user for external authentication in the database. I am able to login to the oracle database sqlplus /@dbname and it uses my windows account. But when I try to login to the application I get an error of a null password. Are there any other applications/tools that are necessary to...

    Fostdolyn15 pointsBadges:
  • Error when using SQL*Plus @@ command in SQL Navigator

    When I try to use the @@ SQL*Plus command in a script I get the message "ORA-00936: missing exppression!" when it reaches the line containing this command. I read the help and they say that the @@ command is admitted. I've tried the same script in Oracle Enterprise Manager...

    Imre5 pointsBadges:
  • Get the following error when logging into SQLPlus – ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist

    When i try to log into Oracle SQL*Plus i get the following error ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist I'm using Oracle 10g Personal Edition Also getting the following error when trying to connect to an oracle database via VS2008 ORA-12514: TNS:listener does...

    Oracle20005 pointsBadges:
  • ProC under Oracle 10g

    Hi! I have a piece of code in Pro-C that's been running under Oracle 9i for several years. I recently compiled it using the ProC of Oracle 10g and the code complied without any problems. However, when I run it on an Oralce 10g database, queries that returned thousands of records in 9i return empty...

    Ilank10 pointsBadges:
  • ORA-03113: end-of-file on communication channel

    I am running a database health report which consists of many SQLs against the data dictionary. Every SQL returns fine except one querying for chained/ migrated rows which takes a little more time, and I get the following: ERROR at line 1: ORA-03113: end-of-file on communication channel I am running...

    OracleATE190 pointsBadges:
  • Oracle Enterprise Manager login password error

    We have windows 2003 server and we are running 2 oracle databases in version 11g. We were successfully configured EM for one database and when we were tried for the other database we encountered configuration errors and we were able to sort by searching on "google", solution was "ocijdbc10 file has...

    PKSDBA5 pointsBadges:
  • Oracle 10g Instance not starting Up

    Oracle 10g startup command from SQL Plus gives the following error: ORA-01034 : ORacle not available ORA-27101: shared memory realm does not exist

    Raj66615 pointsBadges:
  • SQL Plus

    I have a subquery that works but I need to change some parameters. Specifically 2 fields in a different table. When I do, using aliases, it stops working, "Invalid Identifier". The first select gets all the fields from 2 tables then the subquery uses the 2nd table. Table B has some fields as well...

    Gator255 pointsBadges:
  • ORA-1034: Oracle is not available error with SQL Plus

    I had installed Oracle 9i in Windows XP Professional Edition. Whenever I start SQL plus(GUI) it says, ORA-1034 error, "Oracle is not available, Shared memory realm does not exist" In the services I saw that an associate database service is running. Thank you.

    OracleATE190 pointsBadges:
  • Is there a config file to set sqlplus default to GMT?

    Need help please. I need to set sqlplus to default to GMT instead of local timezone. Is there a way to do this? TIA, slee72890

    Slee728905 pointsBadges:
  • sql quries

    i m a beginer in computer science.so how can i make grip on oracle sql plus is there any website or any electronic book that contains preset quries on sql which can help me in working in sql i want a guide book which has quries to start and work in sql plus and developer.

    Yasir oracle5 pointsBadges:
  • copy files

    Using SQLPLUS how do you copy files from one location to another

    Ga800715 pointsBadges:
  • Embedded SQL in a Cobol program using a sub-select in the select clause

    The following works fine in SQLPLUS: SELECT SOVLCUR_PIDM INTO :STDN-PIDM FROM SOVLCUR WHERE SOVLCUR_PIDM = :HOLD-STU-PIDM AND SOVLCUR_LEVL_CODE = 'UG' AND SOVLCUR_LMOD_CODE = SB_CURRICULUM_STR.F_LEARNER AND SOVLCUR_CURRENT_IND = 'Y' SSRMEET_ROOM_CODE FROM SSBSECT, SSRMEET, SGRSPRT WHERE...

    Warpmail5 pointsBadges:
  • oar-01033

    ORA-01033 and from I understand from reading posts..i'm to log in as sys/password as sysdba. When I do this, sqlplus is returning the error message: ORA -01031 Insufficient privileges. I've tried several different usernames...but SYS should work as i've used this many many times in the past "as...

    Maitreya5 pointsBadges:
  • Subquery?

    I used to think I was good with sql as I have used it for quite a few years with informix, but now I am trying to create an sqlplus with oracle and some things are not working the same. I have 3 tables. customer general customer detail location I have used a join to list all the required customer...

    MizzGail85 pointsBadges:
1

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