Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Update statistics after creation of index

1723552Aug 4 2014 — edited Aug 5 2014

Hi,

Version : 11g

Will oracle update the statistics after creation or modification of index ?

Thanks.

This post has been answered by Zoltan Kecskemethy on Aug 4 2014
Jump to Answer

Comments

Billy Verreynne

SQLCL is a client application. It does not have users and passwords to use.
SQLCL connects to database servers (db instances). The database typically requires a username and password for authentication. SQLCL may prompt for these credentials to supply to the database.
There are no default usernames and passwords to use in today's Oracle database. Most schemas are also locked by default when the database is created.
Ask your DBA for the details of the database and user schema to use.

User_21BG6

i have installed sqlcl-21.3.3.322.1724..but it is asked user name and password in command prompt..please give the solution

Mike Kutz

What database are you trying to connect to?

User_H3J7U

Use /nolog parameter.

thatJeffSmith-Oracle

If you don't know your username and/or password, you need to talk to the person responsible for your database. If you don't know who that is, we can't help you.

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 2 2014
Added on Aug 4 2014
13 comments
93,173 views