Skip to content

Instantly share code, notes, and snippets.

@chepecarlos

chepecarlos/ParcialDB2.sql

Created July 5, 2012 13:33
Show Gist options
  • Save chepecarlos/3053682 to your computer and use it in GitHub Desktop.
Save chepecarlos/3053682 to your computer and use it in GitHub Desktop.
Download ZIP
Parcial de DB2
Raw
ParcialDB2.sql
create tablespace parcialdb2
logging
datafile 'h:/data/parcialdb_2.dbf'
size 64m
autoextend off
create user parcialdb2 identified by
donbosco
default tablespace parcialdb2
grant dba to parcialdb2
exp hr/123456 file=d:/data/lila.dmp tables=countries query=\"where country_name like 'A%' \"
imp parcialdb2/donbosco file=h:/data/lila.dmp fromuser=HR touser=parcialdb2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment