New answers tagged

0

I was able to fine answer somewhere else. So I need to query role_tab_privs Here is the query in case somebody else will need it. set linesize 200 set pagesize 200 col role format a10 col table_name format a30 select role, table_name, privilege from role_tab_privs where table_name in ('TABLE_NAME') order by role;


-1

Right click on table in object explorer window and select properties. Going to permissions tab you can see your table roles.


2

I've used a program called Code Visual to Flowchart, if you feed in a SQL file it will generate a flowchart based on it. The free version is all I've used and it met the needs I had, making it much easier to work my way through a 3000 line procedure that was completely devoid of comments. "I can confirm I have no affiliation to this product"


1

The first problem: Error 21488 No active subscriptions were found. The publication must have active subscriptions in order to post a tracer token. This happens when attempting to put in a tracer token without an active subscription. This error seems pretty obvious. Error 18752 Only one Log Reader Agent or log-related procedure (sp_repldone, ...


1

The only problem seems to be your missing quotes for the dates. As they are enclosed in the string the have to be escaped (with a second single quote) like in my example: CALL SYSPROC.ADMIN_MOVE_TABLE( 'ADMIN', 'TRANSACTION', '', '', '', '', '', '(TRANSACTIONDATE) (STARTING FROM (''1/1/2010'') ENDING AT (''1/1/2017'') EVERY 1 MONTH)', ...


1

Space will not be the only factor in where you place the new space. If you are talking about expanding the capacity of the existing drives you should look at what do the underlying volumes have backing them. I.e how many physical drives are assigned to the drive arrays and what the RAID levels are for those arrays. For HDDs the more drives you have in an ...


0

My Data files are always kept in a separate drive from where the SQL install took place. Therefore, databases like master, model, msdb, and tempdb are always on one drive, while my (user) databases are on (one or more) separate drives. This is not so much for performance reasons as it is for Disaster Recovery/Security. it is much easier to restore a SQL ...


0

I was putting the wrong service name. You can check yours on tnsnames.ora.


0

So I didn't got any luck with the deadlock graph. Doesn't seem to appear in my SQL Logs. But, I did find out that another job has been scheduled to run at the same time than my job, and it was taking backups and sending e-mails at the same time that my job was trying to cleanup the mail history. So changing the schedule of the other job got my problem solved!...


2

When you don't provide any location,SQL Server by default uses server level settings which are provided during installation.What this means is if you don't provide any location while creating database,SQL uses this location by default..This can be changed at any time and can be found here Further while creating a database,You also can provide location ...


1

At a minimum, every SQL Server database has two operating system files: a data file and a log file. They are usually in this location c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\data\ So, you could first find out the current physical address of these two files. secondly, shut down the database. Thirdly copy and paste them into a new ...


1

You need to check the actual size of the database files which you can check by running RESTORE FILELIST ONLY FROM <backup_device> This will give you information about the files contained in the backup and their sizes in bytes You need the same space available on the server as the database file size, the backups can be compressed. Now you need ...


0

Oracle's installers are mostly Java based - see here. Oracle apparently wants to "universalize" (yuck, what a word) the procedure. Apparently, however, for XE on Windows, they decided that it would be best just to have a plain old .exe. Maybe they figured that Windows users who chose the XE option weren't up to installing a JVM? :-). Maybe they used some ...


0

First of all these V$ views are public synonyms hence can be accessed by any user having appropriate privileges. Since these views are public we don’t need to prefixed with the SCHEMA name though these synonyms are owned by SYS. After altering session as alter session set current_schem=SYS objects are prefixed with specified schema name in the subsequent ...



Top 50 recent answers are included