Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Getting Oracle backup into SQL Server Expand / Collapse
Author
Message
Posted Thursday, August 6, 2009 12:46 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, August 4, 2014 12:38 PM
Points: 417, Visits: 1,147
Are you sure the backup was taken using Oracle Export utility?
Post #766479
Posted Thursday, August 6, 2009 1:17 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 8:21 AM
Points: 428, Visits: 940
I've initiated an inquiry.
I'll respond when I get an answer.
I hope they're not on holidays...

Thanks for the help so far.



Post #766506
Posted Tuesday, August 11, 2009 10:06 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 8:21 AM
Points: 428, Visits: 940
It turns out it was done with the Oracle export utility.




Post #768775
Posted Tuesday, August 11, 2009 10:49 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, August 4, 2014 12:38 PM
Points: 417, Visits: 1,147
Try the import and let us know how it goes. Good luck.
Post #768810
Posted Tuesday, August 11, 2009 12:19 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 8:21 AM
Points: 428, Visits: 940
Failed:

VNI-2015 : The Node preferred credentials for the target node are either invalid or do not have sufficient privileges to complete the operation.
On Windows platforms, the Node credentials specified for the Windows target
should have the "Logon as a batch job" privilege.

I am running on Win2K3. Where do I find Preferred Credentials and set that privilege?



Post #768869
Posted Tuesday, August 11, 2009 12:42 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, August 4, 2014 12:38 PM
Points: 417, Visits: 1,147
I'm not too familiar with that error. I found a thread that may have a solution:
http://forums.oracle.com/forums/thread.jspa?threadID=326832.

If you are using OEM, I would instead use the command line import.

You may also want to open a thread in an Oracle Support site such as DBASupport.com at: http://www.dbasupport.com/forums/forumdisplay.php?f=1
Post #768885
Posted Wednesday, August 12, 2009 10:55 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, July 24, 2014 3:52 AM
Points: 470, Visits: 705
rlondon (8/11/2009)

If you are using OEM, I would instead use the command line import.


I agree that it would be simpler to use the command line. Alter the database from mounted to open and try this:

imp.exe userid=sys@test file=h26b_full.Mar04 log=h26b_full.Mar04.txt show=y rows=n

(You will be prompted for the "SYS" user's password.) This will not actually import data, but it will create a text file showing you what it is in the export. The filename implies that it is a full database export - you might not want all of the users/schemas (in Oracle these are the same thing) that are in it.

If it is a full export you will need to create the user account(s) aka schema(s) in Test before import. Say you only want the "ACCOUNTS" user/schema, you could then import it like this:

imp.exe userid=sys@test file=h26b_full.Mar04 log=accounts.imp.txt fromuser=accounts

("imp.exe" is in "c:\oracle\product\10.2.0\client_1\bin" or similar, depending on your installation.)

This link might be helpful: http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#sthref2573

HTH
Post #769511
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse