I have 3 MySQL servers say A,B,C. What I want to do is that I want to make all of them master as well as slave.If there is update on any of the MySQL Servers it should be replicated to all of the Servers. I have studied about the circular replication and found it can [...]
I want to schedule function in Oracle. begin dbms_scheduler.create_job(job_name => ‘aud_clear’, job_type => ‘PLSQL_BLOCK’, job_action => ‘aud_clear_fun’, start_date => sysdate, repeat_interval => ‘freq=daily; byminute=0; bysecond=0′, end_date => null, enabled => true, comments => ‘Created By: MK; Truncates aud$ table’); end; I have tried to indicate several other values for job_action, for example: declare my_var number; [...]
I think I want to associate a piece of data with each session. The association must have the following properties: The data being associated is provided either as a part of connection string (if that is possible at all) or as a parameter for a stored procedure which then must be the first SP called [...]
In the SYS.USER$ view, what do the CTIME, PTIME, and LTIME columns represent? Where can I find Oracle’s documentation for this and other system views? – Answer –
I am newbie to SSAS 2012 and here are my questions: Can we have measures of complex types (table)? Is it possible to order the results by a specific measure or attribute? My cube can be modeled as one dimensional hierarchy, is this generally good? Can I shard cubes using remote partitions on a range [...]
Background: I have designed a solution for Filemaker to input data into a Question Database. After we are done with inputting data into Filemaker, we will be exporting the data as excel and transferring it into an online system probably running on ASP.NET or PHP part of it looks like this: Knowledge Table: Knowledge ID [...]
I’ve got a master and a slave postgres 9.1.3 database. I would like to init the backup database for the first time. I did the following steps: Stopped master Copied all files to Slave Create recory.conf on slave started master started slave This process seems to work, but I’ve got the feeling something is wrong, [...]
I wrote web app – java + spring+ PostgreSQL up and running. I have a tester for my system, however I want him to be able to connect to my database directly to check the result of interaction with application. As always web is trashed with articles on how to connect, one simple thing they [...]
oracle9i/windows2003,java application. oracle crash, alert log file contains sdh_ora_4636.trc which contains: *** 2012-05-05 13:53:32.000 *** SESSION ID:(100.50539) 2012-05-05 13:53:32.000 FATAL ERROR IN TWO-TASK SERVER: error = 12571 *** 2012-05-05 13:53:32.000 ksedmp: internal or fatal error Current SQL statement for this session: SELECT ID, CATEGORY, RESTOID, RESTAROID, CREATETIME, SNMPORT, UPDATETIME, ALIAS,SERIALID, ISOFFLINE, VERSION, SNMPREAD, DESCRIPTION, NAME, [...]
we have customer who faced an issue with some inconsistent data and we gave them a query to fix it. Now before running the query, the customers asks me for a query that will give the temp space required for running that query. This is actually important as this query could be affecting a lot [...]