Print Thread
materialized view; on prebuilt table; export user objects
#21853 03/02/06 06:37 PM
Joined: Nov 2003
Posts: 35
F
Member
OP Offline
Member
F
Joined: Nov 2003
Posts: 35
In 'Export User Objects' pl/sql-dev does not export the target table of a materialized view. This makes sense for a normal MV because the target table is created when the MV is created.

If the MV uses the clause 'ON PREBUILT TABLE' the export should contain the target table because it is not created when the MV is created. Otherwise the schema is incomplete.

Re: materialized view; on prebuilt table; export user objects
#21854 03/02/06 07:56 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
I have added this to the list of enhancement requests.


Marco Kalter
Allround Automations
Re: materialized view; on prebuilt table; export user objects
#21855 03/05/08 03:19 PM
Joined: Nov 2003
Posts: 35
F
Member
OP Offline
Member
F
Joined: Nov 2003
Posts: 35
Hi,
are there any news about this problem?
I am using Version 7.1.4.1389 and the prebuilt tables are still missing in the export script.
Regards Frank

Re: materialized view; on prebuilt table; export user objects
#21856 03/05/08 04:16 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
No, unfortunately this is still on the list.


Marco Kalter
Allround Automations
Re: materialized view; on prebuilt table; export user objects
#21857 05/14/08 12:19 PM
Joined: Nov 2003
Posts: 35
F
Member
OP Offline
Member
F
Joined: Nov 2003
Posts: 35
Hi,
we still have this problem in 7.1.5.1396.
Any chance to fix it with the next version?
Thanks Frank


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.233s Queries: 13 (0.107s) Memory: 2.5149 MB (Peak: 3.0427 MB) Data Comp: Off Server Time: 2024-05-18 05:47:00 UTC
Valid HTML 5 and Valid CSS