Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I create an Index File from a database?
Hi Ashesh,
If I am interpreting your requirement correctly you are trying to export the index from one Oracle database and then importing it into another Oracle database. I am not 100% certain, but I think the only way you can create indexes are:
Export and then import the table.
Write a CREATE INDEX statement.
Define a table with a (PRIMARY) KEY.
From your request I gather that exporting and then importing is not an acceptable solution. Writing a CREATE INDEX statement is, IMHO, a better solution than defining keys as part of the table definition since it gives you the opportunity of controlling where the index is placed and the number and size of the index extents.
Regards
Jerry
ashesh48_at_my-dejanews.com wrote:
>
> I am trying to create just an INDEX file to use them for another database as
> the requirement. I tried the IMPORT/EXPORT way it mess up the whole system.
> IS there any another way for that?
>
> Thanks in advance for your help.
> Ashesh.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
--
Jerry Gitomer ICT Group jgitomer_at_ictgroup.com Langhorne PA jgitomer_at_yahoo.com Opinions are mine not those of ICT GroupReceived on Tue May 26 1998 - 11:05:00 CDT