restore a dump from another system

[ChrisQuick]

One of our clients has sent us a dump of their Oracle 8.0.5 datbase from an NT Server. I am trying to restore in on a NT Workstation Laptop that also has 8.0.5. I've gotten as far as creating a new schema and instance, and importing the users and roles and some of the tables. Unfortunetly, not all of the tables are importing.

I've tried doing it at a DOS prompt with:
IMP80 USERNAME/PASSWORD@SID but can't scroll back up to see the error message. I know that one of the most important tables isn't being created but I can't figure out why.

I've also tried using the Data Manager, but it doesn't seem to work either. When I get to the final step in the wizard, the Import Status window displays no contents at all.

To be even stranger, when I go into Enterprise Manager and connect as the schema owner (to start Data Manager),I get a message that the user who owns the schema is already logged in from machine "XXXX". The machine name is one that I know belongs to the client because I know their naming convention for workstations, and there is NO WAY at all that they are logged into this database.

Does any one have any suggestions on what might be wrong here? Please be as detailed with your suggestions as possible, because I am NOT a DBA. [sig][/sig]

 

[karluk]

I don't know what's going wrong, but I suggest that you try using parameter driven import. That will allow you to specify an output file where you will be able to see the error messages.

The command will be something like the following

imp80 userid=USERNAME/PASSWORD@SID file=export_file_name log=log_file_name

There are a lot of other parameters that may be needed, depending on what you are trying to do. If you need help try imp80 help=y to get a list of parameters and their defaults. [sig][/sig]

 

[connectxyzzy]

Just a WAG, but my bet is that you're running out of space somewhere.

Run this query for grins:

Select tablespace_name,bytes from dba_free_space
order by 1


Thenrun:
select tablespace_name, bytes from dba_data_files order by 1

if any tablespaces exist in the second list that had no entries (or significant amounts of space left) then you may have to expand the tablespaces datafiles.

There are other remedies for space probs. if that turns out to be it.
[sig][/sig]

 

[ChrisQuick]

Thanks for the input. karluk's suggestion allowed me to capture the output and it was a table_space issue. The table spaces files according to the dump were to be on the "e" drive and the problem was I don't have one. I created the table_spaces on "d" and it worked. [sig][/sig]