由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - how to run this script
相关主题
Oracle 11g下,如何創建兩個schema,並且转Oracle DBA,求建议
Oracle 8i export and import ?oracle求助
tablespace是个啥样的概念啊?oracle里有些怪怪的表,不只是哪里来的?
Do you do migration/release?how to know how many uses exists in my db?
how to using sql generate sql statements?create database 在oracle中有什么用处?
请教,如何单步调试sql script?question: how to drop a tablespace
oracle script outHelp: 如何在oracle 9i 中添加1 个user?
dba们,你们学的data structure,operating system在工作中用到了吗?[转载] question on SQL
相关话题的讨论汇总
话题: script话题: unix话题: run话题: file话题: toad
进入Database版参与讨论
1 (共1页)
y*h
发帖数: 107
1
我有个dump file, under my UNIX directory.
In addition, 我的co-worker gave me a script for dump file:
Imp ADAS_PROD_SUP/password file= fromuser
= EU_MAP_082L5 touser= ADAS_PROD_SUP grants=y

我是DATABASE新手. Could someone tell me how to run this script? like
under unix or oracle interface should I type the script ? where to upload
dump file? BTW: I have SQL-plus, toad, UNIX installed.
谢谢
B*****g
发帖数: 34098
2
unix shell
or
Data Pump Import Wizard
Note: This Toad feature is only available in the commercial version of Toad in either the Professional Edition or with the optional Quest DBA Module.
The Data Pump Import wizard lets you use easily use Oracle's Data Pump to import data into the database on a large scale.
There are five import modes to the Data Pump:
• Full Import
• Schema
• Table
• Tablespace
• Transportable Tablespace
The Toad wizard supports all of these, and

【在 y*h 的大作中提到】
: 我有个dump file, under my UNIX directory.
: In addition, 我的co-worker gave me a script for dump file:
: Imp ADAS_PROD_SUP/password file= fromuser
: = EU_MAP_082L5 touser= ADAS_PROD_SUP grants=y
:
: 我是DATABASE新手. Could someone tell me how to run this script? like
: under unix or oracle interface should I type the script ? where to upload
: dump file? BTW: I have SQL-plus, toad, UNIX installed.
: 谢谢

j***a
发帖数: 10844
3
Which version of Oracle are you running?
Looks just run the scrip as it is:
imp ........

directory.
fromuser
like
upload

【在 y*h 的大作中提到】
: 我有个dump file, under my UNIX directory.
: In addition, 我的co-worker gave me a script for dump file:
: Imp ADAS_PROD_SUP/password file= fromuser
: = EU_MAP_082L5 touser= ADAS_PROD_SUP grants=y
:
: 我是DATABASE新手. Could someone tell me how to run this script? like
: under unix or oracle interface should I type the script ? where to upload
: dump file? BTW: I have SQL-plus, toad, UNIX installed.
: 谢谢

1 (共1页)
进入Database版参与讨论
相关主题
[转载] question on SQLhow to using sql generate sql statements?
How to creat user in Oracle?请教,如何单步调试sql script?
Export Oracle db schema onlyoracle script out
问个RMAN问题dba们,你们学的data structure,operating system在工作中用到了吗?
Oracle 11g下,如何創建兩個schema,並且转Oracle DBA,求建议
Oracle 8i export and import ?oracle求助
tablespace是个啥样的概念啊?oracle里有些怪怪的表,不只是哪里来的?
Do you do migration/release?how to know how many uses exists in my db?
相关话题的讨论汇总
话题: script话题: unix话题: run话题: file话题: toad