hi everyone,

I am working on moving tables from one tablespace to another on an nt machine. I would like to use the import/export option. How do I start this utility on NT?. what kinds of things must I keep in mind when doing this.

1. Export table mode, select tables I want, compress = N.
exp xxx/xxx tables=(xxx,yyy,zzz) rows=Y file=export.dmp
2. Alter user default tablespace to new tablespace, grant quota on that tb space. (IS this needed)
3. Import those table rows =Y, commit = Y
imp xxx/xxx tables=9xxx,yyy,zzz) rows=Y file=import.dmp

Any more steps, Does the syntax look correct.

thanks as always,