Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Indexfile Question

Re: Indexfile Question

From: charlie cs <cs3526_at_ureach.com>
Date: Mon, 16 Dec 2002 23:08:06 GMT
Message-ID: <q1tL9.27743$_S2.25413@nwrddc01.gnilink.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US