Export and Import in Oracle

JDE List,

I am preparing to Export all of my OneWorld tables, change the location of
all the tables across my disk drives, then re-import.

Will this keep all of my access rights, userid, etc.? I can't afford for
OneWorld to not be accessible after I finish the import. I have 1 day in
which to "pull this off".

Please advise,

James A. Wilson

OW Xe / Win2000 / Oracle 8i
Citrix
FAT Clients
JAS

Hello, James,
As I understand you are going to move your Oracle data from one disk to
another (because of space issue or whatever).
If it is correct the task doesn't interfere with JD Edwards and OneWorld. It
is "internal Oracle affair". Practically you have to move your data files.
You can use on of two ways
1. With alter tablespace command
2. With alter database command
3. Export/Import

In first case:
1. Shut down the database
2. Move the datafiles with OS command
3. Mount the database.
4. Execute the alter database rename file command. (Example alter database
rename file 'C:\oradata\jde.ora' to 'D:\oradata\jde.ora'
5. Open the database

Second case:
1. Take the tablespace offline
2. Move/Copy the files
3. Execute the Alter tablespace rename datafile command
4. Bring the tablespace online
5. Delete the old file if it was copied.

Third case:
1. Make an export file
2. Nuke all tables and tablespaces
3. Create new tablespaces in new location
4. Import
It is the longest way, but it descrease defragmentation. I would use first
or second, but it is up to you.


DON'T FORGET point #0 - make a backup!

Hope it helps.

Regards, Alex Shevchenko

XE SP18 Oracle 8.1.7, Solaris production
XE SP18 Oracle 8.1.7, Solaris test

Please read "three ways" instead of "two ways" and "fragmentation" instead
of "defragmentation".
Sorry.

Alex.

There was information that in 8.1.7 before PatchSet2 it may not create an exact copy of the source DB when using exp/imp...