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

Thread: urgent

  1. #1
    Join Date
    May 2002
    Posts
    232

    Arrow

    Heloo friends I am a new database designer,so I am designing database for mobile website,it contains modules like customer registration,services,onlinefriends etc.
    software oracle 9i,sunsolaris.
    so i need to create 3 sql scripts for installation of my data at client place.
    1)tables and index script
    2)export and import
    3)new database for this project.
    any one can give sources or scripts.
    thanks
    kavitha
    kavitha

  2. #2
    Join Date
    Feb 2001
    Posts
    290
    Kavitha,
    If i understand your requirements correctly, you have the DATA and need to load this data in the tables and create indexes on them. And you also need some scripts for the IMPORT/EXPORT of the data.

    And also you need the DATABASE, what do u actually mean by new DATABASE,, is the database is available for you or you need to create one ???

    Would you be more clear of your requirements.. Anyway, for all your requirements, you can look at
    http://metalkink.oracle.com
    or
    tahiti.oracle.com and do a search of your requirements.

    May be they help you best for the time being

    --Reddy

  3. #3
    Join Date
    Dec 2001
    Posts
    221
    i think , u have already created a database at your development site. now you have to create a the same database at your client site and import the full database.

    i think thats all. no script required for creating tables and indexes as import will do it.
    Santosh Jadhav
    8i OCP DBA

  4. #4
    Join Date
    May 2002
    Posts
    232

    newdatabase

    HII reddy thanks for ur reply,
    but present i am creating in 9i scott/tiger.
    I need to create new database in sunsolaris and i will export entire tables and indexes to there.
    thanks
    kavitha
    kavitha

  5. #5
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi kavitha,
    When u say scott/tiger,u hava already created a database.What i understand from you telling is that now u need to import ur data into this database.
    What u need to do is take a complete database export of ur previous database.
    then import that into ur new database.This will make ur new database indentical to ur old database.

    the command to export is

    exp username/password@servicename file= full=yes

    to import

    imp username/password@servicename file== commit=yes ignore=yes full=yes.

    I guess this what u wanted.

    regards
    anandkl
    anandkl

  6. #6
    Join Date
    May 2002
    Posts
    108

    Hi Kavitha,

    You can get numerous DB creation sample scripts.

    But as u say it is for a Site, it ought to be available 24/7.
    U got to decide on various parameters based on the number of expected transactions & Hits etc.,

    Follow link below... it would give u overview of creating a Database.

    http://www.dbasupport.com/oracle/ora...createDB.shtml

    Search the archive for more info.,

    Cheers
    Nandu


    Never give up !

    Nanda Kumar - Vellore

Posting Permissions

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



Click Here to Expand Forum to Full Width