Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    6

    Unanswered: Oracle 9i - newbie

    Hi guys,
    This is my first post on this forum. I am a Java developer. Don't have any experince with DB's specially Oracle 9i. I have took course on RDBMS in my engineering but really didn't get it nicely. Well, now I am developing a real life project which involves Database, Oracle 9i. And I am supposed to do every work of DB. My first question is: I have installed Oracle 9i and when I click on "SQL Plus" icon on my dektop, I got this:
    Code:
    SQL*Plus: Release 9.0.1.0.1 - Production on Tue Jul 20 10:09:56 2004
    
    (c) Copyright 2001 Oracle Corporation.  All rights reserved.
    
    
    Connected to:
    Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
    With the Partitioning option
    JServer Release 9.0.1.1.1 - Production
    Currently, I am logging by using
    USER Name: scott
    PASSWORD: tiger

    Well for using Oracle 9i as a BD in real life project, I have to make something like new account. Can anybody tell me how to make new account? I don't want to use scott/tiger account. Please tell me the procedure.

    Bye,
    Viki.

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    This is a minimal script to create a user.
    Code:
    SQL> create user test identified by password
    
    SQL> grant create session, create table, create sequence to test;
    
    Grant succeeded.
    There is an abundance of information availible that describes this procedure in detail.
    Last edited by r123456; 07-20-04 at 05:19.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Jul 2004
    Posts
    6
    Hi,
    Thanks Robert. Can you provide me some good links of tutorial for newbies like me? Which starts from scartch and gradually drives towords advance conecpts.

    Bye,
    Viki.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •