2
votes
1answer
156 views

Microsoft SQL alternative for Oracle's Imp and Exp command

I'm looking a command line tool or SQL command to export/import a table or complete database. Much like the imp and exp commands of Oracle databases. Any suggestions?
0
votes
2answers
402 views

Microsoft SQL alternative for Oracle's Imp and Exp command [duplicate]

Possible Duplicate: Microsoft SQL alternative for Oracle's Imp and Exp command I'm looking a command line tool or SQL command to export/import a table or complete database. Much like ...
3
votes
2answers
556 views

How to handle one-way synchronization of two Oracle databases with no network connection?

Here's the situation: I have two Oracle 10g databases (with the same tables, etc.) that cannot be connected by network. At some regular intervals (say, once a day) I need to be able to update the ...
1
vote
8answers
10k views

Oracle 11gR2 exp does not export some tables

I have an Oracle 11g (11.2.0.1) Database running on Linux (x64). Within the database I have a schema and 33 tables for it (all in the same tablespace). When I log in via sqlplus I can list all the ...
1
vote
2answers
690 views

export from Oracle into SQL Server/mySQL

I have an Oracle database which we will be removing shortly. But I would like to store some of the data somewhere else so if can be accessed if required. Is there a standard/recommended method of ...
0
votes
2answers
488 views

Importing oracle dump file, getting error on stored procedures

I export an oracle "schema" using exp userid=/ file=pt.dmp log=pt.log owner=FOO buffer=10000000 statistics=NONE direct=Y and then import it into a different schema on the same oracle instance on ...
1
vote
3answers
4k views

Oracle export failed: EXP-00006: internal inconsistency error

My call to Oracle's exp is failing with: EXP-00006: internal inconsistency error EXP-00000: Export terminated unsuccessfully The command I execute is C:\oracle\product\11.1.0\db_1\BIN\exp ...
1
vote
1answer
2k views

Export/Import on different versions of Oracle

I was wondering, where can i find a step-by-step guide on how to export from a higher version (11g) to a lower version (9i and 10g) of oracle database? Thank you very much!