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 wOOdy-Soft 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 vrudenko

  1. vrudenko

    Automating Web reports

    Tanks a lot!
  2. vrudenko

    Automating Web reports

    I need make my Web reports run automatically in some time. Is it possible to create a script or some thing else and schedule running it? Thank you in advance
  3. vrudenko

    Oracle 8i&9i client on the same PC

    Thank you Turkbear!
  4. vrudenko

    Oracle 8i&9i client on the same PC

    Hi, I have Oracle 8.1.7 client on my PC (Windows 2000) and need also to install Oracle 9i client. Is it OK? Any conflicts can happen? Thank you in advance.
  5. vrudenko

    Create database

    Hi, I need DBA's help. I tried to create database by using a script. I prepared init.ora file, created and run service and run SQLPlus and than tried to startup an instance: SQL>startup nomount pfile="my_init_ora" I got an error ORA-27100: shared memory realm already exists Please...
  6. vrudenko

    Hi i have a very basic knowledge

    Hi MARCUS, I don't know how to catch cursor from Java but I can give you an example doing it in SQLPlus. First the cursor variable should be declared in a package to be a global one. CREATE OR REPLACE PACKAGE REF_CURSOR_TYPE AS TYPE RCT IS REF CURSOR; END REF_CURSOR_TYPE; CREATE OR...
  7. vrudenko

    CREATE TABLE STATEMENT

    Thank you Sem
  8. vrudenko

    UNIQUE CONSTRAINT

    Thank you sem!
  9. vrudenko

    CREATE TABLE STATEMENT

    Hi, I read from Metalink forum this syntax of CREATE TABLE statement: CREATE TABLE PR_DESC ( PR_DESC_ID NUMBER(10) CONSTRAINT PR_DESC_PK PRIMARY KEY USING INDEX (CREATE INDEX PR_DESC_PK_IDX ON PR_DESC (PR_DESC_ID) TABLESPACE INDX STORAGE ( INITIAL 128K NEXT 128K PCTINCREASE 0 ))...
  10. vrudenko

    UNIQUE CONSTRAINT

    Hi, Please answer me if a column can have UNIQUE and NOT NULL constraints together. Do not interfere Primary key constraint on another column with UNIQUE and NOT NULL constraints on this column then? Thanks in advance
  11. vrudenko

    Form's trigger

    Thank you!
  12. vrudenko

    TEMP TABLESPACE IS HUGE AND FULL

    Thank you for helping. But, I beg you to guide me further because I'm not DBA and my company doesn't have DBA. How can I drop segments and resize datafile? What are the steps and statements? Thank you very much in advance
  13. vrudenko

    TEMP TABLESPACE IS HUGE AND FULL

    Hi, I faced the problem with the Temp tablespace (Oracle 8.1.7, Windows NT4). It's very huge and full. Please give me some advise to clean it and decrease it's size. Thank you
  14. vrudenko

    Hi All, I am going to pass Oracl

    Hi All, I am going to pass Oracle Developer certificate exams: 1.Developer 2000 Build FormsI (1Z0-121), 2. Build Internet ApplicationsII (1Z0-132). Help me please to find the best books and documentation to prepare. Tnanks in advance
  15. vrudenko

    ORA-06502 Error

    I really appreciate all!!! Now it works. I used function arguments in the function body. After assigning them into local variables, the stored procedure executed correctly. But, I can't understand why it worked with restricted number of rows.
See more

Part and Inventory Search

Back
Top