Questions tagged [sys]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
2answers
30 views

Oracle 12c - Insufficient Privileges When Trying To Create A Trigger With SYS User

I want to create a trigger for CRE schema. I'm trying to create this trigger with SYS user but I have insufficient privileges error. My trigger: CREATE OR REPLACE TRIGGER CRE.TRIGGER_NAME AFTER LOGON ...
0
votes
1answer
42 views

Oracle SYS views missing from DB instance [closed]

Hi i have a question but not sure what the problem was and how it happened though. The initial error when i logged in the DB dev machine was ORA-00942: table or view does not exists. Some of the ...
1
vote
2answers
109 views

Does restoring a database in Microsoft SQL Server add objects to Resource Database?

As far as I know the resource database contains information on all objects in its server instance, so I would think it's only natural that when you restore a database from a backup file, part of the ...
2
votes
1answer
1k views

How to fix the sys.host_summary table in MariaDB 10.3.13

using mysqldump while doing a backup gives the following error: mysqldump: Got error: 1356: "View 'sys.host_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view ...
0
votes
1answer
730 views

What is the safest way to install the sys schema on a production server?

The reason I'm asking is because I need to install the sys schema on my database so that I can utilize performance_schema because I'm hoping that will help me figure out why mysql is crashing every 30 ...
0
votes
1answer
7k views

Why am I getting “Invalid object name 'sys.sysobjvalues'.” [duplicate]

When I run SELECT OBJECT_DEFINITION(OBJECT_ID('sys.assembly_files')); I can see that there is a self-join on sys.sysobjvalues, but when I try to select that table I get, Msg 208, Level 16, State 1,...