Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2005
    Posts
    73

    Unanswered: oracle basic questions.

    All-

    I have started learning oracle . I have got few questions and if any of you answer it , i will appreciate.

    Orave V: 9 OS: Solaris.

    I have put the db2 answers , if you can place the oracle stuff , i appreciate.

    1) How to list the databases in the systems ( once login).
    DB2: db2 list db directory

    2) How to connect to the database.
    DB2: db2 connect to sample

    3) How to get connection state .Means what is the currently connected database.
    DB2: db2 get connection state.

    4) list database configuration , dbm configuration and db2set .
    DB2: db2 get db cfg for sample , db2 get dbm cfg ,db2set

    5)listing the system tables and application tables.
    DB2: db2 list tables for schema system , db2 list tables for schema GIMR

    6) list tablespace and its usage and used pages.
    DB2: db2 list tablespaces for all

    7) listing the bufferpools .
    DB2: select * from syscat.bufferppols

    8) db2look command for oracle.

    9) listing tablespace containers.
    DB2: db2 list tablespace containers for 3

    10) Oracle side of export , import , load commands.

    11) extracting ddls like table , bufferppools , tablespaces etc
    DB2: db2look command.

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    All that you seek can be found in the sticky at the top of this forum (in particular, the documentation links).
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Mar 2005
    Posts
    73
    CIS-

    I would appreciate ,if you answer the questions, ofcourse if youknow them.
    It would be time consuming to go through all the documentation for commands.
    It is easy for me know the above ones and keep learning as i have exp.with DB2 and SQL Server.

  4. #4
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    I would appreciate ,if you answer the questions, of course if you know them
    I do know the answers. I know them because long ago, when I started learning Oracle, I looked up the questions I didn't know the answer to in the manual - I still read the manual, it's a very interesting read.
    It would be time consuming to go through all the documentation for commands
    It would be time consuming for me to go through each question & answer it for you, when you can just as easily look up the answers.
    What makes you think that I have time to sort out answers for you?
    What if I do condescend to do your work for you & give you the answers but you then have follow-up questions, or want something explaining better? Am I supposed to answer those questions as well? At what point do you think you should RTFM?
    It is easy for me know the above ones and keep learning as i have exp.with DB2 and SQL Server.
    As I said in my first post, all the answers are in the documentation, & are not hard to find. It's easy for you to find out the answers.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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