Several Views on one table

Dear all,

I find one problem in oracle database.
I have created several views on one table in the same schema. Then I create the SQL for input from these several views. It also halted and no response.

When I select only one view from one table, it works.

Is it because these several views locked the table?

If so, I think I need to create temp table for inserting from these views. And then select from these temp table.

Is there any alternative solutions?

Thanks for your help.

try EXPLAIN PLAN for the SQL in each of your views.

Look for TABLE ACCESS FULL - that query needs tuning - or your base table needs indexes.