Copy data to another schema

[islandfong]

I am trying to copy data from one schema to another schema using TOAD connecting to Oracle 10i. Some of the tables can be copied smoothly but two some of them cannot. There is no error message given, TOAD just hangs there and the status bar shows "fetching rows.". The source table and destination table are identical. Anybody knows what's happening?

[arg]

I bet TOAD is waiting on a constraint, trigger or a lock, neither will return an error message to toad. A update/insert trigger set on a table or it's index your copying is most likely your problem. Using 'Create like' or 'Create script' or 'Create in another schema'?

[SQLNAVIGATOR]

I bet TOAD is waiting on a constraint, trigger or a lock, neither will return an error message to toad. A update/insert trigger set on a table or it's index your copying is most likely your problem. Using 'Create like' or 'Create script' or 'Create in another schema'?

Use SQL navigator . works much better

[debasisdas]

try to check for any cascade dependency of the table with other tables