Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    35

    Red face Unanswered: How to check if a table is a partitioned table?

    Hi ,

    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?

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: How to check if a table is a partitioned table?

    Originally posted by msetjadi
    how do i check if the table is partitioned?
    Look at column ALL_TABLES.PARTITIONED; it says 'YES' or 'NO.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •