Tagged Questions
0
votes
0answers
50 views
How to clone a database from one environment to a database on another environment?
OS: RHEL
DB: Oracle 11g version 11.1.0.7.0
I am trying to clone a database on one environment (environment A) to another database on a separate environment (Environment B). Environment B's database ...
0
votes
1answer
37 views
Exporting and importing a database
I have setup an Oracle 11g Database and have a question about exporting and importing a database.
I am using Enterprise Manager and have browsed to the following: Data Movement->Export to Export ...
1
vote
2answers
92 views
MySQL export user with semi-colon “;” on the end
I am trying to set up automatic export of user accounts from one server to import into another. I am running the following command;
$ mysql -u root -p -B -s -e "show grants for 'myuser'@'localhost';" ...
0
votes
4answers
116 views
which one is the fastest way of moving database form local to live server in sql server
I am using SQL Server 2008, I have big database almost 500 MB of data there. Now I wanted to upload or deploy this DB to Live server. Currently I am generating script and then uploading script to live ...
1
vote
1answer
136 views
Imports & exports under storage constraints and preallocations
I have a 5GB oracle database that I want to export and then import on my own local database. Easy right?
The point is, I use oracle XE 10g which allows me to use up to 4GB. I then decided to make the ...
1
vote
1answer
163 views
How to restrict MySQL user to not import and export database
I have created a read only MySQL user but this user have an option to export the database through phpmyadmin. How can I disable the options Export and Import?
1
vote
1answer
125 views
PG_bulkload utility postgresql need help
i am using COPY command to export the data to the out file with changes made to the data before export using option ST_asBinary() using command
COPY (
SELECT st_asBinary(geom) FROM n_america
) TO ...
0
votes
2answers
1k views
oracle 10g xe to 11g xe upgrade
The oracle 10g DB that is being currently used has exceeded the limit of 4GB. For the application to continue the db needs to be upgraded to 11g. But the upgrade doc requires a data pump export to be ...
4
votes
4answers
560 views
Exporting\Importing a large MySQL data without mysqldump
I'm attempting to export about 150GB of data from a database with hundreds of tables, and have found mysqldump to be very buggy.
After running a simple --all-databases dump succeeds, but the import ...
3
votes
2answers
371 views
Import and Export database in Mongo just like MySQL
I am newbie to the Mongo.Before this I have worked only with MySQL.In MySQL we can import and export database easily.I want to know is there any option available in Mongo to import and export database ...
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 ...
0
votes
1answer
588 views
Import .pde file on PL/SQL Developer
How can I import my .pde file which I already exported from another database by PL/SQL Developer?
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 ...
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
558 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
989 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.
...
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 ...
