FULL Export/Import

[samdba]

Hi Guys,

I have taken FULL export of D.B with COMPRESS=Y option. Now I want to import it back in the same Database.

Main purpose of full export/import is to remove fragmentation and reorganize the database.

Do I have to first drop all the users with cascade to make the database empty keeping only SYS and SYSTEM users?

Do I have to do import with IGNORE=Y.

Pl. help to clarify.

Thanks in Adv.

[marist89]

Keep the users, drop all their objects. Use something similar to http://home.adelphia.net/~marist89/s...ipe_schema.htm to whack all the objects.

If you use this method, you will not have to worry about IGNORE flag.

[samdba]

Originally posted by marist89
Keep the users, drop all their objects. Use something similar to http://home.adelphia.net/~marist89/s...ipe_schema.htm to whack all the objects.

If you use this method, you will not have to worry about IGNORE flag.

Hi,

Thanks.

I have to ignore SYS,SYSTEM users while dropping all objects. Right?

Another good question:

I want to import the database A into Database B. Both have different table structures and also difference in objects.

Can I still import B into A?

Thanks.

[marist89]

Originally posted by samdba
I have to ignore SYS,SYSTEM users while dropping all objects. Right?

Another good question:

Ah, yeah. Only drop those objects in which you will be importing the owners.

I want to import the database A into Database B. Both have different table structures and also difference in objects.

No problem, as long as the objects are dropped on the destination db before you import.