0
votes
1answer
74 views

Prevent UNDOTBS to abort import

I have a dumpfile that I want to import in an Oracle 10g database in a virtual machine (with limited disk space). The dump file is about 3.5GB. When I try to import the dump, the size of the ...
0
votes
1answer
106 views

Oracle Import Dump [closed]

After system failure I have bought a new server and now Im trying to recreate the oracle database I had. I have a dump file which was made with the command exp and full=y. So can I restore the full ...
0
votes
1answer
178 views

Where to create directory for importing over network link?

While using data pump import over network link in Oracle: impdp test/test@db10g tables=SCOTT.EMP network_link=REMOTE_SCOTT directory=TEST_DIR remap_schema=SCOTT:TEST Where are we creating ...
1
vote
2answers
860 views

Oracle import fails due to NLS_DATE_LANGUAGE setting

I have an Oracle 10 database server and a dump created on another Oracle 10 server. When using the imp command to import the dump to the database: imp 'sys/*** as sysdba' file=c:\[...]\strukt.dmp ...
2
votes
3answers
10k views

How do I make imp use right charachter set?

I am trying to import a dmp file from one database to another. The problem is that some special danish characters are not imported right because some character map conversion is done during import. ...
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 ...
0
votes
1answer
181 views

Does Oracle DB has a tool like DTS Wizard in SQL Server?

Is there a tool like the Microsoft SQL Server's DTS (Data Transformation Services) Wizard that simplifies the process of ad-hoc importing of flat files (CSV, TSV, or XLS) to Oracle database? ...
3
votes
1answer
143 views

Need simple graphical interface for Oracle IMP utility

the company receives several Oracle database dumps from clients for analysis. My programmers are not Oracle literate and find it difficult to restore the dumps using the IMP utility. They need a ...
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 ...
0
votes
2answers
645 views

Oracle Database Recovery Problem

I am very new to Oracle, and trying to restore a oracle 8i database on win 2000 server. I have one week old database backup (backup taken with exp command), and i want to restore it now. Now I am ...
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
2answers
68 views

How do I re-execute a skipped section in Oracle Data Pump?

I did a start_job=skip_current on a large import because I thought it was hanging on some bad data. It turns out it was just a really large index so I'd like to re-run it but I don't want to do the ...
2
votes
1answer
527 views

Oracle DB import error

I get the error below when importing a database - any ideas why? I do this type of import all the time and I've never seen this error. Prior to doing the import we drop all objects in the schema. ...