SELECT  
    *  
FROM  
    user_tables A  
WHERE  
    NOT EXISTS (  
        SELECT  
            *  
        FROM  
            user_constraints b  
        WHERE  
            A .table_name = b.table_name  
        AND b.constraint_type = 'P'  
    );