DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Help me...

  1. 07-24-2001, 05:28 AM #1
    Mustak
    Mustak is offline Junior Member
    Join Date
    Jul 2001
    Location
    Bangalore
    Posts
    29

    Angry

    Hi,

    I created one database in Oracle. But I am getting so many inbuilt table(s). I have a doubt why so many tables are getting generated by the system. Is it my fault of selection procedure or what? could u please help me. If it so, how to hide the system tables from the view.

    thankx
    mustak
    Reply With Quote Reply With Quote
  2. 07-24-2001, 05:40 AM #2
    Deval
    Deval is offline Junior Member
    Join Date
    Apr 2001
    Posts
    14

    Wink

    hi,

    Oracle builts data dictionary tables to hold info. regarding Database you have created.

    Many of these tables starts with DBA_, USER_ and ALL_.

    ..Deval
    Reply With Quote Reply With Quote
  3. 07-24-2001, 05:59 AM #3
    Mustak
    Mustak is offline Junior Member
    Join Date
    Jul 2001
    Location
    Bangalore
    Posts
    29

    thankx...

    hi,

    But in my case table(s) start with EPC_,SMP_....

    I don't understand what does it mean.


    thankx
    mustak
    Reply With Quote Reply With Quote
  4. 07-24-2001, 06:19 AM #4
    dsuva
    dsuva is offline Member
    Join Date
    Sep 2000
    Location
    Calcutta / Ahmedabad, India
    Posts
    137
    After creating the database what all scripts did you run ?

    initially running the 3 scripts ( sql.bsq , catalog.sql & catproc.sql) after creating the database is enough to solve your basic needs and purpose.

    You can run the different scripts provided under ORACLE_HOME\RDBMS\ADMIN later on as and when required.
    Suvashish
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width