Nope, just regular tables.
Thanks, for all the help so far!!!

I have also noticed that primary keys (upon the alter table move tablespace command ) 'go' with the table. Is there some reason for this? I am trying to separate data and indexes (and perform some cleanup) on the database. Since I am performing this exercise, is it recommended that I use the alter index statement and move primary keys (i.e treat them like a regular index)?

Also any suggestions regarding placement of primary keys (if it is recommended that I move them)??

Thanks in advance,
Nirasha


[Edited by nirasha on 02-13-2001 at 10:34 AM]