Re: import a dump file from another oracle question.

Do you have any docs..If so, read them.

At a minimum you need to have the tablespaces pre-created... if no MEMBERS one exists, using IGNORE='Y' will cause the tables to be placed in the system user's default tablespace ( not a great idea, since it is probably the system tablespace which you should not use )..

"Michael Wu" <kuohwa_at_ms21.hinet.net> wrote:

>Dear All,
>
>Does import a dump file from production to test environment, need to create
>user or grant some special right?
>
>Our company use 8.1.6.0.0 oracle server, Sun OS 2.7, Sun 3500, 4 cpu, 4GB
>RAM. and the testing environment has the same level of software and OS, but
>maching was samll, only Netra T1, 512 MB, 1cpu.
>
>I've dump a export from production using follow command:
>
>exp userid=sys/abcdef_at_production file=/export/home/tmp/product.dmp
>compress=n full=y direct=y log=pays.log
>
>when I import then using follow commnad:
>
>imp userid=system/manager_at_test file=product.dmp full=y log=test.log
>
>but it shows a message such:
>
>ORA-01658: unable to create INITIAL extent for segment in tablespace MEMBERS
>
>ORA-01950: no privileges on tablespace 'MEMBERS'
>
>Should I grant proper privilege to each user before import?
>
>Thank you very much!!
>
>Best Regards
>Michael Wu
>
>kuohwa_at_ms21.hinet.net
>
>
>
>

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Thu Jun 13 2002 - 15:14:10 CDT