Oracle Database/Managing Data

From Wikibooks, open books for an open world

< Oracle Database

Jump to: navigation, search

Contents

1 Manipulating data through SQL using INSERT, UPDATE, and DELETE
2 Using Data Pump to export data
3 Using Data Pump to import data
4 Loading data with SQL*Loader
5 Creating directory objects

Manipulating data through SQL using INSERT, UPDATE, and DELETE[edit]

Using Data Pump to export data[edit]

Using Data Pump to import data[edit]

SQL Dump should either Exports in CSV or Plain SQL Format.

Loading data with SQL*Loader[edit]

Creating directory objects[edit]

Retrieved from "http://en.wikibooks.org/w/index.php?title=Oracle_Database/Managing_Data&oldid=2425202"

Oracle Database