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

Thread: running a script in unix

  1. #1
    Join Date
    Oct 2000
    Posts
    90

    Arrow

    Hi everybody,
    I am new to unix so I need some help in running a script that I have generated to create a tablespace.
    Ok, this is the directory or file in which I saved the script:

    /dorothystuff/orascript/cretablspc/nebraska/Idaho_potato.log


    So how do I go about it? Please be specific with you answer. An example will be highly appreciated

    thanks,
    dorothy

  2. #2
    Join Date
    Aug 2000
    Posts
    87

    hi,
    If u want to create the tablespaces by the script u have created then

    At svrmgrl>connect internal

    svrmgrl>@/dorothystuff/orascript/cretablspc/nebraska/Idaho_potato.log

    or else

    svrmgrl>sta /dorothystuff/orascript/cretablspc/nebraska/Idaho_potato.log


    Cheers,
    Vinod Kumar.


  3. #3
    Join Date
    Oct 2000
    Posts
    90
    Thanks
    what if I do not have internal priviledges but I have SYS, SYSTEM & DBA priviledges?

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Note: You can also run the same commands through sqlplus.

    Who you create the objects as depends on how your script is written. If you have specified the schema name in the create table statement then you can run as either system or as a user that has DBA role.

    For example:
    create table scott.product (prod_id number(10));

    will create a table in the user SCOTT's schema and will be owned by him. This command can be run either as system or as a user that has DBA role.

    In contrast:
    create table product(prod_id number(10));

    will create a table in the current users schema named product. If this is run as system, the object will be owned by system. (BTW, usually not a good thing.)

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