Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: masiwan
  • Order by date
  1. masiwan

    Security Issues

    Which previlages must I have to allocate table spaces, create other users etc. And How can I log on in order for me top allocate these privalages to my self. I happen to be the System Administrator, and I installed this Oracle by myself. I had two Users SYS and SYSTEM for which oracle asked me...
  2. masiwan

    ORA_01536:Space Quota exceeded for tablespace 'USERS'

    I get this error when I try to put a primary key to my table. How can I resolve this error ?. The table was created long ago but now I want to use one of the columns as a primary key, so I open the table design, use the Constraints tab to define my primary nkey, when I click on the Apply button...
  3. masiwan

    tracing procedures

    What tracing/Debugging tool isavailable for oracle procedures? I have written a simple procedure usin PL/SQL and I want to trace it so that I can see the source of errors.
  4. masiwan

    debugging procedure in jdeveloper

    How can I trace a procedure in jdeveloper. I'm using jdeveloper to connect to my oracle database, the procedure opens but the step into, step over etc are disabled when i click the debug option I cant go beyond the name of my procedure
  5. masiwan

    equivale PL/SQL for simple expression

    In an SQL Transact SQL, one can write the following line: select @cnt = Count(*) from employee so that variable @cnt can be used to store the total number of records from the Employee table, and use it else where in your procedure; I have tried; cnt = Count(*) from Employee in...
  6. masiwan

    tracing Procedure in jdeveloper

    I'm sorry I would have asked this in the Oracle jdeveloper forum but it seems this forum is not ver active!. How can I trace a procedure in jdeveloper. I'm using jdeveloper to connect to my oracle database, the procedure opens but the step into, step over etc are disabled when i click the debug...
  7. masiwan

    ORA-01779: cannot modify a column which maps to a non key-preserved...

    Tom I'll admit I'm new to Oracle, I had the very same problem for a view which could update fine in SQL Server, but It could not update in Oracle.What I did to implement the update was to make both tables each have a primary key!
  8. masiwan

    Logging on ORACLE MANAGEMENT SERVER(OMS)

    I want to perform a simple back up and when I click the Back up otion in Enterprise Console, The System requires me to log onto Oracle Management Server.I can try to log onto OMS but I don't know the neccessary Username and Passwords. I'm the one who installed this oracle so I have no one else...
  9. masiwan

    truncate table command fails

    thanx William it has compiled let me see if it does what I want I will update U.Uganda greets U
  10. masiwan

    truncate table command fails

    It has not helped however I have another question How do you log on to Oracle Management Server, I'm trying to learn how to back up and I'm told I must log on to (OMS) what Parameters /credantials do I have to use?
  11. masiwan

    truncate table command fails

    as cursor recs is SELECT class, stream from CLASSSTREAM; recs3 recS%ROWTYPE; begin TRUNCATE TABLE CLASSSTREAMTABLE; Insert Into CLASSSTREAMTABLE (class, stream, outof) Select class, stream, outof From classstream Where class = 'S1' or class = 'S2'...
  12. masiwan

    truncate table command fails

    I have written a procudure where I want to use the truncate table command, in order to permanently delete records from a table; using SQL*PLUS the command executes well but inside the procedure oracle does not even compile and flags the following error: Line # = 16 Column # = 14 Error Text =...
  13. masiwan

    Using a view to update data

    I Have created a view which simply sorts reocrds within a table,and I want toopen this view to edit/enter values in the table but my view cant allow me what I'm I missing?. I'm new to Oracle but SQL server was doing it.
  14. masiwan

    SQL*Plus Worksheet option causes computer to shut down

    When I try to run the SQL*Plus work sheet option the computer will ask for user name password and service name, when I enter these values and click OK the System appears as if it going to connect but instead causes System Shut down what could be the problem?
  15. masiwan

    Displaying data in data sheet view on an Oracle form

    Is there a way we can display data in datasheet view using Oracle forms 6i, many records(even up to 10.000) like in the case of Microsoft access project when front ending with SQL Server?. What I see is just a way of having say 100 records on a form and the way of creating them is so cumbersome!
  16. masiwan

    failure to access Database from Enterprise Manager console

    After successifully connecting to my Oracle database through Oracle forms 6i I now can no longer access it from Enterprise Manager console.What could be the cause. I can see it but when I try to access it the message is:ORA-12154:TNS:could not resolve service name. In fact the usual Host: Port...
  17. masiwan

    ORA-12154:TNS:could not resolve service name

    How can I resolve this error as I try to connect to Oracle 9i database using Oracle forms 6i. I'm using Windows Xp.
  18. masiwan

    Connecting to Oracle 9i database using Oracle forms 6i

    I already have oracle 9i on my machine and I have just installed Oracle forms 6i. I already have a database in oravcle 9i with schemas and procedures. And I connect fine through my Enterprise Manager Console with my user name and password I would like to create the client using Oracle forms...
  19. masiwan

    Connecting to Oracle 9i database using Oracle forms 6i

    I already have oracle 9i on my machine and I have just installed Oracle forms 6i. I already have a database in oravcle 9i with schemas and procedures. And I connect fine through my Enterprise Manager Console with my user name and password I would like to create the client using Oracle forms...
  20. masiwan

    I want to down load Oracle Forms and REports

    Where can I down load Oracle Forms and Reoprts any upo todate version, in small files. The site I got was installing every thing in about twelve hours and every timemy Internet was disconnecting at about 20% and if I re connect I have lost every thing and mus start afresh Oooops!

Part and Inventory Search

Back
Top