Tagged Questions
0
votes
1answer
25 views
“relation does not exist” trying to import mysql dump into postgres
environment:
ubuntu 10.04
mysql server 5.1.69
postgres 9.2
Here's the sequence of steps:
created a new postgres database, myDatabase
executed this command: mysqldump -u root -p ...
3
votes
3answers
83 views
Fixed length text file insert into SQL table
I am not a DBA on this one and I will not have access to BCP or anything like that. So I'm wondering if there is still a way to do it in SQL keeping it very basic.
I have 100's of text files that ...
2
votes
2answers
852 views
Materialized View does not import properly when importing a db for a second time in another schema
When I import a database with materialized view mv_mt in just one schema I get no errors.
create materialized view mv_mt
refresh complete
next trunc( sysdate ) + 1
as
SELECT sysdate, media_type.*
...
1
vote
1answer
465 views
Error while importing a “.sql” file in database
I am trying to import a .sql file in to my local database. whenever i type the command to import the file, I get an error ERROR at line 1: Unknown command '\S'.
This is the first line of the sql file ...
0
votes
1answer
121 views
Sensible data management tool for importing and exporting of large data files
I am looking for some sensible suggestions on data management tools for large data files.
I have been experimenting aith excel and access only to find that access has limitations on import files size ...
