I have a database whose backup file is about 1.4Gb.
All the tables are using now System Managed Tablespaces.
The database serves 5 different application, each one has its own user/schema.
I need to build 5 different Database Managed Tablespaces and then I need to move all the tables of each user in their corresponding new DMS.
So I have succesfully run these commands:
CONNECT TO FIDES;
EXPORT TO C:\PROGRA~1\SQLLIB\WEBCPTAB.IXF OF IXF MESSAGES C:\PROGRA~1\SQLLIB\WEBCPTAB.EXM SELECT * FROM FIDESRETE.CUSTOMER;
IMPORT FROM C:\PROGRA~1\SQLLIB\WEBCPTAB.IXF OF IXF MESSAGES C:\PROGRA~1\SQLLIB\WEBCPTAB.IMM CREATE INTO FIDESRETE.TEST IN FIDESRETE INDEX IN FIDESRETE LONG IN FIDESRETE ;
These commands have cloned the FIDESRETE.CUSTOMER table in the
So at this point I should:
- DROP TABLE FIDESRETE.CUSTOMER
- export/import again from FIDESRETE.TEST to FIDESRETE.CUSTOMER