Oracle Guide library, modifying database files

a while ago, to do Oracle restore of the database. Because it's a rookie, I didn't use oracle database. So many places do not know how to start.

in the SQL Server database restore, nothing more than an additional database . Or use a script to restore it.

but in Oracle in the database restore, there is no such visual tools (self-installed client does not count). after the Oracle Server is installed, the restore of the database must use dos command-line operations.

Oracle do not understand, the company has no net. Then learn how to guide the library by simply losing the traffic on the phone.

......

After unremitting efforts, finally can be imported.

You can import it, but you haven't finished importing it yet. Next, the following error occurs ...

Reason:

When creating a database file, the upper limit is set or the memory is low.

I create a space when the command:

Create database datafile ' D:\dbCompany.mdf ' autoextend on next 50M maxsize 2000M

Solution:

Modify the space size to remove the limit of the space limit.

Alter database DataFile  

The command to create the file is the one they gave, but the command was enough for his library. Given me , I will apply it?? Others give only a template, we can take it as a reference. Just take it and you have to weigh it.

Oracle Guide library, modifying database files