KARAF / karaf star
2023-01-25
Open
#30 오라클 사용자 데이터 Export / Import, exp, imp star
2023-01-25 Open
KKoZZi @admin
Tasks

1. Export Data#

export NLS_LANG=KOREAN_KOREA.UTF8
exp userid=testuser/test1234 full=y file=expdata.dmp

2. Import Data#

export NLS_LANG=KOREAN_KOREA.UTF8
imp userid=testuser/test1234 file='/home/oracle/tmp/expdata.dmp' fromuser=testuser touser=testuser
Issue Sharer
Comment 1
  • Added KKoZZi added
    oracle
    label 2023-01-25
  • SSEMIYA
    admin KKoZZi 2023-01-25 Reference in new issue
    • Markdown help
    • Header
    • Text Style
    • Link
    • List
    • Checklist
    • Image
    • Blockquote
    • Code
    • Table
    • Short Link
    • Markdown Input
      Markdown Output
      # This is an H1
## This is an H2
### This is an H3
      # This is an H1 ## This is an H2 ### This is an H3
    • Markdown Input
      Markdown Output
      *This is an italic*
**This is an bold**
~~This is an strike~~
      *This is an italic* **This is an bold** ~~This is an strike~~
    • Markdown Input
      Markdown Output
      [Site](http://yobi.io/ "Yobi Site")

http://yobi.io/
      [Site](http://yobi.io/ "Yobi Site") http://yobi.io/
    • Markdown Input
      Markdown Output
      - Red
    1. White
    2. Blue
- Green.
      - Red 1. White 2. Blue - Green
    • Markdown Input
      Markdown Output
      - [ ] Todos
    - [x] To do A
    - [ ] To do B
    - [ ] To do C
      • Todos
        • To do A
        • To do B
        • To do C
    • Markdown Input
      Markdown Output
      ![title](https://repo.yona.io/assets/images/ico-like-small.png "Yobi")
      ![title](/assets/images/ico-like-small.png "Yobi")
    • Markdown Input
      Markdown Output
      > Lorem ipsum dolor sit amet, consectetuer adipiscing elit.
>
> Aenean commodo ligula eget dolor.
      > Lorem ipsum dolor sit amet, consectetuer adipiscing elit. > > Aenean commodo ligula eget dolor.
    • Markdown Input
      Markdown Output
      `function test() {console.log("hello world");}`

```javascript
function test() {
  console.log("hello world");
}
```
      `function test() {console.log("hello world");}` ```javascript function test() { console.log("hello world"); } ```
    • Markdown Input
      Markdown Output
      | Default      | Align center | Align right |
| ------------ | :----------: | ------: |
| Carrot       | Red          | 1,000   |
| Banana       | Yellow       | 32,000  |
      | Default | Align center | Align right | | ------------ | :----------: | ------: | | Carrot | Red | 1,000 | | Banana | Yellow | 32,000 | Also, you can copy & paste table from excel sheet
    • Markdown Input
      Markdown Output
      Issue no: #2
Mention: @yobi
commit: @763575 or @763575f177a4ce8b9370954de3ea1a1410205593

      Issue no: #2

      Mention: @yobi

      commit: @763575 or @763575

    Notification receivers
    Drag & Drop files here to upload.
    Tasks

    특정 테이블만 exp/imp#

    export NLS_LANG=KOREAN_KOREA.UTF8
exp userid=testuser/test1234 tables=SFCMTCT_CODE file= expdata_code.dmp

export NLS_LANG=KOREAN_KOREA.UTF8
imp userid=testuser/test1234 \
file='/home/oracle/tmp/expdata_code.dmp' \
tables=SFCMTCT_CODE fromuser=testuser touser=testuser
    • 참고 : 테이블 삭제후 완전 삭제 : PURGE RECYCLEBIN;
    Reply
Add a comment
New subtask
Assignee
No assignee
Due date
No due date
Label
oracle
Keyboard shortcuts