oracle11g - Oracle queue is not been imp or exp in Oracle 11g -

-

i exported oracle database using command

exp system/password@sid file=c:\expdb.dmp

after import in instance using 

imp system/password@sid file=c:\expdb.dmp

everything looks in closer notice queues , queue_tables did not new database.

after try exp/imp work while decide easier reinstall queues find had tables related queries in database first try 

delete table

and got error:

ora-24005: inappropriate utilities used perform ddl on aq table

so try

begin dbms_aqadm.drop_queue_table('table',true); end;

and work. question is, how avoid trouble in first place? there way export database queues? missing flag? painful exersise each time have import new database queues.

you don't export oracle queues using exp or expdp.

you must create new queues in target database.

exp/imp queues lead database catalog corruption.

note: in 11gr2 documentation states:

export import of queues supported @ queue table level granularity. user needs export queue table. queues in queue table, primary object grants, related objects views, iots, rules automatically exported.

this valid if exp/imp using 11gr2 source , target database. aq definitions changes 11gr1 11gr2 instance.

and error message face when submitting delete statement:

this expected behaviour in 11.2. prevented performing inappropriate ddl on aq objects in 11.2 , ora-24005 reported.

to truncate queue table , associated iots, use dbms_aqadm.purge_queue_table.


Comments

Post a Comment

Popular posts from this blog

python - TypeError: start must be a integer -

-
i trying draw 5 turtles, getting typeerror on line 25. here code: import turtle wn = turtle.screen() redrose = turtle.turtle() color = input("what background color be?") fillcolor_f = input("what color of rose be?") redrose.hideturtle() redrose.speed(30) redrose.penup() redrose.left(180) redrose.forward(175) redrose.right(90) redrose.forward(30) redrose.right(90) redrose.pendown() def drawrose(red): redrose.color("pink") redrose.fillcolor(fillcolor_f) redrose.fill(true) in range(red): redrose.forward(i) redrose.right(49) in range(5): drawrose(redrose) redrose.penup() redrose.forward(350) redrose.right(144) redrose.pendown() redrose.fill(false) drawrose(50) wn.bgcolor(color) i trying draw 5 roses, produces errors. doing in interactivepython.org. you recursively calling drawrose wrong parameter. on line 23 ( for in range(red): ) expect red integer...
Read more

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

-
i have following code almost works properly; private void cbstatus_drawitem(object sender, listboxdrawitemeventargs e) { string item = e.item string; if (item != null) { switch (item) { case "1": e.appearance.forecolor = color.green; e.appearance.backcolor = color.green; break; case "2": e.appearance.forecolor = color.orange; e.appearance.backcolor = color.orange; break; case "3": e.appearance.forecolor = color.red; e.appearance.backcolor = color.red; break; } } } when dropdown shown, items forecolor correct, backcolor remains whatever backcolor of theme is; i.e. if i've got set dark theme, backcolor dark, cells in gridview, rather being green/orange/red. i've tried setting e.appearance.options.usebackcolor trying set e....
Read more

django - Creating multiple model instances in DRF3 -

-
1) create multiple model instances 1 api call, asked here: how create multiple model instances django rest framework? tried solution named in link, no success. i trying upload multiple files in 1 api call. result: files uploaded (only once overwrote perform_create) 1 instance created (if send 2 files, latter created instance). my code: class fileuploadserializer(serializers.modelserializer): def __init__(self, *args, **kwargs): many = kwargs.pop('many', true) super(fileuploadserializer, self).__init__(many=many, *args, **kwargs) class meta: model = fileupload read_only_fields = ('created', 'datafile', 'owner') class fileuploadviewset(viewsets.modelviewset): queryset = fileupload.objects.all() serializer_class = fileuploadserializer parser_classes = (multipartparser, formparser, ) def perform_create(self, serializer): file_list = self.request.data.getlist('file') ...
Read more