OraFAQ Forum: Server Utilities » Import from multiple files

Home » RDBMS Server » Server Utilities » Import from multiple files (Oracle 11G standard edition, Windows OS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import from multiple files [message #441521]

Mon, 01 February 2010 15:37

jsundaram
Messages: 2
Registered: February 2010

Junior Member

I am new to Oracle import/export side and have 5 data dump files provided by the client. I would need to import them into oracle 11g database. The files are located in an external hard drive. 1. How do I specify the file locations and the multiple files?
2. Can the database files also be moved to the external hard drive? I am short on space on the machine I am working from.

Thanks!

Report message to a moderator

Re: Import from multiple files [message #441535 is a reply to message #441521]

Mon, 01 February 2010 16:25

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>1. How do I specify the file locations and the multiple files?
yourDrive:\fileName.dmp

2). You do not want to do that.

Report message to a moderator

Re: Import from multiple files [message #441537 is a reply to message #441535]

Mon, 01 February 2010 16:35

jsundaram
Messages: 2
Registered: February 2010

Junior Member

Thanks Mahesh. Would the accessing speed be a problem if I move the data files to an external harddrive? I have only 80 GB left in the machine Im working and the dump files are 125 GB. I would assume that the database size after import would be atleast 125 GB. I have an external 1 TB harddrive. I was thinking of moving the datafiles over to that so that I'll have sufficient space to work.

Report message to a moderator

Re: Import from multiple files [message #441538 is a reply to message #441537]

Mon, 01 February 2010 16:42

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>I was thinking of moving the datafiles over to that so that I'll have sufficient space to work.
Then what is going to happen to those files?
If this database is of any business importance, I would not do it.
External drives are not meant to be database storage.
Do it at your own risk.

Report message to a moderator

Previous Topic:	import of indexes using impdp
Next Topic:	can we do import like

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 01:44:34 CDT 2024