All Questions
7
votes
0answers
160 views
Get and Put performance testing on Google BigTables (and other integrated DBs)
What are some effective ways to perform programmatic performance testing on database operations, especially in environments where the databases themselves do not offer dedicated tools?
For example, ...
3
votes
0answers
26 views
bcp database migration
I want one server to migrate the database to another server. On another server database already exists, then ist all the tables, but they are empty and I want to fill. For the filling, I want to use ...
3
votes
0answers
92 views
No NULLs, yet invalid byte sequence for encoding “UTF8”: 0x00
I've spent the last 8 hours trying to import the output of 'mysqldump --compatible=postgresql' into PostgreSQL 8.4.9, and I've read at least 20 different threads here and elesewhere already about this ...
3
votes
0answers
113 views
Design for file based with many events
I'm not a database guy but I need to design a database to store events for our application. Our client app connects to remote hardware and syncs count data. The count data are csv files split into ...
3
votes
0answers
167 views
Which workarounds exists to missing relative path feature of SQLCMD :r?
I'm not the first to notice the lack of this feature.
But I wonder if there are some useful workarounds.
I want to deploy a main script and some depended scripts in the same folder.
BTW Is there a ...
2
votes
0answers
16 views
Tracking SQL queries and rows operated on for documentation/audit
Is there a way to record the SQL queries (and rows that were acted upon) in a session for documentation/audit purposes?
For example, in deleting duplicate rows from a table I use the following SQL ...
2
votes
0answers
91 views
MySQL encryption
I am thinking about encrypting some fields in MySQL database using MySQL's encryption functions. I can't find any good sources on how to properly implement it. Has anyone done this and have a good ...
2
votes
0answers
307 views
Backup and Restore Strategy for Oracle SOA/Weblogic Suite
I have deployed Oracle SOA Suite and WebLogic on 8 machines and Oracle RAC on 2 machines. The servers are managed through an Enterprise Manager.
My objective is to have a backup strategy that can ...
1
vote
0answers
12 views
Using PL/PerlU with a non system perl lib
psql -1f check_email.pl.sql ccushing postgres
SET
psql:check_email.pl.sql:7: ERROR: Can't locate Email/Valid.pm in @INC (@INC contains: /usr/lib/perl5/site_perl /usr/share/perl5/site_perl ...
1
vote
0answers
56 views
Oracle 11g + SOA - Stalled instances
This is sort of a last-ditch effort. We have Oracle SOA running, and nearing the point where we're taking it into production. I've posted on OTN and talked to numerous folks at Oracle about this ...
1
vote
0answers
30 views
Can't find location of undo *.tuf file
I run SQL Server 2000. Database is in standby mode. I have multiple files with MyDb.tuf name on a different drives. How may I know which one is in use?
1
vote
0answers
25 views
Create incremental/differential backups in ProgressDB
Is there a way to create incremental/differential backups in ProgressDB?
1
vote
0answers
22 views
Question on Oracle database table compress option?
How come a compress enable table (name as ABC) when created (Oracle 11g R1), but after merging with a partitioned table's partition with data which is not compressed, then the table (ABC) auto ...
1
vote
0answers
19 views
May I Convert Non RAC db to an RAC DB and add on a Node?
Currently my work env as 1 node none RAC database 11gR2, we are getting another machine (Linux), so I need to add on this node to our currently env and becoming a RAC db. What is the best way/route to ...
1
vote
0answers
106 views
Fatal NI connect error 12170
Getting TNS timeout error when trying to run a jdbc application against an oracle 11.2.0.1.0 database.
Driver used : ojdbc6. JDK : 1.6_06
I've tried increasing the connect_timeout sqlnet parameter, ...
