Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

import of views 1

Status
Not open for further replies.
smacattack

smacattack

Technical User
Jun 25, 2001
102
GB
I have exported a database at user level on a oracle 7 database.
I want to import onto a oracle 8i database but only want to import the views. How do i specify only views!?
Can anybody shed some light on the matter.
 
Sort by date Sort by votes
With
FULL=N
ROWS=N

you'll get:

Tables creation (with no data) (maybe needed for views working)
Views
Indexes (maybe needed for views optimization)
Access Rights (maybe needed for views working)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
416
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
203
Livia8
Livia8
torturedmind
  • Locked
  • Question
Week of the year
Replies
0
Views
88
torturedmind
torturedmind
Livia8
  • Locked
  • Question
Generate report/output on the basis of "enquiry" responsibilities only 1
Replies
16
Views
184
Livia8
Livia8
Andrzejek
  • Locked
  • Question
Modify columns - parts of virtual column 2
Replies
8
Views
826
carp
carp

Part and Inventory Search

Sponsor

Back
Top