Export in oracle

Data Loading Methods Several methods are available for loading data into tables in an Oracle database. Of the methods available, Direct Load insert and SQL*Loader are discussed here. Export and Import are covered in the Oracle9i Database Administration Fundamentals II course. SQL*Loader SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that places little limitation on the format of the data in the data file. Direct Load Direct Load insert can be used to copy data from one table to another table within the same database.

40p trinh02 28-01-2013 69 5   Download

Để import và export database cần phải có quyền CREATE SESION role in CONNECT role(chỉ trên Schema thuộc user đó). Nếu muốn Export hoặc Import Schema của user khác bạn cần có quyền EXP_FULL_DATABASE hoặc IMPORT_FULL_DATABASE Để import và export database cần phải có quyền CREATE SESION thuộc quyền CONNECT Các Schema dành riêng không thể EXPORT được ORDSYS MDSYS CTXSYS ORDPLYGINS LBASYS

32p trinh02 28-01-2013 105 11   Download

Creating Databases Oracle Databases can be created either using the Database Configuration Assistant or a CREATE DATABASE statement. Using the DBCA is easier. Creating the database manually requires careful planning. Additional actions such as creating new users, tablespaces and data dictionary tables have to be performed in case the database is created manually. To create the database: Make sure that there is sufficient memory and disk space. Specify Oracle SID. $ ORACLE_SID = slx_db01; EXPORT ORACLE_SID; Create initialization parameter file by copying sample parameter file init.ora.

20p thachcotran 04-02-2010 132 33   Download