Oracle Database Discussions

hi masters,

we are using oracle 10g R2 on linux.

i have one schema say user1 having many tables, starting with

BC_ (50 TABLES)

PC_ (20 TABLES)

LC_ (30 TABLES) etc.,

now i want to create these tables in another schema with their constraints and privileges, in another schema.

like i want to generate a create table script, which will create table starting with 'BC_' only. another script will create table starting with 'PC_' only. and like that.

is this possible with command

create table AS
select * from (old schema).(table_name);

can we use sub query in this to be more specific?

and will it transfer all its privileges and grants to new schema??


thanks and regards
VD