I've created a GUI application in java. Where I've created a database name StudentDb and table student_db. I want to export this database in such a file format using java code that when I'll take this ...

I'm looking for a solution to export a number of schemas from Oracle to ASCII or other flat file format. The data then has to be read by DB2 import. Does anyone know the what oracle export commands ...

I am out of my depth a bit perhaps but submit this query hoping someone has some experience importing large (11.2GB) tab delimited text file (2.2GB tar.gz file) into either MySQL 5.5.41 or PostgreSQL ...

Using MySQL server version: 5.0.51a
I have a backup of a database (.sql file) in my local machine. It is a 36Gb file. And I need to restore this to a database residing in a server, which is exactly ...

My table has 981 million rows and is about 30GB large. It is six columns: ID, Ticker, Date, Time, Price, Volume. The data was in text files and using LOAD DATA INFILE was actually quite painless and ...

I have a Fox Pro database (one DBC and a bunch of DBF files) that I want to import into SQL via the Import and Export wizard.
I downloaded the FoxPro ODBC driver. I managed to get to the screen that ...

I am trying to import a postgresql database table sent to me in phpPgAdmin, I am following the instruction from this import database
But after doing so, several error appear, I also tried to import ...

When i am importing some tables in my database, the temporary tablespace is getting full. This never happened earlier for other tables.
Please help me know why this is happening and any solution for ...

There is an existing database that was created in Informix. I would like to export it and then import it into MySQL.
I tried to export it using dbschema and it created the dbase.sql file and several ...

I have a requirement to export / extract certain rows (matching some query) of some tables from one oracle database and import those rows in the respective tables of other database.
both source and ...

I am working on a project that involves importing data via Apex's data workshop. Two of my columns contain dates in the format YYYY-MM-DD HH:MI:SS. Can anyone tell me how to get Apex to import these ...

The original data pump file is generated by the schema which living in two tablespaces(OLD_SCHEMA_DAT and OLD_SCHEMA_IDX), if import back to the original tablespace, everything is fine, but when I use ...

I have a file that is a flat text file that needs to be imported into my SQL Server every day. The problem is that I have to wait for someone else to download and place the file before I can import ...

Recently, I received a lot of information from one of my friends who made a quiz type program. He asked me to help port it into an Access database.
His program places all the info in a grid; around ...

I have a database that is comprised of ~10 tables, most of which have many-to-many relationships with each other (and an associated join table). I am inserting of the order 100k XML files into a raw ...

I'm trying to import our CSV data log into our MySQL.
The first two fields of the CSV are Date and Time, and I would like to combine that into one date time (which can be searched) onto MySQL.
CSV:
...

I am using SQL Server 2014 Management Studio to import a very large .CSV file into a table.
So far I have been trying to accomplish this by right-clicking on the database and selecting Import Data, ...

I am somewhat new to mysql. I created some databases recently and, to back them up, I just copied the folders with those database names in the mysql data directory (i.e containing only db.opt, .frm, ...

I'm creating an Access database from an excel file that contains metadata about vhs tapes and DVDs. The person who created the excel file had the running times as a date/time field in minutes:seconds. ...

I know about LOAD DATA INFILE command -- however, this requires that we already have the table with appropriate columns in place. When I have csv with hundreds of columns, it is not feasible to type ...

I have a database with an integrated ledger for a multi-unit company.
As we bring new units into the database we load their existing ledger data into ours.
Unfortunately the existing procedures on the ...

I am aware that Oracle Ent Ed (EE) has more functionality than Oracle Express Ed (XE). But I would like to do a FULL export from EE to XE. Is this even possible? The only solution I can assume will ...

I've been given an oracle DMP file that was created on a solaris system which I need to restore to a windows system.
I've created the DB with the correct blocksize, but when I try and do the restore ...