The process and means of extracting data from a database for use elsewhere.
4
votes
2answers
4k views
Oracle - Automate Export/Unload of Data
Oracle SQL Developer has an option to export the contents of a query result to various formats (CSV/fixed width/Excel/XML). Is there any way to automate it?
If not, what free tools are available ...
3
votes
1answer
5k views
Create dump file using Oracle SQL Developer
I think I'm missing a simple point, but I couldn't find a way to use Oracle export (exp/expdp) and Oracle import (ipm/impdp) with Oracle SQL Developer (version 1.5.5)? Is there a way for it?
If ...
1
vote
2answers
1k views
how to Export a document contain tables name, columns names and column description from SQL Server 2008?
I created a db in sql server 2008 and I wrote for some columns description to describe them, What I want now is to find a way to export these tables design including the description for each column ...
2
votes
1answer
586 views
Oracle imp crashes without error
I have Oracle 10g XE database locally. I export schema with something like
exp %USER%/%PASSWD%@XE statistics=NONE owner=%USER% file=dump.dmp
Exp is 10.2.0.1.0 version - so is the DB.
Than I take ...
2
votes
2answers
613 views
Oracle 10g XE GUI
I've designed a database on Oracle 10g xe (Windows Platform) and I want to export the tables I created in a sql file. I've googled all night and didn't find anything. I also tried to install a Windows ...
1
vote
1answer
331 views
How to setup daily SQL server export to csv text file?
We are exporting 100,000+ rows from a SQL Server 2005 DB to a text file. We have a web script setup to read all rows and then write the text file and it takes over 5 minutes to complete that script.
...
3
votes
2answers
2k views
Export Oracle tables based on owner + all users from database
I would like to export all user and roles objects from Oracle 10g database to another.
I googled it but I cannot find out how to do it.
First I use this command:
exp system/root@[DB_Name] ...
2
votes
1answer
1k views
Eliminate database fragmentation (export, drop and re-import tables)
I have one datafile that is highly fragmented. Its size is 10GB now and real size that is used is 2.5GB,so 7.5 is free.
I decided to export data, drop that datafile, recreate it and import data.
...
1
vote
2answers
444 views
Access exporting to CSV is weirdly slow
I have searched but could not find anything similar. If I just run the query, I can get the result pretty quickly (~5 mins); but after I saved the query to export as CSV, the exporting part is ...
2
votes
3answers
308 views
What's the easiest way to re-format CSV exports from MySQL into Excel/ flat-file fields?
I've just had some database backup problems on a website I run containing some important lead data. Unfortunately, I've now lost one of the key MySQL tables, which means my data has lost its ...
7
votes
1answer
3k views
Does mysqldump export indices, by default?
I played around a little with mysqldump and I was wondering, if it does export indices (FULLTEXT, INDEX,...) by default. I read up on it and I found this option:
--disable-keys, -K
which suggests, ...
5
votes
2answers
1k views
Is it possible to backup and restore part of a database in sql-server?
We have a sql-server 2005 database that we regularly transfer from our client site to ours. This takes a long time because we don't have a direct connection and have to transfer the file over their ...
4
votes
2answers
4k views
How to export a single huge table from SQL Server?
I'm given the task to export the content of a huge table from a production database and to import the data into a database at a remote location.
The Table has about 45,000,000 rows. using about 4 GB ...
4
votes
2answers
984 views
EXP-00085 warnings while doing full backup
During a full export of my Oracle 10.2.0.2 database, I encounter the following warnings
[...]
. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 6502 encountered
...
5
votes
3answers
661 views
How can a datapump export have its resource usage limited on windows?
Doing an export of a number of users causes high CPU and I/O usage. I can mitigate the effects of the CPU usage using Resource Manager and setting the export session to a low priority group, but how ...
8
votes
1answer
285 views
How can a datapump export have its resource usage limited on linux?
Doing an export of a number of users causes high CPU and I/O usage. I can mitigate the effects of the CPU usage using Resource Manager and setting the export session to a low priority group, but how ...
