user_objects not imported with schema

[bookouri]

Im using a full export of a 8.0.1 database and import of an application schema from that database into a new 9i database on new hardware. Everything seems to go ok but if I count the user_objects in the old schema and in the new schema the numbers are off by 3. Three objects dont make it into the new schema. I selected the user objects from the old and new schema and I found three objects
stock_item_transaction_ni3, stock_item_transactions_pk, and
work_flow_logs_pk. Those would account for the three missing objects.. but... there are also about 25 sys_c006220, sys_c006222, etc missing indexes.. Am I correct in assuming that since the dba didnt specifically name these objects that they "belong" to sys and thats why they are not counted in user_objects?

I'm also guessing that the missing 3 objects were not created because there was some kind of dependency that had not been imported yet? Is there a way to defer dependency/referential stuff until the end of the import?

thanks for any comment/suggestions..

 

[bookouri]

just a followup... I have found that at least some of the default named sys_c referential constraints did make it into the new database, but when I run my script:
select l.object_name, n.object_name
from
user_objects n, user_objects@oldlive.world l
where
l.object_name = n.object_name(+)

(live is my new db and the oldlive link is the old)

the 25 or so sys_c000 objects do not show up in my select..
in the new db but they are in the old db...but when I just select from the new db they are there. Obviously there is something wrong with my script to compare them...

 

[sem]

Is your db_link created for a specific or current user? May it be that you're selecting from different schemas?

Regards, Dima

 

[bookouri]

no, Im counting the same user's objects. I did find out that when you import a schema with "default system named" constraints, they are all renumbered in the new db. When I discount those, the only things missing seem to be specifically named primary key constraints. Ive done two or three imports now and the user object count has been 1 or 2 objects less in the new database than in the old one. In all cases they have been primary key constraints that were specifically named..ie staff_members_pk, users_pk etc. The odd thing is that if I look at the new db, the objects are there. Can they be there? They exist, but are not counted if I do a select count(*) from user_objects? Im really confused at this point.

thanks for any comments