All Questions
17
questions
0
votes
0
answers
49
views
Importing mysql database into Oracle OCI Ubuntu instance
I recently spun up a Ubuntu instance on Oracle OCI (https://cloud.oracle.com) to host a Laravel application. I need to be able to import a large-ish mysql database, but every time I try, it hangs up ...
- 101
1
vote
0
answers
612
views
ORA-12541: TNS:no listener
Here is the situation:
I have a computer(let's call it server PC, whose IP is 192.168.1.100) that has ORACLE installed on it. I can access the data in oracle using Python on this server PC(This means ...
- 111
3
votes
1
answer
403
views
Can I "flush and lock" an Oracle database to do a filesystem backup?
I'm using ZFS to take snapshots of running OpenVZ containers.
For MySQL databases I can use flush tables with read lock to put them in a flushed & locked state. This will put the underlying files ...
- 1,253
1
vote
0
answers
380
views
Oracle 6.5: MySQL Daemon failed to start
I installed MySQL by following these instructions on my Oracle Linux Server release 6.5, specifically using the yum package installer command,
yum install mysql mysql-server mysql-libs mysql-server
...
- 111
0
votes
1
answer
4k
views
oracle - grant all privileges to schema
i've used mysql before and i'm now switching to oracle.
I've already created a user in oracle. Now i want to give it "all privileges" for a schema.
In mysql i can give all privileges (DML/DDL) for a ...
- 1,463
6
votes
4
answers
14k
views
Why "Begin Transaction" before "Insert Query" locks the entire table?
I wrote a stored procedure to insert a record. I added "Begin Transaction" just above the Insert Query and execute the query. I noticed that another application that was showing a web page with ...
- 215
1
vote
4
answers
2k
views
SQL server Vs MySql vs Oracle for a large government project [closed]
I am in charge of deciding which database to use for a big government project with:
100 Million records (estimated in one big table)
Availability and data reliability is paramount.
Performance not as ...
- 261
0
votes
1
answer
125
views
lock table syntax from mysql to oracle
I've a mysql sql locking some tables with different permission (read or write).
I've to adapt it for oracle, but I did't found any clear documentation to do this job right.
this is an example:
LOCK ...
3
votes
3
answers
211
views
Is there a way to communicate DBMS with raw memory block or binaries
I am trying to communicate a numerical matrix operations library like LAPACK with any DBMS.
Is it possible to send/receive complete matrices as binary or as a direct memory pointers to process them (...
- 219
1
vote
4
answers
126
views
Database security
What aspects should be considered in order to have a secure database?
Along with avoiding sqlInjection, what else should be considered? What should not be done?
- 219
0
votes
1
answer
300
views
Configuring ASR and Oracle Clusterware
I have a four server cluster with Oracle Clusterware managing 4 MySQL instances on them. On failure Clusterware will move the MySQL instance to another server.
I am on Proliant servers and also have ...
- 1,155
-1
votes
5
answers
5k
views
What are the most popular database vendors based on market share? [closed]
I am wondering if anyone can point me to research or a link to statistics regarding popularity of database deployment. Obviously, MySQL, Oracle, SQLServer are some of the major players but I am ...
- 123
3
votes
3
answers
211
views
Suggestions for spatial database systems [closed]
I'm looking for suggestions on a database for large sets of spatial master data. The data itself is not relational, but could be formulated as such. The data as-is is structed as:
latitude, ...
- 31
1
vote
6
answers
359
views
What DBMS' have tight integration with a dedicated OS'?
It has always been my strong conviction that a large-scale multi-user DBMS should reside, stand-alone, on a dedicated server or clusters, with no other unecessary apps, processes or services which ...
- 155
3
votes
2
answers
2k
views
Replicate Oracle to MySQL
I am developing a web apps, this web application will be using MySQL.
Now I need to replicate my client's Oracle database into MySQL, only a few tables will be involved.. a table can be up to 2-3 ...
- 631