var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to check if a table is a partitioned table?
I try to import a schema objects from schema A database A to schema B database B. I use an export file. I did not import the data but only table,views,trigger etc.
When i use the following command:
imp user/pass file=file.dmp indexes=N grant=N rows=N ignore=y
i have some tables that was not imported successfully because the tablespace is different
After i check the documentation, it is sait that the table might be a partitioned table.
How can import those table successfully, how do i check if the table is partitioned?
Re: How to check if a table is a partitioned table?
Look at column ALL_TABLES.PARTITIONED; it says 'YES' or 'NO.
Originally posted by msetjadi
how do i check if the table is partitioned?