Hi all,
i am using db2 v9.5 ESE on windows.
i am trying to move tables from one tablespace to another. To achieve this, i have followed these steps:
db2look on the database whose tables need to be migrated ->db2move export on the same database ->edit the exported file to use newer tablespace ->drop this database -> create another database with same name -> executed the sql file obtained by db2look command -> db2move import
But in the last step, i.e at the time of importing, for some of the tables the following error is thrown:
*** SQL3201N The specified table cannot be replaced because another table is dependent on it.
how can i find the dependency to come out of this error???
and is there any other simpler way to move tables to another tablespace???