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!

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

Recent content by masiwan

  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!
See more

Part and Inventory Search

Back
Top