OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » indexes

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

indexes [message #264523]

Mon, 03 September 2007 11:35

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello All,

Can I create an index on two tables at a single time, like

SQL> create index idx on emp(ename,empno),dept(deptno,dname) .

I have tried the above one , but error came.

kindly let me know.

Regards,

Raj

Report message to a moderator

Re: indexes [message #264524 is a reply to message #264523]

Mon, 03 September 2007 11:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Can I create an index on two tables at a single time
NO

Report message to a moderator

Re: indexes [message #264526 is a reply to message #264524]

Mon, 03 September 2007 11:41

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Thank you SIR

Report message to a moderator

Previous Topic:	how to populate owa_util.ident_arr and dbms_sql.varchar2_table (merged)
Next Topic:	Help Needed with a subquery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 12:55:16 CST 2024