Oracle 10g tablespace creation authorization, automatic backup, recovery

To create a tablespace, you must first have the database orcl plsql tool to create an SQL window for execution.

1. CreateTablespace orcl_tablespace datafile'D: \ Oracle \ product \ 10.1.0 \ oradata \ orcl \ orcl_data.dbf' Size1000 M;
2.  -- Create the default tablespace for the manager user on the orcl Database
3. Create UserManager identifiedByManager126DefaultTablespace orcl_tablespace;
4. -- Authorization
5. Grant Connect, ResourceToManager;-- Grant the connection and resource permissions to the manager User.
6. GrantDbaToManager;-- Grant the dba administrator permission to the manager User.

Automatic oracle Database Backup

With the simplest backup method, the job in window is scheduled to be backed up once a day.

Create a new. bat file on disk D and write the following command:

Exp manager/manager126 @ jx file = d: \ database \ % date :~ 0, 10%. dmp log = d: \ database \ % date :~ 0, 10%. log

Parameter description

Exp username/password @ Database Service name file = file storage path \ current date. dmp log = log storage path \ current date. log

The bat file added to the task plan of the window system tool will be automatically backed up.

Import the oracle database using the imp command on the cmd Terminal

Import the whole database imp user name/password file = file storage path full = y

Import a table imp user name/password file = file storage path tables = table name