-
How to get create snapshot statement on oracle 8i database.
I need to extract DDL from oracle 8i database for materialize view(snapshot). I don't have any tool now. dba_source don't have materialized view. Any other dictionary view/packages I can use to get DDL?
By the way, I used exp/imp I got errors. exp/imp is 10g to 10g
IMP-00003: ORACLE error 1722 encountered
ORA-01722: invalid number
Thanks.
-
you want to create materialized view ?
-
problem resolved.
I did exp from original 8i database. then extract create snapshot statement from 8i dump file. It worked.
-
materialized view and snapshot ae same thing.
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
|