Skip to Main Content
Forums

SQL & PL/SQL

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!

Cannot create index at creation time for CTAS (CREATE TABLE AS SELECT )

738105Dec 1 2009 — edited Dec 1 2009
Hi all,

I was trying to create a new table from existing tables and also index them along with creation.

I could make it work with MYSQL, with following query:

CREATE TABLE table_indexed (INDEX A_IDX (A_NO), INDEX B_IDX (B_NO), INDEX C_IDX (C_NO))
AS (SELECT * FROM
(SELECT DISTINCT table1.A,table1.B, table3.C
FROM table1, table2, table3
WHERE
<some condition> ) T1);

Could someone help me with a query, which will create a table with data and index them( in Oracle), preferably in both Oracle and MySQL.

Thanks in advance

Comments

Answer
Hi,

This javaw.exe is used to for Java Web start.

If you clearly see in the doc to use use -vm option as javaw under jre/bin folder.

If you dont find them you can use java.exe .

This reference is only for JVM option to use for IDE.

So we can check for the why this javaw.exe is not exists through Oracle support mean while you can use java.exe to run your IDE.

Hope if answers your query.

Regards,
Kal
Marked as Answer by e.geesken · Sep 27 2020
Ganesh..
Hi,
Commonly used launchers for linux is java and that for windows are java or javaw.
It is not mandatory to specify java location in eclipse.ini. Specify the jrockit/bin path in PATH and start the eclipse, it will pick up the jrockit as launcher.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 29 2009
Added on Dec 1 2009
#index, #select, #table
4 comments
2,915 views