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
Why not use 'create table as select' well I am very new to this and I have read that you don't get everything, so I would have to rebuild Indexes, triggers, constraints? More than I know how to do right now.
'just use ALTER statement'. I have read several things about corrupt indexes after using this command. I also tried it and it wouldn't work, keep saying can't perform two operations at once?
So I figured export/import would be the best for a novice like me, right now.
Again, does anyone know how to use/start the export utility on NT, I am mostly experienced with UNIX.
just a fellow like you
ok! now about your thing
just go to command pmt.type this
C:\>exp80 (return key)
it will ask you for everytihng it needs.
try make your own file.
For import than.
c:\>imp80 (return key)
and it will give you every thing.
keep in mind if a guy with dba privs made the expfile only someone with same or higher privs can read from it.