472,325 Members | 1,005 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,325 software developers and data experts.

HELP - Export/Import with version 8.05


I'm running Oracle 8.05 with Solaris 6.

I have a database with several schemas, and I want to create a test
schema from one of the other ones. I'm having a problem with my
export/import procedures.

I created the schema:
grant connect,resource to tst identified by tst;
grant DBA to tst;
revoke unlimited tablespace from tst;
alter user tst default tablespace TST quota unlimited on TST;
alter user tst temporary tablespace temp;
grant create public synonym to tst;
grant drop public synonym to tst;
grant create user to tst;
grant drop user to tst;

Exported from prod with a table list:
exp userid=prod/prod parfile=tables.lst file=prod.exp

Then imported for the tst user
imp userid=tst/tst fromuser=prod touser=tst parfile=tables.lst

The import gives this:
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace SYSTEM
Then it shows my CREATE TABLE statement.

This repeats for every table that needs to be created, then you get the
errors that the table doesn't exist when you try to load the data.

Naturally, I looked up all the exp/imp info I could, but no mention of
granting access to create tables when you're loading into your own
tablespace. I assume that my import, with all it's references to tst, is
using the tst tablespace, right?

Can some kind soul please explain this to me? Other than pointing out
that I didn't grant privileges to tst on the SYSTEM tablespace: I know
that much.


Jan 4 '07 #1
0 3600

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Azhar Bilgrami | last post by:
Dear Hi: Hope to see u in good health. " I want to migrate a database which is currently running Unix as Operating System and Oracle ver 6 as...
by: Bennett Haselton | last post by:
I'm working on an ASP.Net project where I want to test code on a local machine using a local database as a back-end, and then export it to the...
by: steve | last post by:
Hi, When I copy tables in a database from one server to another using enterprise manager, everything copies ok, except for field defaults. Has...
by: Simon Brooke | last post by:
As various people will have noticed, I've been having a lot of trouble with XSL lately. Brief history: I wrote myself an XML toolkit back in 2000,...
by: InvestorTrade | last post by:
Hi, I've been trying to export/import a table from a DB with Chinese_PRC_CI_AS collation, and I can't seem to get it working at all - the export...
by: joaotsetsemoita | last post by:
Hello everyone, im completly new to vb.net and I was assigned to do a simple piece of software that just had to select from um db in a MS access...
by: gblaxx42 | last post by:
I created a DB to track soldier information. Each month reports are due to Brigade. Each Company and Battalion has there own version of the DB. What...
by: tong_su | last post by:
Hi, I am using udb version 8 fixpack 12 installed on Linux. I need to move a schema from one db to another. All tables in the target and source...
by: GBR | last post by:
As far as I know you need to use the 8i export to export the 9i database, but I'm not completly sure as I've never done a export/import from newer...
by: tammygombez | last post by:
Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.