The process and means of extracting data from a database for use elsewhere.
2
votes
2answers
611 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 ...
8
votes
2answers
2k views
Script out Oracle DDL in an automated fashion
Oracle SQL Developer is able to export DDL through Tools -> Database Export... This works very well, but requires manual intervention.
I know of DBMS_METADATA.get_ddl(), but have found that the ...
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
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
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
442 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 ...
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 ...
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
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 ...
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, ...
6
votes
2answers
2k views
How to extract Procedure, Function, etc. Source Code from an Oracle Export
I have generated an EXPDAT.DMP file of an Oracle database with the command:
exp userid=usr/pass@db owner=own rows=n compress=n
I then ran the following command to generate a file containing the ...
6
votes
4answers
12k views
How can I unload Oracle database tables into a csv files?
I need to retrieve certain data from an Oracle 11g release 1 database and provide it as one or more CSV files. The data resides in multiple tables and/or views. All this should work via the command ...
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 ...
