Duplicating database

[adek]

Hi,

I copied one of my dbs using the method of copying the actual data files. It works gret, exept that i can't delete the old data from the new db. I get an error that looks something like this: "DELETE statement conflicted with the COLUMN REFERENCE constraint..."
How can I fix this problem alt. copy in another way? All I actually need is the structure, so...

Thanks!
//adek

 

[joet7878]

Im not sure what your using but you can try logging into sqlplus and typing

alter index <indexname> rebuild parrallel <cpu>(example 1-4);

Then

alter table <table name> deallocate unused;


Hope this helps

 

[Transcend]

Have you got any relationships on the database?
You probably need to create a script that will delete all your data in order so that no conflicts occur.

Transcend