I've never really done it before but it is my understanding you have to include
the id of the field you want to index.
Example:
Form:test
Index {
Id:2
Id:7
Clause: TABLESPACE INDX
}
Index {
Id:4
Clause: TABLESPACE INDX
}
Thanks,
Sean
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Fatima
Sent: Monday, June 07, 2010 5:28 AM
To: [email protected]
Subject: Saving indexes on different tablespace
**
Hi Everyone,
I updated the ardb.conf to save any indexes created on this form to a different
Tablespace as follows:
Form:test <----- this is the name of the form
Index {
Clause:TABLESPACE INDX <--- this is the name of the tablespace to save the
indexes on
}
After updating the ardb.conf and saving it, I created a new index from the
Admin tool, but it got created on the default tablespace.
What am I doing wrong?
I tested to create an index on that same tablespace directly from Oracle with
the application username and it worked, I also tested to add a clause to the
CREATE TABLE statement as follows:
Form:test
Clause:TABLESPACE INDX
and it worked it created the new table on this tablespace.
We are running:
ARS 6.3
Solaris 10
Oracle 9.2.0.7
Is there any known bugs in dealing with ardb.conf with these ars and/or Oracle
versions?
Appreciate your help.
Regards,
Fatima Mahdi
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
