Results 1 to 9 of 9

Thread: script files

  1. #1
    Join Date
    Feb 2009
    Posts
    36

    Question Unanswered: script files

    hello everyone...
    can anybody tell me how to create script files in oracle 9i..???
    thanks in advance.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >can anybody tell me how to create script files in oracle 9i..???
    vi or editor of choice.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Code:
    c:\MyScripts>copy con my_oracle_script.sql
    SELECT 42 FROM dual;
    ^Z
            1 file(s) copied.
    c:\MyScripts>

  4. #4
    Join Date
    Feb 2009
    Posts
    36

    script file

    thanks alot for ur great help...
    i have to ask that what should be the content of my script file....
    i have design a database mgmt system.i have table and data stored on one computer.now i want to make that database portable.i have little bit idea of script file...
    script file should contain table structures with respective relations with other table.
    is there any sequence of tables in script file??
    is there any neceesary code to be written in script file..??
    script file should be stored as .sql file.
    whatever little information i had,u share with u.
    so can u help me further??
    thanks for ur help

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    If you are going to move the whole schema, perhaps Import and Export utilities might be a better choice (than SQL scripts). Because, if you are going to create tables one by one, sequentially in a file, you'll - for example - have to take care about foreign key constraints (which will fail if the parent table doesn't exist). Import / Export will, on the other hand, take care about all these "problems".

  6. #6
    Join Date
    Feb 2009
    Posts
    36
    thanks littlefoot
    but i have no idea about how to import and export the file as i m new to this field.any guidance from ur side will be a great help.

  7. #7
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    This is Oracle 9i Utilities documentation; you'll find both Export and Import in there (as well as other utilities; although you probably won't use them now, you'll at least have an idea what they are).

  8. #8
    Join Date
    Feb 2009
    Posts
    36

    Talking

    hi littlefoot
    thanks alot for ur help.

  9. #9
    Join Date
    Feb 2009
    Posts
    36
    is there any other way to find out the solution of the problem disccussed above???

Posting Permissions

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