I am trying to move data between schemas and tablespaces in an oracle 9i database.
Say I have a schema 'bob'.
bob has a table named 'X'.
X lives in the tablespace 'one'.
what I want to do is move the table into a new schema call 'bill'
I have exported the data using exp.
I have imported the adta using imp. (fromuser/touser)
but the problem is that when the table X is imported into bill... it still lives in the old tablespace 'one'.
Is there a way to specify which tablespace to import into???
Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.