SQLPlus Database Import/Export Guide
Translated by
ScribdTranslationsSQLPlus Database Import/Export Guide
Translated by
ScribdTranslationsAUTONOMOUS UNIVERSITY OF THE STATE OF MEXICO.
UAEM ATLACOMULCO UNIVERSITY CENTER.
BACHELOR'S DEGREE IN ADMINISTRATIVE COMPUTER SCIENCE.
LEARNING UNIT:
RELATIONAL DATABASES.
PRACTICE No. 8:
EXPORTING AND IMPORTING A DATABASE USING SQLPLUS
TEACHER: L. I. A. ELIZABETH EVANGELISTA NAVA.
ESTUDIANTE: OMAR ARANA TORRIJOS.
GROUP: I-9.
PERIOD: 2015–B.
Atlacomulco, Mexico on November 13, 2015.
INTRODUCTION
The tools (DML, DDL) provided by the Oracle DBMS are essential.
through the use of SQL PLUS, in such a way that DML interacts to modify,
query, delete the information, and therefore DDL allows creating objects in the
database and visualizing it in the data dictionary. The student will put in
practice your knowledge to import and export the database through the
command line (MS-DOS), Connecting the offline database, verify the
operation of what has been done. To carry out the practice, a team was used
64-bit architecture computing, with Windows 7 operating system, and Oracle software
Database 11g xe, completed in an estimated time of 2 hours.
DEVELOPMENT
1. Access the command prompt (cmd) and start SQLPLUS without a connection.
(image 1.1).
2. Connect as SYS/ORACLE AS SYSDBA, creating a user named
ARANATORRIJOS, assign password ARANATORRIJOS (image 1.2).
3. Provide various permissions (image 1.3).
4. Then connect with the user ARANATORRIJOS (image 1.4).
5. Select the rows and you will notice that no rows are selected.
(image 1.5).
6. Create a table called key and visualize again (image 1.6).
7. Next, create five records using the INSERT INTO statement.
CLAVES VALUES <1,’LUCIA’>;(imagen 1.7).
8. Visualize the content we inserted (image 1.8).
9. Open a new session and create a user named BACKUP repeat
again the steps (image 1.9).
10. Once you have created your users, press quit and exit to exit. Proceed to export.
the database opens a new terminal with cmd and creates a directory in the
that you will save the database in this case the path is D:\oradata\bkp.
(imagen 2).
11. Assign read and write permissions to the user ARANATORRIJOS, repeat
this procedure for the user BACKUP (image 2.1).
[Link] to the user ARANATORRIJOS and observe the tables and
its content, for this case there is only one table called KEYS, it contains
5 records (image 2.2).
[Link] EXIT to exit and now export the database called ARANATORRIJOS
(image 2.3).
14. Check the location of the file, you can search for it with the toolbar.
browser as shown in the following figure (in addition to this on the line of
command you can give a dir in the same path where you executed the command
export) images 2.4-2.5.
15. Delete the tables of the user ARANATORRIJOS, and observe the fields of the tables
by DESCRIBE TABLE NAME (image 2.6).
16. Delete the table using DROP TABLE table name (image 2.7).
17. Proceed to re-import the key tables, check their functionality
to finalize (image 2.8).
CONCLUSION
The Oracle Database 11g xe DBMS allows the development of excellent mechanisms that
they generate correct results in a timely manner, favoring the work for
user's part, as well as the systematization of the information that is recorded
through the interpretation of SQL statements for the purpose of manipulation of
the data stored by the administrator ensuring at all times
the security.
REFERENCES
Jean F. (2011).Administración de Bases de Datos. Ed. Trillas segunda edición.
Ramos, Martín Alicia, Montero, Rodríguez Fernando. (2006). "Management systems of
databases: Teaching guide. Madrid, Spain: McGraw-Hill.
Evangelista, Nava Elizabeth, García, Morales José Luis. (2015). "Practice Manual
Basic with SQL. Atlacomulco Mexico.
Jara Leal Gerardo. Database Management Systems Administration (1st
Mad Editorial.
Muñoz Chaparro, Antolín (2011).Oracle 11g SQL: Curso práctico de formación.
Madrid.