running a script in unix

[dorothy]

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

[vinodkmg]

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.

[dorothy]

Thanks
what if I do not have internal priviledges but I have SYS, SYSTEM & DBA priviledges?

[marist89]

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.)