> Do I have to know
> the password for every schema(userid)?
You don't necessarily do. If you are DBA (or have sufficient privileges) you
can create objects on behalf of another user.
Just long on as SYSTEM and run the script (each command in the script should
have explicit reference to the owner as in
CREATE INDEX OWNER.INDEXNAME ....)
--
Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
To reply to myself directly, remove zulu from my address
"Chevron Oracle Dude" <gwlu_at_chevron.com> a écrit dans le message de news:
43b16c07.0212160826.6bcc862a_at_posting.google.com...
> I did an import with indexfile=<filename> to obtain the index creation
> statements. Then I preformed the import with indexes=n to create the
> tables and load the data without creating the indexes. My question now
> is, how do I run the indexfile. It seems to connect with each schema
> name and then create the indexes for that schema. Do I have to know
> the password for every schema(userid)?
Received on Mon Dec 16 2002 - 12:13:31 CST
