-
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
-
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.
-
Thanks
what if I do not have internal priviledges but I have SYS, SYSTEM & DBA priviledges?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|