|
-
Here are you go:
13:18:16 system@QM1T> create table test (col number primary key)
13:18:31 2 organization index;
Table created.
Elapsed: 00:00:02.19
13:18:37 system@QM1T> insert into test values (1);
1 row created.
Elapsed: 00:00:00.14
13:18:45 system@QM1T> insert into test values (2);
1 row created.
Elapsed: 00:00:00.00
13:18:52 system@QM1T> insert into test values (3);
1 row created.
Elapsed: 00:00:00.00
13:18:55 system@QM1T> commit;
Commit complete.
Elapsed: 00:00:00.00
13:18:57 system@QM1T> create table test_src as select * from test;
Table created.
Elapsed: 00:00:01.06
13:20:32 system@QM1T> alter table test_src add (constraint test_src_pk primary key (col));
Table altered.
Elapsed: 00:00:00.58
13:21:10 system@QM1T> create materialized view test on prebuilt table
13:21:16 2 as
13:21:17 3 select * from test_src;
Materialized view created.
Elapsed: 00:00:02.64
13:21:24 system@QM1T>
Sergey
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|