The dba tag has no wiki summary.
-1
votes
1answer
13 views
Importing only one user data from a Dump file
I am using oracle 11gr1 SingleByte Database,
I am trying to import a Dump file. but strangely the dump file contains multiple user objects(i.e, Import(IMPDP) is not done properly).
example:
. . ...
0
votes
0answers
41 views
I need advise on these queries
could you help me optimize these queries?
here are queries, please note that you see something like OR 1=1 OR those are values I pass via php and may change.
query#1:
SELECT posts.status, ...
1
vote
1answer
69 views
Junior DBA hopes for advice [closed]
This is the 7th month of my DBA career, and I just graduated as a master, no experience before. My daily work for now is pretty much about backup/restoring databases in different environments ...
0
votes
1answer
33 views
Install and Configure Oracle 11g using c# program [closed]
I need to create a windows application program using c# which will allow me to install oracle client 11g and also configure ODBC automatically with just one click, as my customers have limitations in ...
2
votes
1answer
90 views
Migrate / Copy Huge data from Oracle to SQL Server
I have huge tables in oracle database, appx 1 crore+ (10 million+) rows and want to migrate / copy those table and data in sql server.
Currently I am using Import functionality of SQL Server for this ...
-4
votes
1answer
52 views
recommendations needed in order to become a junior DBA [closed]
I want to start off work being a junior DBA very soon. At the moment I have a Bsc in ICT 2:2 but my database marks was very strong including an 86 in my oracle assessment which is following a ...
0
votes
1answer
122 views
Creating and tuning a materialized view in oracle for use by Cognos BI
I am currently in the middle of a Cognos BI implementation and am having difficulty in tuning a view in order for SQL Server to select its contents for fulfilling the incremental load in a timely ...
0
votes
0answers
141 views
mysql deadlock while updating: ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction update
I am using the mysql version 5.5.29 in my production server. while executing set of update statement inside the procedure it is throughing the following error:
ERROR 1213 (40001): Deadlock found when ...
0
votes
3answers
65 views
How to manage constants within an Oracle Database
This question touches on a few different parts of Oracle that I'm not particularly familiar with so bear with me:
I am trying to redesign some of the procedures and functions within the database I ...
3
votes
2answers
155 views
Do roles have an owner in oracle?
Suppose that I have logged in to oracle database using user X, then user X creates some roles using create role command. I want to know that is user X the owner of the roles? Can I select all roles ...
3
votes
1answer
192 views
SQL Server Restore from one database to another
One of our devs backed up a dev database, and then restored it in production. It's a new database for a new app that was deployed last night intentionally to prod.
Now in the backupset table ...
1
vote
1answer
193 views
Oracle delete technique for table's segment size (data compactness)
I would like to ask if there is any effect on the following deletion technique of a database to the tablespace size. The existing code for clearing the data has the following style of code before:
...
2
votes
0answers
69 views
SQL Server Online Training [closed]
I recently took an intro class for MySQL from www.oreillyschool.com and it was very helpful. The next class they offer is administering MySQL but I currently work with SQL Server. The first class was ...
1
vote
1answer
231 views
InnoDB, What would cause: “db1/tableABC contains 6 indexes inside InnoDB, which is different from the number of indexes 5 defined in MySQL”
MySQL 5.5.24 .
We have InnoDB tables that grew almost by double (from 50GB to 100GB - file-per-table enabled) in a few weeks due to a project we are working on.
The tables were freshly dumped and ...
4
votes
1answer
134 views
Managing Access for DBA and IT Support
We are currently in the process of moving our development, test and live databases on to separate servers and instances and I am looking at how best to manage access for DBA tasks and also IT Support ...
7
votes
5answers
1k views
Are there any professional fulltime PostgreSQL DBA's?
For my job I work on a JavaEE application with PostgreSQL as the database. Although we have a sysadmin for our productions servers, who also manages our database servers, we have no full-time DBA ...
