Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Indexfile Question
you can also connect to the other schema by
alter session set current_schem=username;
you do not have the know the username's password;
hope it helps
"Chevron Oracle Dude" <gwlu_at_chevron.com> wrote in message
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 - 17:08:06 CST