I just installed Oracle 19c on Red Hat and would like a graphical way of managing users and tablespaces. I enabled EM Express but the new interface (omx) does not allow to manage users, and the old (emx) interface cannot be used because Flash is forbidden by our policy. I also discarded SQL Developer since it is too complex: I would like a simpler tool. Does oracle database include anything similar to the EM Database Control of oracle 10g?

Is it possible to store first-/last-/fullnames and possibly additional information of/for oracle user accounts in oracle? I look at the table dba_users but it does not contain such information. I need to make sure that the oracle accounts are mapped to a unique person. So besides the names, ideally I need to have a core identity information or E-Mail address on top of the names. How can this be ensured in oracle?

I am just starting to explore using Policy Based Management in SQL 2016. I created a policy that runs in SSMS just fine. I exported the policy to a folder on the local machine (VMSk1) that is shared to Everyone/read. I go to a second machine (VMSk2) and execute the following powershell. The idea was to have a central location for the xml export files and run on any server.... $Path = "\\\vmsk1\PolicyExports\AllDatabasesInSync.xml" Invoke-PolicyEvaluation -Policy $Path -TargetServerName $env:computername ...I get the following error... > Invoke-PolicyEvaluation : File 'Microsoft.PowerShell.Core\FileSystem::\\vmsk1\PolicyExports\AllDatabasesInSync.xml' does not have a valid XML format that can be deserialized to a policy. If I copy the file to VMSk2 and run... $Path = "c:\PolicyExports\AllDatabasesInSync.xml" Invoke-PolicyEvaluation -Policy $Path -TargetServerName $env:computername ...the policy will execute. I tried $Path = "\\\vmsk2\PolicyExports\AllDatabasesInSync.xml" and it failed. So I am left with the conclusion that the cmdlet will not work with an xml file located anywhere but a local drive; which seems just plain wrong. Am I missing something? Why can I not execute the policy using an xml export file from a network share?

These were my instructions: Create a stored procedure that receives two parameters: @i_action in which: - 'I' = inserts a value - 'U' = Updates values - 'D' = Delete Values - 'C' = Consult and @_option where - 1 = cursor - 2 = specific value for @i_action it must go through the procedure. On top of that: - If @i_action = 'C' and @i_option = 2 it must return a value indicating "Invalid option" - if @i_action = 'C' and @i_option = 1 it must go trough the table with an specific value I am honestly at a lost as I have never done a stored procedure that is this complex (I have not even made an IF or CASE that is this complex) this is what I am attempting right now:

GO
CREATE PROCEDURE TWOPTIONS
@i_action  varchar (1),
@i_option int,

AS

IF @i_option = 2

declare @value 

IF @i_action = 'I' Insert into Authors values ()
IF @i_action = 'U' Update Authors Set country = 
IF @i_action = 'C' Select * from Authors 
IF @i_action = 'D' delete from Authors where Name =

I am mostly struggling with the structure I am sure I can make the instructions work once I figure it out.

I just inherited an AWS RDS PostgreSQL 12.5 instance (so, ***no superuser access***) and I'm required to do some cleanup and delete a bunch of groups/roles/users. I'm executing the following commands with user 'master' provided by AWS on the only available database (apart from *postgres* db) When trying a: DROP ROLE xxx I get: > ERROR: role "xxx" cannot be dropped because some objects depend on it > DETAIL: N objects in database xxx After a LOT of googling I ended up with: REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA some_schema FROM "xxx"; REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA some_schema FROM "xxx"; REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA some_schema FROM "xxx"; REVOKE ALL PRIVILEGES ON SCHEMA some_schema FROM "xxx"; REVOKE USAGE ON SCHEMA some_schema FROM "xxx"; ALTER DEFAULT PRIVILEGES IN SCHEMA some_schema REVOKE ALL ON SEQUENCES FROM "xxx"; ALTER DEFAULT PRIVILEGES IN SCHEMA some_schema REVOKE ALL ON TABLES FROM "xxx"; ALTER DEFAULT PRIVILEGES IN SCHEMA some_schema REVOKE ALL ON FUNCTIONS FROM "xxx"; REVOKE ALL PRIVILEGES ON DATABASE xxx FROM "xxx"; But still, the DROP fails: > ERROR: role "xxx" cannot be dropped because some objects depend on it > DETAIL: privileges for default privileges on new types belonging to > role master in schema some_schema > SQL state: 2BP01 Tried to check dependencies using (taken from some stackoverflow question) but query comes up with nothing: SELECT * FROM --r = ordinary table, i = index, S = sequence, v = view, m = materialized view, c = composite type, t = TOAST table, f = foreign table (SELECT N.NSPNAME AS SCHEMA_NAME, C.RELNAME AS REL_NAME, C.RELKIND AS REL_KIND, PG_GET_USERBYID(C.RELOWNER) AS OWNER_NAME FROM PG_CLASS C JOIN PG_NAMESPACE N ON N.OID = C.RELNAMESPACE UNION ALL -- functions (or procedures) SELECT N.NSPNAME AS SCHEMA_NAME, P.PRONAME, 'p', PG_GET_USERBYID(P.PROOWNER) FROM PG_PROC P JOIN PG_NAMESPACE N ON N.OID = P.PRONAMESPACE) AS FOO WHERE OWNER_NAME = 'xxx' Then tried to check privileges using (again, came up empty): SELECT grantee AS user, CONCAT(table_schema, '.', table_name) AS table, CASE WHEN COUNT(privilege_type) = 7 THEN 'ALL' ELSE ARRAY_TO_STRING(ARRAY_AGG(privilege_type), ', ') END AS grants FROM information_schema.role_table_grants GROUP BY table_name, table_schema, grantee HAVING grantee = 'xxx' This is my first time with PostgreSQL, coming from SQL Server.

I'm improving our SSIS process passing the variables through a declare and I found this: Here you have the plan execution using variables brentozar.com/pastetheplan/?id=rkSxs7VPv for the following statement:

select *
from fact_Venta
where Data_ID >= @data1
and Data_ID =@1 
AND [Data_ID]<=@2

As you can see, when I use the declare SQL Database Engine doesn't use the index. The index used is a non-clustered for the column used on the where. Both executions were on the same server, with the same set options and at the same time executed.

I am wondering if someone already experience this weird scenario regarding my SQL Server Management Data Warehouse; it creates a lot of user connections. Around 2500 connections which were all sleeping. When I turned off the data collector, all the connections were disconnected but I am wondering what the problem is supposed to be. My MDW Repo is running under SQL 2014 and is getting around 100+ instances. The server that I am having a problem with is running SQL Server 2012 SP2 CU 12.

I've just recently bought a host with a domain and as I was following a tutorial on youtube for installing wordpress I accidentally erased my primary database. So now my site doesn't even have the default inserts it had from the beginning. When I write the website adress in the web browser it says: "Error establishing a database connection." Then in cpanel as I enter Domain my webaddress is there but when I click on manage domain it says: "No configuration options currently exist for the “here it says my domainname” domain." How can I fix the issue?

Any suggestions on how multi-dimensional time-series data should be stored and organized in an RDBMS environment? For example, we have multiple experiments from multiple customers. This translates well to say a NetCDF file type structure, where one NetCDF can be for one customer project, and it contains several data variables overtime. This image explains the concept. From my preliminary research , this seems like an unsolved problem or one with a complicated solution . Are there any recent (not necessarily optimal) attempts at this?

Need the erd of the schema for doctor, patient and appointment database. scenario is given as under: Clinic Management Entity-Relationship Model ===================================== -Doctor has a unique id, name, address, qualification and speciality stored for him. Doctor can have 3 time slots in which he can check patients on each day and specialists are not available daily but twice a week only. however, medical officers are available daily. -Patient has unique cnic, name, address and has a home phone and mobile number, blood group stored -Disease data is maintained for more than 300 diseases with disease id, scientific name, common symptoms. -When patient comes to clinic 5 common diseases out of 300 are noted for each patient in (yes or no) response i.e: bloodpresure, diabetes, uric acid, heart attack, hepatitis. -Patient can book appointment from many doctors at different time slots. A doctor can give appointment to only 10 patients in a time slot. Appointment is not given for doctor if his time slot reaches full capacity for that particular day.

I have several versions of SQL Server, used for testing, installed on my laptop (2012, 2014, 2016, and 2017). I noticed the other day that there was a folder containing prior versions of files across updates (SPs, CUs). Across all versions there is actually quite a bit of space being taken up: (in **C:\\Program Files (x86)\\Microsoft SQL Server\\**) 110\Setup Bootstrap\Log - 91.8 MB (818 files) 110\Setup Bootstrap\Update Cache - 608 MB (2,382 files) (all folders below reside within: **C:\\Program Files\\Microsoft SQL Server\\** ) 110\Setup Bootstrap\Log - 1.18 GB (3,715 files) 110\Setup Bootstrap\Update Cache - 9.58 GB (14,766 files) 120\Setup Bootstrap\Log - 569 MB (2,963 files) 120\Setup Bootstrap\Update Cache - 5.74 GB (12,797 files) 130\Setup Bootstrap\Log - 448 MB (2,808 files) 130\Setup Bootstrap\Update Cache - 3.84 GB (8,579 files) 140\Setup Bootstrap\Log - 84.3 MB (687 files) 140\Setup Bootstrap\Update Cache - 937 MB (1,571 Files) Totals for those folders are (MB have been normalized to GB): Folder GB Files ---------- ----- ------ Log 2.35 10,991 Update Cache 20.66 40,095 TOTAL 23.01 51,086 Initially I figured that it should be safe to remove the **Log** and **Update Cache** folders, but then I reckoned it best to first check to see if others have asked this and if so, what the answer(s) had been. I found this KB article: Description of the Update Cache folder in SQL Server which states: > ### What happens if you remove this folder or delete its contents? > > If the Update Cache folder or some patches are removed from this folder, you can no longer uninstall an update to your SQL Server instance and then revert to an earlier update build. In that situation, **Add/Remove Programs** entries point to non-existing binaries, and therefore the uninstall process does not work. Therefore, Microsoft strongly encourages you to keep the folder and its contents intact. Ok. I have no plans to ever downgrade or uninstall an SP or CU, so I should be ok, right? Well, there are other references, such as this one: Is it safe to delete the "Update Cache" folder? in which someone referenced the following KB article: How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update which states (emphasis added): > When you install SQL Server, the Windows Installer stores critical files in the Windows Installer Cache (default is C:\Windows\Installer). These files are required for uninstalling **and updating** applications. Now, this particular article seems specific to the **C:\\Windows\\Installer** folder, and I am not talking about deleting from that folder. Still, due to the mention of the possibility of not being able to apply updates, I wanted more info first. Has anyone removed these folders before, or at least just their contents? If so, were there any negative effects? These folders only ever increase. I just applied the "Spectre / Meltdown" patches for all four versions and the totals increased by 3.65 GB and 6,900 files (the end result being the figures shown in the chart above). To be clear, I am not looking for should I or shouldn't I remove one or both of these folders; I am looking for _can_ I or _can't_ I remove one or both (without breaking anything more than the ability to uninstall / downgrade, which I already accept as a consequence).

I've been thinking about this a lot recently: Is there a consensus as to how to check SQL Server Agent jobs have run correctly? - Some advice seems to be alerting the operator on failure and addressing those, but this won't account for jobs that haven't run (say if the agent went down for a time) at all rather than run and failed. - Some advise to use Job Activity Monitor and check the schedules and statuses, which is better but requires you to connect to every server, which can be arduous in a large estate, and maintain a list of job timings. - We currently have a list of jobs per server and have an operator set up that mails to a single DBA account. Daily we go through and check each job in the spreadsheet against the notification emails checking failures or absence of a notification. I feel like there has to be a better solution, but my googling hasn't brought anything up. Does anyone have a better solution for managing the status of agent jobs? EDIT - I should also add that we IDERA SQLDM to monitor some servers, but don't have the budget to look at all our servers. Also our SCOM implementation is in the hands of our server team and currently getting info out of it isn't easy for us. This makes getting reliable information about the status of the agent hard.

First, I want to clarify that **I am not looking for a** SELECT HOST_NAME(). I am managing a database environment and have given the developers permission to create the databases they need in the development environment. However, I want to **store** the machine name (HOST_NAME()) from where the database is created independent of the database user that they use for that purpose. This way, proactively, when a developer creates a database **in the future** I want to know who creates databases, not only by the owner user but by the name of the machine.

I'm looking for a way to predict growth of the database given its fields, indexes, constraints (as foreign key), number of lines, and so. I searched on Google, but I found only means to determine the actual space occupied by the database, and can not predict their growth. For example, how can I determine how many bytes would be occupied on disk for the following tables, in the following cases 1) 100,000 rows in the account table, 10 rows in the role table and 100,000 lines in account_role table. 2) 500,000 lines per account table, 20 lines on paper table and 600,000 rows in the table account_role? CREATE TABLE account( user_id serial PRIMARY KEY, username VARCHAR (50) UNIQUE NOT NULL, password VARCHAR (50) NOT NULL, email VARCHAR (355) UNIQUE NOT NULL, created_on TIMESTAMP NOT NULL, last_login TIMESTAMP ); CREATE INDEX username_index ON COMPANY (username); CREATE TABLE role( role_id serial PRIMARY KEY, role_name VARCHAR (255) UNIQUE NOT NULL ); CREATE TABLE account_role ( user_id integer NOT NULL, role_id integer NOT NULL, grant_date timestamp without time zone, PRIMARY KEY (user_id, role_id), CONSTRAINT account_role_role_id_fkey FOREIGN KEY (role_id) REFERENCES role (role_id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT account_role_user_id_fkey FOREIGN KEY (user_id) REFERENCES account (user_id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION );

I know a lot of Database Administrators and they are all over 28-29 years old. Is all database administration like that? I mean, is this about getting experience more than at least 7-8 years? Or is being a database administrator so hard?

I have myserver.database.windows.net with administrator login John.
I'd like to change it to Peter.
It is possible, if so, how ? Alter which works with local sql server, doesn't work here > ALTER LOGIN John WITH NAME=Peter

I am new to web development field and particularly very poor at database management. I am developing a web application which resembles Project Management System where new companies can add their profile, create a project under them, under each project they can create a new task and so on.... Hence, my question is right now is should i use one common table for all the new profile (abc & co) created and one common table for all the users registered under profile (abc & co) created, or should i create new tables for each when a new profile is created and new table for each users and project created ?

What are the prevalent best practices for managing database of an application? One option is to have an sql script to create the empty tables, and also to start with hardcoded options. (Say all locations, or profession types). During upgrade, you know whats in there and whats not, so on the server, run an sql script that adds columns and any new data. Another is to do this programmatically, where everytime the server runs- it checks if the db exists, and if not, create it. And during addition of new columns- there would be code that would check if a certain column exists in this schema, and if not add it with a default value of my choice, and also any new data that should be needed. My constraints are: * Should be blindly able to restore a backup if anything goes wrong. * Minimal manual intervention * I'm planning to run it 24/7 Under addition of tables and columns: By upgrading the SQL database first, and then the application code for corresponding fields. Under removal of tables/columns: By downgrading the application first, and the SQL database. * I'm not using an ORM. Am I missing things here that I should add to the constraints? Please clarify your reasoning in relation to the answer. Also, I hope that since I'm asking for a constrained answer along with sources and reasoning, this wouldn't count as a opinion based question. EDIT: In Added constraint(3) in response to comment.

Is there a rule of thumb for creating a tablespace with extent management AUTOALLOCATE or UNIFORM? If the latter applies, how to estimate a reasonable extent size? Even more, what should apply for default tablespaces like SYSTEM, SYSAUX, UNDO, and TEMP?

I have about 120 databases in my SQL. I want to migrate so I want to know which databases are not used in last 30 days.