473,396 Members | 1,966 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

HELP - Export/Import with version 8.05

Group,

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
file=prod.exp

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.

Thanks,
Julie

Jan 4 '07 #1
0 3693

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

Similar topics

4
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 Database, it is also using oracle froms version 3...
3
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 production machine where it uses the hosting...
5
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 anyone seen this, and what is the solution? --...
3
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, and it worked well enough for me, so it's been...
1
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 seems rather simple, it is the import that is not...
12
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 data base and insert into a SQL server Database....
2
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 I need to do is export data from the Company then...
1
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 schemas are created using 'CCSID UNICODE'. I used...
0
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 to older version, only the other way. hth ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.